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

150 columns | Print definition?ERP 6.0  | BSCHL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/FORDOCLINEDocument line details : Posting key & Block indication4BSCHLPosting Keynvarchar20
2/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta17BSCHLnvarchar20
3/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta17BSCHLnvarchar20
4/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items13BSCHLnvarchar20
5/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact13BSCHLnvarchar20
6/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta15BSCHLnvarchar20
7/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items13BSCHLnvarchar20
8/CCEE/SIFIPOBOTIePoboti: Obligatory manysided reconciliation - XML output23BSCHLPosting Keynvarchar20
9/CCEE/SIFI_CDTYPSI: Cash Sales report - document type assignment4BSCHLPosting Keynvarchar20
10/OPT/AT_APPR_HISApproval History for Level Based Approvals108BSCHLPosting Keynvarchar20
11/OPT/AT_LBA_LOGApproval History for Level Based Approvals109BSCHLPosting Keynvarchar20
12/OPT/VIM_1CLEAR/OPT/VIM_1HEAD Extension with Clearing Documents (BSAK)12BSCHLPosting Keynvarchar20
13BOE_COL_ITEMCollection item data table16BSCHLPosting Keynvarchar20
14BOE_DIS_ITEMDiscount item data table5BSCHLPosting Keynvarchar20
15BOE_PAY_ITEMPayment item data table5BSCHLPosting Keynvarchar20
16BSAD_BAKAccounting: Secondary index for customers (cleared items)19BSCHLPosting Keynvarchar20
17BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)19BSCHLPosting Keynvarchar20
18BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)16BSCHLPosting Keynvarchar20
19BSEGAccounting Document Segment10BSCHLPosting Keynvarchar20
20BSID_BAKAccounting: Secondary Index for Customers19BSCHLPosting Keynvarchar20
21BSIK_BAKAccounting: Secondary index for vendors19BSCHLPosting Keynvarchar20
22BSIS_BAKAccounting: Secondary Index for G/L Accounts16BSCHLPosting Keynvarchar20
23BSSEGAccounting Document Segment10BSCHLPosting Keynvarchar20
24FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)16BSCHLPosting Keynvarchar20
25FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts16BSCHLPosting Keynvarchar20
26FIDOC_EOPDocument extract for EOP check6BSCHLPosting Keynvarchar20
27FIEUD_FIDOC_ISAFT: FI Transaction Document Item68BSCHLPosting Keynvarchar20
28FUCNBUSTRANAssign Document Type to Entry Layout6BSCHLPosting Key Indicatornvarchar10
29FUDT_VDOCBSEGVerification Document Item with Additional Info10BSCHLPosting Keynvarchar20
30FUDT_VDOCBSEGEVVerification Document Item in the Entry View10BSCHLPosting Keynvarchar20
31FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)10BSCHLPosting Keynvarchar20
32GLPOS_C_CTFI Document: Entry View63BSCHLPosting Keynvarchar20
33GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items63BSCHLPosting Keynvarchar20
34GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items63BSCHLPosting Keynvarchar20
35GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items63BSCHLPosting Keynvarchar20
36GLPOS_N_CTNew General Ledger: Line Item with Currency Type63BSCHLPosting Keynvarchar20
37GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type63BSCHLPosting Keynvarchar20
38J_1AWTH_TAX_PSTKConditions per Posting Key for Applying WithholdingTax3BSCHLPosting Keynvarchar20
39MHNDDunning Data25BSCHLPosting Keynvarchar20
40REGUPProcessed items from payment program25BSCHLPosting Keynvarchar20
41T017is being deleted3BSCHLG/L Accounts Posting Keynvarchar20
42TBSLPosting Key2BSCHLPosting Keynvarchar20
43TBSLTPosting Key Names3BSCHLPosting Keynvarchar20
44VIYCEXPITEMExpense Items16BSCHLPosting Keynvarchar20
TOPAccounting Interface
45GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)80BSCHLPosting Keynvarchar20
46GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)80BSCHLPosting Keynvarchar20
TOPAlternative Valuation Run
47CKMLAVRDOCITLines for Cumulation Posting Document21BSCHLPosting Keynvarchar20
TOPBasic Functions
48BSIWIndex table for customer bills of exchange used12BSCHLPosting Keynvarchar20
49BSIXIndex table for customer bills of exchange used12BSCHLPosting Keynvarchar20
TOPCentral Cash Desk Procedure
50FMFGT_IPAC_ACCTList of DIT & FBT Accounts for IPAC Interface Process6BSCHLPosting Keynvarchar20
TOPCross-Application Components
51BBSIDAccounting: Secondary index for customers19BSCHLPosting Keynvarchar20
52J_2GLPFILogical Papers for FI5BSCHLPosting Keynvarchar20
TOPData Retention Tool
53TXW_S_BSEGRetrieve BSEG from archive13BSCHLPosting Keynvarchar20
TOPElectronic Bank Statement
54FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)6BSCHLPosting Keynvarchar20
55FEB_ACTAcct Assignment Templates6BSCHLPosting Keynvarchar20
56FEB_ITEM_SAVESaving of Posting Items for Postprocessing (On Account)6BSCHLPosting Keynvarchar20
TOPExtended Rebate
57BON_ENH_LEDGERReconciliation Accounts for Rebate Credit Memos7BSCHLPosting Keynvarchar20
TOPExtra Charge
58/BEV1/ECMITDExtra Charge Reconciliation Accounts8BSCHLPosting Keynvarchar20
TOPFinancial Accounting
59ACCTITCompressed Data from FI/CO Document24BSCHLPosting Keynvarchar20
60BSADAccounting: Secondary Index for Customers (Cleared Items)19BSCHLPosting Keynvarchar20
61BSAKAccounting: Secondary Index for Vendors (Cleared Items)19BSCHLPosting Keynvarchar20
62BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)16BSCHLPosting Keynvarchar20
63BSIDAccounting: Secondary Index for Customers19BSCHLPosting Keynvarchar20
64BSIKAccounting: Secondary Index for Vendors19BSCHLPosting Keynvarchar20
65BSISAccounting: Secondary Index for G/L Accounts16BSCHLPosting Keynvarchar20
66DOCCHG_EWBUCHCustomizing of Posting Transaction3BSCHLPosting Keynvarchar20
67EBSEGDoc.Segment of Fin.Accntng External Documents9BSCHLPosting Keynvarchar20
68ICRCAICRC: Items to be Reconciled19BSCHLPosting Keynvarchar20
69ICRCUICRC: Potentially Differing Document Groups19BSCHLPosting Keynvarchar20
70ICRCZICRC: Reconciled, Completed Items19BSCHLPosting Keynvarchar20
71J_1GJR_PKPosting key descriptions in Journal4BSCHLPosting Keynvarchar20
72J_1GMYF2Customer/Vendor invoice selection criteria5BSCHLPosting Keynvarchar20
73J_5KFH_CADVTYPEAdvance accounting control settings3BSCHLPosting Keynvarchar20
74KMZEIFI: Account Assignment Model Item Information6BSCHLPosting Keynvarchar20
75KOMUAccount Assignment Templates for G/L Account Items6BSCHLPosting Keynvarchar20
76VBSEGADocument Segment for Document Parking - Asset Database8BSCHLPosting Keynvarchar20
77VBSEGDDocument Segment for Customer Document Parking8BSCHLPosting Keynvarchar20
78VBSEGKDocument Segment for Vendor Document Parking8BSCHLPosting Keynvarchar20
79VBSEGSDocument Segment for Document Parking - G/L Account Database8BSCHLPosting Keynvarchar20
TOPFlexible Real Estate Management
80VIXCOTDOCCOA, Distribution of VAT, Documents12BSCHLPosting Keynvarchar20
TOPFund Accounting
81FMGLFLEXAGeneral Ledger: Actual Line Items41BSCHLPosting Keynvarchar20
82PSGLFLEXAGeneral Ledger: Actual Line Items45BSCHLPosting Keynvarchar20
TOPFunds Management-Specific Postings
83FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years10BSCHLPosting Keynvarchar20
84PAYAC10Posting Key per DR/CR Indicator5BSCHLPosting Keynvarchar20
85PSOSEGADocument Segment for Assets Document Parking9BSCHLPosting Keynvarchar20
86PSOSEGDDocument Segment: Recurring Request, Customer9BSCHLPosting Keynvarchar20
87PSOSEGKRecurring Request Document Segment, Vendors9BSCHLPosting Keynvarchar20
88PSOSEGSRecurring Request Document Segment, G/L Accounts9BSCHLPosting Keynvarchar20
TOPGeneral Ledger Accounting
89BSEG_ADDEntry View of Accounting Document for Additional Ledgers8BSCHLPosting Keynvarchar20
90FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)16BSCHLPosting Keynvarchar20
91FAGLBSISAccounting: Secondary Index for G/L Accounts16BSCHLPosting Keynvarchar20
92FAGLFLEXAGeneral Ledger: Actual Line Items43BSCHLPosting Keynvarchar20
93FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items20BSCHLPosting Keynvarchar20
94FAGL_SPLINFOSplittling Information of Open Items52BSCHLPosting Keynvarchar20
TOPInformation System
95BWPOSValuations for Open Items26BSCHLPosting Keynvarchar20
96DKKOPBalance Audit Trail29BSCHLPosting Keynvarchar20
97DKOKPOpen Item Account Balance Audit Trail32BSCHLPosting Keynvarchar20
98DSKOPBalance Audit Trail28BSCHLPosting Keynvarchar20
TOPJoint Venture und Production Sharing Accounting
99JVGLFLEXAGeneral Ledger: Actual Line Items45BSCHLPosting Keynvarchar20
TOPLocalization
100ISJPSELECTIONSelection of line items for Invoice Summary4BSCHLPosting Keynvarchar20
101J_1BIMFIMovement Types for Vendor Invoices (Brazil)5BSCHLPosting Keynvarchar20
102J_1IEWT_CUSTCustomer certificates ,Challan customizing EWT- India6BSCHLPosting Keynvarchar20
103J_3RFTAX_EXTRDTax Extract Detail Lines16BSCHLPosting Keynvarchar20
104J_3RNKS_TBSLCredit memo posting keys for AuC2BSCHLPosting Keynvarchar20
105RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions16BSCHLPosting Keynvarchar20
106RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions16BSCHLPosting Keynvarchar20
107RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions16BSCHLPosting Keynvarchar20
TOPPatient Accounting
108TN22PIS-H: Control Parameters FI Posting Down Payment11BSCHLIS-H: Posting key for bank postingnvarchar20
109TN22RIS-H: Control Params FI Posting Copayment/Copay.Cred.Memo9BSCHLIS-H: Posting key for bank postingnvarchar20
TOPPayment Transactions
110FPRL_ITEMItem Data33BSCHLPosting Keynvarchar20
TOPPeriodical Sales and Distribution
111JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS9BSCHLPosting Keynvarchar20
TOPPOS Interface
112TWPIFTransaction type-dependent control of POS financial trans.5BSCHLPosting Keynvarchar20
TOPReal Estate Management
113VIAKBSEGDocument Line Item from SCS for Interface32BSCHLPosting Keynvarchar20
TOPRemaining Beverage - Obsolete Objects
114/BEV1/BO_LEDGERReconciliation Accounts for Rebate Credit Memos7BSCHLPosting Keynvarchar20
115/BEV1/RBMITDRebate Reconciliation Accounts7BSCHLPosting Keynvarchar20
116/BEV3/CH1030BSG1Document Segment CH Event Ledger Part112BSCHLPosting Keynvarchar20
117/BEV3/CHABRSTZ_PCH Settlement Items - With Translations55BSCHLPosting Keynvarchar20
118/BEV3/CHA_DRGZUOAssignment CH business transactions to print groups4BSCHLPosting keynvarchar20
119/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items56BSCHLPosting Keynvarchar20
120/BEV3/CHCEV1030XCH BTE Allowed 00001030 Data6BSCHLPosting Keynvarchar20
121/BEV3/CHCEV103XCH BTE Permissible Events Res. frm Combination CHD/1030 Data8BSCHLPosting Keynvarchar20
122/BEV3/CHCEVACDTAssignment to posting, document and to-settlement date (BTE)5BSCHLPosting Keynvarchar20
123/BEV3/CHCEVACPRSelection of posting line for the date compensation (BTE)5BSCHLPosting Keynvarchar20
124/BEV3/CHCEVLASFICH BTE: Customizing Event Listener Assessment FI4BSCHLPosting Keynvarchar20
125/BEV3/CHCEVLCACCH BTE Customizing Event Listener ACCOUNT6BSCHLPosting Keynvarchar20
126/BEV3/CHCEVLCAFICH BTE: Customizing Event Listener Assessment FI5BSCHLPosting Keynvarchar20
127/BEV3/CHCIVRG01CI: Customizing Business Process Detail 00015BSCHLPosting Keynvarchar20
128/BEV3/CHCI_VORGCustomizing Business Processes Header Data4BSCHLPosting Keynvarchar20
129/BEV3/CHCTBSCHLPosting key dependent on CoCd,acc. type/Datepart,sett.method6BSCHLPosting Keynvarchar20
130/BEV3/CHCTKMPBCHComplement Postings (BTE)5BSCHLPosting Keynvarchar20
131/BEV3/CHCTKONTCustomizing Account View7BSCHLPosting Keynvarchar20
132/BEV3/CHCTSTBSHLPosting key dependent on CoCd,acc. type/Datepart,sett.method6BSCHLPosting Keynvarchar20
133/BEV3/CHCTSTRKZCH Settlement Tax Indicator6BSCHLPosting Keynvarchar20
134/BEV3/CHCVALI1Customizing Validation FI - CH Transactions6BSCHLPosting Keynvarchar20
135/BEV3/CHERGSTZ_PCH Settlement Items - With Translations55BSCHLPosting Keynvarchar20
136/BEV3/CHERGSTZ_SCH Settlement Statistics56BSCHLPosting Keynvarchar20
137/BEV3/CHEVLIASFICH BTE Event Listener Assessment FI9BSCHLPosting Keynvarchar20
138/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics55BSCHLPosting Keynvarchar20
139/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)55BSCHLPosting Keynvarchar20
140/BEV3/CHSHTSTZ_PCH Settlement Item55BSCHLPosting Keynvarchar20
141/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions56BSCHLPosting Keynvarchar20
142/BEV3/CHSIMSTZ_PCH Simulation Items55BSCHLPosting Keynvarchar20
143/BEV3/CHSIMSTZ_SCH Simulation Statistics56BSCHLPosting Keynvarchar20
144/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item56BSCHLPosting Keynvarchar20
145/BEV3/CHTRMSTZ_PCH Date Item55BSCHLPosting Keynvarchar20
146/BEV3/CHTRMSTZ_SCH Date Statistics56BSCHLPosting Keynvarchar20
147/BEV3/CHVABRSTZSCH Settlement Statistics56BSCHLPosting Keynvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
148TN22GIS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung8BSCHLIS-H: Buchungsschlüssel für Bankbuchungnvarchar20
TOPSpecial Purpose Ledger
149/CCIS/PROFTAXAActual Line Items Table for General Ledger53BSCHLPosting Keynvarchar20
TOPTraders and Schedulers Workbench
150OIJ_RU_FI_POSTDefine posting parameters3BSCHLPosting Keynvarchar20