SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

91 columns | Print definition?B1 8.82  | 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
12IGE15Gds Issue - Drawn Dpm Applied13VatSumFcTax FCNum196
13IGE6Goods Issue - Installments15VatSumFCTax Amount (FC)Num196
14IGN15Gds Rcpt - Drawn Dpm Applied13VatSumFcTax FCNum196
15IGN6Goods Receipt- Installments15VatSumFCTax Amount (FC)Num196
16OIGEGoods Issue19VatSumFCTax Amount (FC)Num196
17OIGNGoods Receipt19VatSumFCTax Amount (FC)Num196
18OWTQInventory Transfer Request19VatSumFCTax Amount (FC)Num196
19OWTRInventory Transfer19VatSumFCTax Amount (FC)Num196
20WTQ15Inv. Transfer Request - Drawn Dpm Appl13VatSumFcTax FCNum196
21WTQ6Inventory Transfer Request - Installments15VatSumFCTax Amount (FC)Num196
22WTR15Inv. Transfer - Drawn Dpm Appl13VatSumFcTax FCNum196
23WTR6Inventory Transfer - Installments15VatSumFCTax Amount (FC)Num196
TOPMarketing Documents
24ADO15A/R Inv (Drawn Dpm Applied) - Hist13VatSumFcTax FCNum196
25ADO6Documents History - Installments15VatSumFCTax Amount (FC)Num196
26ADOCInvoice - History19VatSumFCTax Amount (FC)Num196
27CIN6Correction Invoice - Installments15VatSumFCTax Amount (FC)Num196
28CPI15A/P Corr Inv - Drawn Dpm Appld13VatSumFcTax FCNum196
29CPI6Documents History - Installments15VatSumFCTax Amount (FC)Num196
30CPV15A/P CrIn Rev - Drawn Dpm Appld13VatSumFcTax FCNum196
31CPV6A/P Correction Invoice Reversal - Installments15VatSumFCTax Amount (FC)Num196
32CSI15A/R Corr Inv - Drawn Dpm Appld13VatSumFcTax FCNum196
33CSI6A/R Corr. Inv. - Installments15VatSumFCTax Amount (FC)Num196
34CSV15A/R CrIn Rev - Drawn Dpm Appld13VatSumFcTax FCNum196
35CSV6A/R Correction Invoice Reversal - Installments15VatSumFCTax Amount (FC)Num196
36DLN15Delivery - Drawn Dpm Applied13VatSumFcTax FCNum196
37DLN6Delivery - Installments15VatSumFCTax Amount (FC)Num196
38DPI15A/R DP - Drawn Dpm Applied13VatSumFcTax FCNum196
39DPI6A/R Down Payment - Installments15VatSumFCTax Amount (FC)Num196
40DPO15A/P DP - Drawn Dpm Applied13VatSumFcTax FCNum196
41DPO6Down Payment Out - Installments15VatSumFCTax Amount (FC)Num196
42DRF15Draft - Drawn Dpm Applied13VatSumFcTax FCNum196
43DRF6Document Drafts - Installments15VatSumFCTax Amount (FC)Num196
44IEI15IEI - Drawn Dpm Applied13VatSumFcTax FCNum196
45IEI6IEI - Installments15VatSumFCTax Amount (FC)Num196
46INV15A/R Inv. - Drawn Dpm Applied13VatSumFcTax FCNum196
47INV6A/R Invoice - Installments15VatSumFCTax Amount (FC)Num196
48OCINA/R Correction Invoice19VatSumFCTax Amount (FC)Num196
49OCPIA/P Correction Invoice19VatSumFCTax Amount (FC)Num196
50OCPVA/P Correction Invoice Reversal19VatSumFCTax Amount (FC)Num196
51OCSIA/R Correction Invoice19VatSumFCTax Amount (FC)Num196
52OCSVA/R Correction Invoice Reversal19VatSumFCTax Amount (FC)Num196
53ODLNDelivery19VatSumFCTax Amount (FC)Num196
54ODPIA/R Down Payment19VatSumFCTax Amount (FC)Num196
55ODPOA/P Down Payment19VatSumFCTax Amount (FC)Num196
56ODRFDrafts19VatSumFCTax Amount (FC)Num196
57OEI15OEI - Drawn Dpm Applied13VatSumFcTax FCNum196
58OEI6Outgoing Excise Invoice - Installments15VatSumFCTax Amount (FC)Num196
59OIEIIncoming Excise Invoice19VatSumFCTax Amount (FC)Num196
60OINVA/R Invoice19VatSumFCTax Amount (FC)Num196
61OOEIOutgoing Excise Invoice19VatSumFCTax Amount (FC)Num196
62OPCHA/P Invoice19VatSumFCTax Amount (FC)Num196
63OPDNGoods Receipt PO19VatSumFCTax Amount (FC)Num196
64OPORPurchase Order19VatSumFCTax Amount (FC)Num196
65OPQTPurchase Quotation19VatSumFCTax Amount (FC)Num196
66OQUTSales Quotation19VatSumFCTax Amount (FC)Num196
67ORDNReturns19VatSumFCTax Amount (FC)Num196
68ORDRSales Order19VatSumFCTax Amount (FC)Num196
69ORINA/R Credit Memo19VatSumFCTax Amount (FC)Num196
70ORPCA/P Credit Memo19VatSumFCTax Amount (FC)Num196
71ORPDGoods Return19VatSumFCTax Amount (FC)Num196
72PCH15A/P Invoice - Drawn Dpm Appld13VatSumFcTax FCNum196
73PCH6A/P Invoice - Installments15VatSumFCTax Amount (FC)Num196
74PDN15GRPO - Drawn Dpm Applied13VatSumFcTax FCNum196
75PDN6Goods Receipt PO - Installments15VatSumFCTax Amount (FC)Num196
76POR15PO - Drawn Dpm Applied13VatSumFcTax FCNum196
77POR6Purchase Order - Installments15VatSumFCTax Amount (FC)Num196
78PQT15PQ - Drawn DPM Applied13VatSumFcTax FCNum196
79PQT6Purchase Quotation - Installments15VatSumFCTax Amount (FC)Num196
80QUT15Sls Quote - Drawn Dpm Applied13VatSumFcTax FCNum196
81QUT6Sales Quotation - Installments15VatSumFCTax Amount (FC)Num196
82RDN15Returns - Drawn Dpm Applied13VatSumFcTax FCNum196
83RDN6Returns - Installments15VatSumFCTax Amount (FC)Num196
84RDR15Sls Ord. - Drawn Dpm Applied13VatSumFcTax FCNum196
85RDR6Sales Order - Installments15VatSumFCTax Amount (FC)Num196
86RIN15A/R Cr. Memo - Drawn Dpm Appld13VatSumFcTax FCNum196
87RIN6A/R Credit Memo - Installments15VatSumFCTax Amount (FC)Num196
88RPC15A/P Cr. Memo - Drawn Dpm Appld13VatSumFcTax FCNum196
89RPC6A/P Credit Memo - Installments15VatSumFCTax Amount (FC)Num196
90RPD15Gds Return - Drawn Dpm Applied13VatSumFcTax FCNum196
91RPD6Goods Return - Installments15VatSumFCTax Amount (FC)Num196