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
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

136 columns | Print definition?B1 9.3  | DOCTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log3DocTypeDocument TypenVarChar200
2DAR2Data Archive - Transaction Log4DocTypeDocument TypeInt110
3DAR3Data Archive - Handwritten Documents3DocTypeDocument TypenVarChar200
4FTT1Financial Template Import - Files8DocTypeTemplate TypeVarChar10BA=Cost Accounting, B=Balance Sheet, C=Trial Balance, D=Profit Distribution, E=Asset Devalue Provision, F=Statement of Cash Flows, G=Others, H=Asset History Sheet, I=Taxable Profit and Loss, J=Appropriation of Net Profit, K=E-Asset History Sheet, L=e-Balance Sheet, O=e-Profit and Loss, P=Profit and Loss, R=Shareholder's Rights and Interests
5OTCXTax Code Determination3DocTypeDocument TypeInt1100=Item, 1=Service, 2=Item & Service
TOPBanking
6ARCTIncoming Payment - History3DocTypeDocument TypeVarChar10CA=Account, C=Customer, D=Yes, P=P.L.A, S=Vendor, T=TDS
7BNK2Bank Statement - Recommendation List5DocTypeDocument TypeInt60-1=All transactions, -2=Opening Balance, -3=Closing Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Returns, 24=Incoming Payment, 25=Deposit, 30=Journal Entry, 46=Payment Advice, 57=Che
8ODTYBoE Document Type2DocTypeDocument TypenVarChar20
9OPDFPayment Draft3DocTypeDocument TypeVarChar10A=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor
10OPYMPayment Methods for Payment Wizard36DocTypeBoE Document TypenVarChar20
11ORCTIncoming Payment3DocTypeDocument TypeVarChar10CA=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor, T=Tax
12OVPMOutgoing Payments3DocTypeDocument TypeVarChar10SA=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor, T=Tax
TOPBusiness Partners
13ACLGActivities - History14DocTypeLinked DocumentnVarChar200-1112=Document Drafts, 123=Checks for Payment Drafts, 1250000001=Inventory Transfer Request, 1250000025=Blanket Agreements, 1320000012=Campaign, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 140=Payment Drafts, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, 162=Ma
14ACP1Campaign - BPs29DocTypeDocument TypenVarChar200-1-97=Purchase Opportunities, 18=A/P Invoices, 20=Goods Receipt POs, 22=Purchase Orders, 540000006=Purchase Quotations, D=Deliveries, I=A/R Invoices, O=Sales Orders, P=Opportunities, Q=Sales Quotations
15CPN1Campaign - BPs29DocTypeDocument TypenVarChar200-1-97=Purchase Opportunities, 13=A/R Invoices, 15=Deliveries, 17=Sales Orders, 18=A/P Invoices, 20=Goods Receipt POs, 22=Purchase Orders, 23=Sales Quotations, 540000006=Purchase Quotations, 97=Sales Opportunities
16OCLGActivities14DocTypeLinked DocumentnVarChar200-1112=Document Drafts, 123=Checks for Payment Drafts, 1250000001=Inventory Transfer Request, 1250000025=Blanket Agreements, 1320000012=Campaign, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 140=Payment Drafts, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, 162=Ma
TOPFinance
17AFADAsset Document - History31DocTypeDocument TypenVarChar150PLAP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation
18AJD1Journal Entry - History - Rows132DocTypeSource Document TypenVarChar200
19AJDTJournal Entry - History52DocTypeDocument TypenVarChar600
20BTF1Journal Voucher - Rows132DocTypeSource Document TypenVarChar200
21GBI7GBI Row 7 - Accounting Vouchers4DocTypeDocument TypenVarChar120
22JDT1Journal Entry - Rows132DocTypeSource Document TypenVarChar200
23OACDCredit Memo31DocTypeDocument TypenVarChar150PLAP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation
24OACQCapitalization31DocTypeDocument TypenVarChar150PLAP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation
25OBTFJournal Voucher Entry52DocTypeTransact. TypenVarChar600
26OFRTFinancial Report Templates3DocTypeTemplate TypeVarChar10BA=Cost Accounting, B=Balance Sheet, C=Trial Balance, D=Profit Distribution, E=Asset Devalue Provision, F=Statement of Cash Flows, G=Others, H=Asset History Sheet, I=Taxable Profit and Loss, J=Appropriation of Net Profit, K=E-Asset History Sheet, L=e-Balance Sheet, O=e-Profit and Loss, P=Profit and Loss, R=Shareholder's Rights and Interests
27OFTRTransfer31DocTypeDocument TypenVarChar150PLAP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation
28OJDTJournal Entry52DocTypeDocument TypenVarChar600
29OMDPManual Depreciation31DocTypeDocument TypenVarChar150PLAP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation
30ORTIRetirement31DocTypeDocument TypenVarChar150PLAP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation
31OVTRTax Report17DocTypeA/P or A/RVarChar10PP=Purchasing Documents, R=Sales Documents
TOPGeneral
32APH4Project Management - Stages - Documents - History18DocTypeDocument TypeVarChar10II=Item, S=Service
33APM4Project Management - Stages - Documents - History18DocTypeDocument TypeVarChar10II=Item, S=Service
34ITMRITMR80DocTypeDocument TypenVarChar40
35OBVLSerial Numbers and Batch Valuation Log4DocTypeTransact. TypeInt110-1
36ODW1Default Open Documents2DocTypeOpen Document TypeInt110
37PHA4Project Management - Stages - Documents18DocTypeDocument TypeVarChar10II=Item, S=Service
38PMG4Project Management - Stages - Documents18DocTypeDocument TypeVarChar10II=Item, S=Service
39UBVLSerial Numbers and Batch Valuation Log4DocTypeTransact. TypeInt110-1
TOPInventory and Production
40IGE26Goods Issue - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
41IGN26Goods Receipt - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
42OIGEGoods Issue3DocTypeDocument TypeVarChar10II=Item, S=Service
43OIGNGoods Receipt3DocTypeDocument TypeVarChar10II=Item, S=Service
44OITLInventory Transactions Log8DocTypeTransact. TypeInt110-1
45ORTLResource Transaction Log3DocTypeTransact. TypeInt110
46OTNLCCD Log8DocTypeTransaction TypeInt110-1
47OWTQInventory Transfer Request3DocTypeDocument TypeVarChar10II=Item, S=Service
48OWTRInventory Transfer3DocTypeDocument TypeVarChar10II=Item, S=Service
49WTQ26Inventory Transfer Request - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
TOPMarketing Documents
50ADO26Mktg. Docs. - E-Way Bill Information - History4DocTypeEWB Doc. TypenVarChar30
51ADOCInvoice - History3DocTypeDocument TypeVarChar10II=Item, S=Service
52ATX1Tax Invoice - History - Rows4DocTypeDocument TypeVarChar10IC=Correction Invoice, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment
53ATXITax Invoice - History3DocTypeDocument TypeVarChar10IA=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry, P=Payment
54CIN26Correction Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
55CPI26A/P Correction Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
56CPV26A/P Correction Invoice Reversal - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
57CSI26A/R Correction Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
58CSV26A/R Correction Invoice Reversal - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
59DLN26Delivery - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
60DPI26Down Payment Inv. - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
61DPO26Down Payment - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
62DRF26Draft - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
63DWZ2Dunning Wizard Array 2-Invoice Filter17DocTypeSource TableInt110-2=Open Balance, -3=Close Balance, 13=A/R Invoice, 14=A/R Credit Memo, 165=Correction A/R Invoice, 203=Down Payment Incoming, 24=Incoming Payment, 30=Journal Transactions, 46=Outgoing Payments
64DWZ4Dunning Wizard Array 4-Paging Grid10DocTypeSource TableInt110-2=Open Balance, -3=Close Balance, 13=A/R Invoice, 14=A/R Credit Memo, 165=Correction A/R Invoice, 203=Down Payment Incoming, 24=Incoming Payment, 30=Journal Transactions
65GPA1Gross Profit Adjustment - Documents5DocTypeDocument TypenVarChar200
66GPA5Product Cost Adjustment - Recalculation of Product Cost9DocTypeChooseVarChar10II=Issue for Production, R=Receipt from Production
67GPA9Applied Gross Profit Adjustments4DocTypeDocument TypenVarChar200
68IEI26Incoming Excise Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
69INV26A/R Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
70IVM1Invoice Mapping Object Details3DocTypeDocument TypenVarChar200
71MIN1Monthly Invoice Report Document Information4DocTypeDocument Object IDnVarChar20013=A/R Invoice, 14=A/R Credit Memo
72MIN2Item Imformation of MI3DocTypeDocument TypenVarChar20013=A/R Invoice, 14=A/R Credit Memo
73MIV1A/P Monthly Invoice - Document4DocTypeDocument Object IDnVarChar20018=A/P Invoice, 19=A/P Credit Memo
74MIV2A/P Monthly Invoice - Item3DocTypeDocument TypenVarChar20018=A/P Invoice, 19=A/P Credit Memo
75OCINA/R Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
76OCPIA/P Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
77OCPVA/P Correction Invoice Reversal3DocTypeDocument TypeVarChar10II=Item, S=Service
78OCSIA/R Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
79OCSVA/R Correction Invoice Reversal3DocTypeDocument TypeVarChar10II=Item, S=Service
80ODLNDelivery3DocTypeDocument TypeVarChar10II=Item, S=Service
81ODPIA/R Down Payment3DocTypeDocument TypeVarChar10II=Item, S=Service
82ODPOA/P Down Payment3DocTypeDocument TypeVarChar10II=Item, S=Service
83ODRFDrafts3DocTypeDocument TypeVarChar10II=Item, S=Service
84OEI26Outgoing Excise Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
85OIEIIncoming Excise Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
86OINVA/R Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
87OOEIOutgoing Excise Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
88OPCHA/P Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
89OPDNGoods Receipt PO3DocTypeDocument TypeVarChar10II=Item, S=Service
90OPORPurchase Order3DocTypeDocument TypeVarChar10II=Item, S=Service
91OPQTPurchase Quotation3DocTypeDocument TypeVarChar10II=Item, S=Service
92OPRQPurchase Request3DocTypeDocument TypeVarChar10II=Item, S=Service
93OPRRGoods Return Request3DocTypeDocument TypeVarChar10II=Item, S=Service
94OQUTSales Quotation3DocTypeDocument TypeVarChar10II=Item, S=Service
95ORDNReturns3DocTypeDocument TypeVarChar10II=Item, S=Service
96ORDRSales Order3DocTypeDocument TypeVarChar10II=Item, S=Service
97ORINA/R Credit Memo3DocTypeDocument TypeVarChar10II=Item, S=Service
98ORPCA/P Credit Memo3DocTypeDocument TypeVarChar10II=Item, S=Service
99ORPDGoods Return3DocTypeDocument TypeVarChar10II=Item, S=Service
100ORRRReturn Request3DocTypeDocument TypeVarChar10II=Item, S=Service
101OSFCSelf Credit Memo3DocTypeDocument TypeVarChar10II=Item, S=Service
102OSFISelf Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
103OTPIPurchase Tax Invoice3DocTypeDocument TypeVarChar10IA=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry
104OTSISales Tax Invoice3DocTypeDocument TypeVarChar10IA=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, I=Invoice, J=Journal Entry, P=Payment
105OTXDTax Invoice Draft3DocTypeDocument TypeVarChar10IA=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry, P=Payment
106PCH26A/P Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
107PDN26Goods Receipt PO - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
108POR26Purchase Order - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
109PQT26Purchase Quotation - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
110PRQ26Purchase Request - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
111PRR26A/P Return Request - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
112QUT26Sales Quotation - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
113RDN26Returns - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
114RDR26Sales Order - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
115RIN26A/R Credit Memo - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
116RPC26A/P Credit Memo - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
117RPD26Goods Return - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
118RRR26A/R Return Request - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
119SFC26Self Credit Memo - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
120SFI26Self Invoice - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
121TGPAGross Profit Adjustment - Log6DocTypeDocument TypenVarChar200
122TPI1Purchase Tax Invoice - Rows4DocTypeDocument TypeVarChar10IC=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment
123TSI1Sales Tax Invoice - Rows14DocTypeDocument TypeVarChar10IC=Correction Invoice, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment
124TXD1Tax Invoice Drafts - Rows4DocTypeDocument TypeVarChar10IC=Correction Invoice, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment, R=Payment Request
125VRT2Tax Invoice Report Grid Info16DocTypeDocument TypeInt11013=A/R Invoice, 14=A/R Credit Memo, 203=A/R Down Payment
126WTR26Inventory Transfer - E-Way Bill Information4DocTypeEWB Doc. TypenVarChar30
TOPMRP
127MSN5MRP-Specific Document2DocTypeDocument TypenVarChar200
TOPReports
128AEC5List of Canceled Reconciliations for Actions in Electronic Communication3DocTypeDocument TypeInt110
129EBL1E-Balance Report Data6DocTypeDocument TypeVarChar100=XBRL
130ECDW1ECD Wizard - Rows 12DocTypeTemplate TypeVarChar10B=Balance Sheet, P=Profit and Loss
131ECM5List of Related Documents for Actions in Electronic Communication3DocTypeDocument TypeInt110
132ORFLAlready Displayed 347, 349 and WTax Reports2DocTypeDocument TypenVarChar20013=Invoice, 14=Revert Invoice, 18=Purchase, 19=Revert purchase, 203=A/R Down Payment, 204=A/P Down Payment
133SOI4Statement of Import - Invoices3DocTypeDocument TypeInt110
134SOI5Statement of Import - Lines3DocTypeDocument TypeInt110
TOPSales Opportunities
135AOPROpportunity46DocTypeLinked Document TypenVarChar90-113=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 18=Purchase Invoices, 20=Goods Receipt POs, 22=Purchase Orders, 23=Quotations, 540000006=Purchase Quotations
136OOPROpportunity46DocTypeLinked Document TypenVarChar90-113=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 18=Purchase Invoices, 20=Goods Receipt POs, 22=Purchase Orders, 23=Quotations, 540000006=Purchase Quotations