SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OBOT10Bill Of Exchang Transaction
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

85 columns | Print definition?B1 8.8  | VATSUMFC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC5Reciept log 12VatSumFcTax Amount (FC)Num196
2ARCTIncoming Payment - History72VatSumFCTax Amount (FC)Num196
3OPDFPayment Draft72VatSumFCTax Amount (FC)Num196
4ORCTIncoming Payment72VatSumFCTax Amount (FC)Num196
5OVPMOutgoing Payments72VatSumFCTax Amount (FC)Num196
6PDF5PaymentDraft - 12VatSumFcTax Amount (FC)Num196
7PMN5Payment - VAT Adjustment12VatSumFcTax Amount (FC)Num196
8RCT5Reciept vat adjustment12VatSumFcTax Amount (FC)Num196
9VPM5Outgoing Payments - Vat Adjustment12VatSumFcTax Amount (FC)Num196
TOPFinance
10TAX1VAT Transactions - Rows28VatSumFcVAT Sum (FC)Num196
11UTX1Unreported VAT Transactions - Rows28VatSumFcVAT Sum (FC)Num196
TOPInventory and Production
12IGE6Goods Issue - Installments15VatSumFCTax Amount (FC)Num196
13IGN6Goods Receipt- Installments15VatSumFCTax Amount (FC)Num196
14OIGEGoods Issue19VatSumFCTax Amount (FC)Num196
15OIGNGoods Receipt19VatSumFCTax Amount (FC)Num196
16OWTRInventory Transfer19VatSumFCTax Amount (FC)Num196
17WTR6Inventory Transfer - Installments15VatSumFCTax Amount (FC)Num196
TOPMarketing Documents
18ADO15A/R Inv (Drawn Dpm Applied) - Hist13VatSumFcTax FCNum196
19ADO6Documents History - Installments15VatSumFCTax Amount (FC)Num196
20ADOCInvoice - History19VatSumFCTax Amount (FC)Num196
21CIN6Correction Invoice - Installments15VatSumFCTax Amount (FC)Num196
22CPI15A/P Corr Inv - Drawn Dpm Appld13VatSumFcTax FCNum196
23CPI6Documents History - Installments15VatSumFCTax Amount (FC)Num196
24CPV15A/P CrIn Rev - Drawn Dpm Appld13VatSumFcTax FCNum196
25CPV6A/P Correction Invoice Reversal - Installments15VatSumFCTax Amount (FC)Num196
26CSI15A/R Corr Inv - Drawn Dpm Appld13VatSumFcTax FCNum196
27CSI6A/R Corr. Inv. - Installments15VatSumFCTax Amount (FC)Num196
28CSV15A/R CrIn Rev - Drawn Dpm Appld13VatSumFcTax FCNum196
29CSV6A/R Correction Invoice Reversal - Installments15VatSumFCTax Amount (FC)Num196
30DLN15Delivery - Drawn Dpm Applied13VatSumFcTax FCNum196
31DLN6Delivery - Installments15VatSumFCTax Amount (FC)Num196
32DPI15A/R DP - Drawn Dpm Applied13VatSumFcTax FCNum196
33DPI6A/R Down Payment - Installments15VatSumFCTax Amount (FC)Num196
34DPO15A/P DP - Drawn Dpm Applied13VatSumFcTax FCNum196
35DPO6Down Payment Out - Installments15VatSumFCTax Amount (FC)Num196
36DRF15Draft - Drawn Dpm Applied13VatSumFcTax FCNum196
37DRF6Document Drafts - Installments15VatSumFCTax Amount (FC)Num196
38IEI15IEI - Drawn Dpm Applied13VatSumFcTax FCNum196
39IEI6IEI - Installments15VatSumFCTax Amount (FC)Num196
40IGE15Gds Issue - Drawn Dpm Applied13VatSumFcTax FCNum196
41IGN15Gds Rcpt - Drawn Dpm Applied13VatSumFcTax FCNum196
42INV15A/R Inv. - Drawn Dpm Applied13VatSumFcTax FCNum196
43INV6A/R Invoice - Installments15VatSumFCTax Amount (FC)Num196
44OCINA/R Correction Invoice19VatSumFCTax Amount (FC)Num196
45OCPIA/P Correction Invoice19VatSumFCTax Amount (FC)Num196
46OCPVA/P Correction Invoice Reversal19VatSumFCTax Amount (FC)Num196
47OCSIA/R Correction Invoice19VatSumFCTax Amount (FC)Num196
48OCSVA/R Correction Invoice Reversal19VatSumFCTax Amount (FC)Num196
49ODLNDelivery19VatSumFCTax Amount (FC)Num196
50ODPIA/R Down Payment19VatSumFCTax Amount (FC)Num196
51ODPOA/P Down Payment19VatSumFCTax Amount (FC)Num196
52ODRFDrafts19VatSumFCTax Amount (FC)Num196
53OEI15OEI - Drawn Dpm Applied13VatSumFcTax FCNum196
54OEI6Outgoing Excise Invoice - Installments15VatSumFCTax Amount (FC)Num196
55OIEIIncoming Excise Invoice19VatSumFCTax Amount (FC)Num196
56OINVA/R Invoice19VatSumFCTax Amount (FC)Num196
57OOEIOutgoing Excise Invoice19VatSumFCTax Amount (FC)Num196
58OPCHA/P Invoice19VatSumFCTax Amount (FC)Num196
59OPDNGoods Receipt PO19VatSumFCTax Amount (FC)Num196
60OPORPurchase Order19VatSumFCTax Amount (FC)Num196
61OQUTSales Quotation19VatSumFCTax Amount (FC)Num196
62ORDNReturns19VatSumFCTax Amount (FC)Num196
63ORDRSales Order19VatSumFCTax Amount (FC)Num196
64ORINA/R Credit Memo19VatSumFCTax Amount (FC)Num196
65ORPCA/P Credit Memo19VatSumFCTax Amount (FC)Num196
66ORPDGoods Return19VatSumFCTax Amount (FC)Num196
67PCH15A/P Invoice - Drawn Dpm Appld13VatSumFcTax FCNum196
68PCH6A/P Invoice - Installments15VatSumFCTax Amount (FC)Num196
69PDN15GRPO - Drawn Dpm Applied13VatSumFcTax FCNum196
70PDN6Goods Receipt PO - Installments15VatSumFCTax Amount (FC)Num196
71POR15PO - Drawn Dpm Applied13VatSumFcTax FCNum196
72POR6Purchase Order - Installments15VatSumFCTax Amount (FC)Num196
73QUT15Sls Quote - Drawn Dpm Applied13VatSumFcTax FCNum196
74QUT6Sales Quotation - Installments15VatSumFCTax Amount (FC)Num196
75RDN15Returns - Drawn Dpm Applied13VatSumFcTax FCNum196
76RDN6Returns - Installments15VatSumFCTax Amount (FC)Num196
77RDR15Sls Ord. - Drawn Dpm Applied13VatSumFcTax FCNum196
78RDR6Sales Order - Installments15VatSumFCTax Amount (FC)Num196
79RIN15A/R Cr. Memo - Drawn Dpm Appld13VatSumFcTax FCNum196
80RIN6A/R Credit Memo - Installments15VatSumFCTax Amount (FC)Num196
81RPC15A/P Cr. Memo - Drawn Dpm Appld13VatSumFcTax FCNum196
82RPC6A/P Credit Memo - Installments15VatSumFCTax Amount (FC)Num196
83RPD15Gds Return - Drawn Dpm Applied13VatSumFcTax FCNum196
84RPD6Goods Return - Installments15VatSumFCTax Amount (FC)Num196
85WTR15Inv. Transfer - Drawn Dpm Appl13VatSumFcTax FCNum196