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

118 columns | Print definition?ERP 6.0  | BSTAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items14BSTATnvarchar10
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact14BSTATnvarchar10
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items14BSTATnvarchar10
4/CCEE/SIFIPOBOTIePoboti: Obligatory manysided reconciliation - XML output24BSTATDocument Statusnvarchar10
5/SAPF15/XXBPDKF15 FI DUMMY11BSTATnvarchar10
6/SMERP/STG_MM001Data staging - Material master plant view complex table177BSTATCreation Status - Seasonal Procurementnvarchar20
7/SMERP/STG_MM002Data staging - Material storage location view complex table177BSTATCreation Status - Seasonal Procurementnvarchar20
8/SMERP/STG_MM003Data staging - Material UoM view complex table178BSTATCreation Status - Seasonal Procurementnvarchar20
9/SMERP/STG_MM004Data staging - Material warehouse view complex table177BSTATCreation Status - Seasonal Procurementnvarchar20
10/SMERP/STG_MM005Data staging - Material batch view complex table177BSTATCreation Status - Seasonal Procurementnvarchar20
11BSAD_BAKAccounting: Secondary index for customers (cleared items)81BSTATDocument Statusnvarchar10
12BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)87BSTATDocument Statusnvarchar10
13BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)33BSTATDocument Statusnvarchar10
14BSID_BAKAccounting: Secondary Index for Customers81BSTATDocument Statusnvarchar10
15BSIK_BAKAccounting: Secondary index for vendors87BSTATDocument Statusnvarchar10
16BSIS_BAKAccounting: Secondary Index for G/L Accounts33BSTATDocument Statusnvarchar10
17DVK00unused dummy structure xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx12BSTATCheckboxnvarchar10
18FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)33BSTATDocument Statusnvarchar10
19FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts33BSTATDocument Statusnvarchar10
20FUDT_VDOCBKPFVerification Document Header26BSTATDocument Statusnvarchar10
21FUDT_VDOCBKPFHVerification Document Header(History)26BSTATDocument Statusnvarchar10
22GLPOS_C_CTFI Document: Entry View64BSTATDocument Statusnvarchar10
23GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items64BSTATDocument Statusnvarchar10
24GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items64BSTATDocument Statusnvarchar10
25GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items64BSTATDocument Statusnvarchar10
26GLPOS_N_CTNew General Ledger: Line Item with Currency Type64BSTATDocument Statusnvarchar10
27GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type64BSTATDocument Statusnvarchar10
28T74_BPS17Benefit request type catalog4BSTATBenefit Second Program Groupingnvarchar40
29ZEIMMARAUSING FOR STORING EIM MARA DATAS208BSTATCreation Status - Seasonal Procurementnvarchar20
TOPAccounting Interface
30GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)79BSTATDocument Statusnvarchar10
31GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)79BSTATDocument Statusnvarchar10
TOPAssortment
32WRFT_APC_GENOperational APC: General Customizing12BSTATDefault Material Status Retail Fashion (Operational APC)nvarchar20
TOPBasis Components
33ZDS400_BKPFBelegkopf für Buchhaltung26BSTATBelegstatusnvarchar10
TOPBenefits
34PA0167HR Master Record: Infotype 0167 (Health Plans)28BSTATBenefit Second Program Groupingnvarchar40
35PA0168HR Master Record: Infotype 0168 (Insurance Plans)28BSTATBenefit Second Program Groupingnvarchar40
36PA0169HR Master Record: Infotype 0169 (Savings Plan)28BSTATBenefit Second Program Groupingnvarchar40
37PA0170HR Master Record: Infotype 0170 (Flexible Spending Accounts)28BSTATBenefit Second Program Groupingnvarchar40
38PA0171HR Master Record: Infotype 0171 (Gen. Benefits Information)26BSTATBenefit Second Program Groupingnvarchar40
39PA0211HR Master Record: Infotype 0211 (COBRA Beneficiaries)35BSTATBenefit Second Program Groupingnvarchar40
40PA0212HR Master Record: Infotpye 0212 (COBRA Health Plan)28BSTATBenefit Second Program Groupingnvarchar40
41PA0236HR Master Record: Infotype 0236 (Credit Plans)28BSTATBenefit Second Program Groupingnvarchar40
42T5UB6Benefit Standard Health Selection4BSTATBenefit Second Program Groupingnvarchar40
43T5UB7Benefit standard insurance selection4BSTATBenefit Second Program Groupingnvarchar40
44T5UB9Benefit second program grouping3BSTATBenefit Second Program Groupingnvarchar40
45T5UBUBenefit program4BSTATBenefit Second Program Groupingnvarchar40
46T5UC9Benefit Second Program Grouping Texts4BSTATBenefit Second Program Groupingnvarchar40
47T5UDBCOBRA beneficiary4BSTATBenefit Second Program Groupingnvarchar40
48T74FMBenefit Standard Savings Selection4BSTATBenefit Second Program Groupingnvarchar40
49T74FNBenefit Standard Spending Account Selection4BSTATBenefit Second Program Groupingnvarchar40
50T74FOBenefit standard credit selection4BSTATBenefit Second Program Groupingnvarchar40
51T74FPBenefit Standard Miscellaneous Selection4BSTATBenefit Second Program Groupingnvarchar40
52T74FQBenefit standard stock purchase selection4BSTATBenefit Second Program Groupingnvarchar40
TOPBudget Management
53HRP1500DB Table for Infotype 150020BSTATBudget statusnvarchar10
54T7PMQBudget Status2BSTATBudget statusnvarchar10
55T7PMRName of Budget Status3BSTATBudget statusnvarchar10
56T7PMSBudget Status Changeover2BSTATBudget statusnvarchar10
57T7PMS_PM005Table for Feature PM0053BSTATBudget statusnvarchar10
TOPClaims Processing Asia
58T7XAS2Assignment of Claim formula to Program4BSTATBenefit Second Program Groupingnvarchar40
TOPCross-Application Components
59BBSIDAccounting: Secondary index for customers81BSTATDocument Statusnvarchar10
60BKKPFAccounting document header26BSTATDocument Statusnvarchar10
61MMARAGeneral material data208BSTATCreation Status - Seasonal Procurementnvarchar20
TOPData Retention Tool
62TXW_S_BKPFRetrieve BKPF from archive40BSTATDocument Statusnvarchar10
63TXW_S_BSEGRetrieve BSEG from archive105BSTATDocument Statusnvarchar10
TOPFinancial Accounting
64/BGLOCS/FI001ZVAT Company detail settings4BSTATBULSTAT Identificationnvarchar150
65BKPFAccounting Document Header26BSTATDocument Statusnvarchar10
66BSADAccounting: Secondary Index for Customers (Cleared Items)81BSTATDocument Statusnvarchar10
67BSAKAccounting: Secondary Index for Vendors (Cleared Items)87BSTATDocument Statusnvarchar10
68BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)33BSTATDocument Statusnvarchar10
69BSIDAccounting: Secondary Index for Customers81BSTATDocument Statusnvarchar10
70BSIKAccounting: Secondary Index for Vendors87BSTATDocument Statusnvarchar10
71BSISAccounting: Secondary Index for G/L Accounts33BSTATDocument Statusnvarchar10
72EBKPFFin.Accntng Doc.Header (of Docs from Extern.Systems)35BSTATExternal Document Statusnvarchar10
73VBKPFDocument Header for Document Parking6BSTATDocument Statusnvarchar10
TOPFund Accounting
74FMGLFLEXAGeneral Ledger: Actual Line Items42BSTATDocument Statusnvarchar10
75PSGLFLEXAGeneral Ledger: Actual Line Items46BSTATDocument Statusnvarchar10
TOPFunds Management
76BPDKHeader Entry Document11BSTATDocument/Document Line Item Statusnvarchar10
77BPVKDocument Header for Parked Documents10BSTATDocument/Document Line Item Statusnvarchar10
78FMFG_REPOST_CNTLDocument batching/control for SL Repost for ECC 600 migratio5BSTATDocument Statusnvarchar10
TOPFunds Management-Specific Postings
79PSO50Stop Mass Processing Data for Invoice Reference9BSTATDocument Statusnvarchar10
80PSOKPFRecurring Request Document Header7BSTATDocument Statusnvarchar10
TOPGeneral Ledger Accounting
81BKPF_ADDAccounting Document Header26BSTATDocument Statusnvarchar10
82BSEG_ADDEntry View of Accounting Document for Additional Ledgers6BSTATDocument Statusnvarchar10
83FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)33BSTATDocument Statusnvarchar10
84FAGLBSISAccounting: Secondary Index for G/L Accounts33BSTATDocument Statusnvarchar10
85FAGLFLEXAGeneral Ledger: Actual Line Items44BSTATDocument Statusnvarchar10
86FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items21BSTATDocument Statusnvarchar10
87FAGL_MIG_RPITEMSMigration in New G/L: Objects To Be Posted Subsequently7BSTATDocument Statusnvarchar10
TOPGeneral Ledger Reorganization
88FAGL_R_APARReorganization: Object List for Receivables and Payables21BSTATDocument Statusnvarchar10
TOPJoint Venture und Production Sharing Accounting
89JVGLFLEXAGeneral Ledger: Actual Line Items46BSTATDocument Statusnvarchar10
TOPLocal Currency Changeover
90EWUFI_SCAEMU conversion: Table of the clearings to be adjusted39BSTATDocument Statusnvarchar10
TOPLocalization
91ISJPINVSUMITLine items for invoice summary6BSTATDocument Statusnvarchar10
92J_3RFTAX_EXTRDTax Extract Detail Lines17BSTATDocument Statusnvarchar10
93RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions17BSTATDocument Statusnvarchar10
94RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions17BSTATDocument Statusnvarchar10
95RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions17BSTATDocument Statusnvarchar10
TOPMaterial Master
96MARAGeneral Material Data208BSTATCreation Status - Seasonal Procurementnvarchar20
97MARA_TMPFile for Incorrect Data in Direct Input215BSTATCreation Status - Seasonal Procurementnvarchar20
98MVRACross-version fields for MARA208BSTATCreation Status - Seasonal Procurementnvarchar20
99WRFMATBSTATCreation Status - Seasonal Procurement2BSTATCreation Status - Seasonal Procurementnvarchar20
100WRFMATBSTATTCreation Status - Seasonal Procurement2BSTATCreation Status - Seasonal Procurementnvarchar20
TOPNetherlands
101P05FBN_KMOD_PRGRProgram assignment4BSTATBenefit Second Program Groupingnvarchar40
TOPPatient Management
102NKSKIS-H: Insurance verification/certificate - Header data10BSTATInsurance Verification Processing Statusnvarchar10
TOPPayment Transactions
103CRFILESTATPayment Card File: Status Information for Individual Records13BSTATDocument Statusnvarchar10
TOPPayroll
104PA0938HR Master Record: Infotype 093824BSTATBULSTAT-EIK - Company IDnvarchar150
105PB0938Applicant data infotype 0938 (model)24BSTATBULSTAT-EIK - Company IDnvarchar150
106T7BG01PPersonnel Area/Subarea Groupings for Bulgaria4BSTATBULSTAT-EIK - Company IDnvarchar150
107T7BGA1Bank transfer - interface table6BSTATBULSTAT-EIK - Company IDnvarchar150
TOPPosition Budgeting and Control
108T77HRFPM_POSACTActions Allowed in a Budget Status2BSTATBudget statusnvarchar10
TOPReal Estate Management
109TIVC3Rental Request Processing Status2BSTATRental Request Processing Statusnvarchar40
110TIVCCApplication: Preselection indicator (text table)3BSTATRental Request Processing Statusnvarchar40
111VIMI11Applications - Real Estate Management45BSTATRental Request Processing Statusnvarchar40
TOPRemaining Beverage - Obsolete Objects
112/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103028BSTATDocument Statusnvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
113NKSAIS-H: Insurance verification declaration (Austria)24BSTATnvarchar10
TOPSpecial Purpose Ledger
114/CCIS/PROFTAXAActual Line Items Table for General Ledger54BSTATDocument Statusnvarchar10
TOPSubsequent Settlement
115AVORRATWorklist12BSTATWorklist, Processing Statusnvarchar10
TOPTreasury
116FLQHEADMALiquidity Calculation - Header for Manual Transfer Postings7BSTATLiquidity Calculation: Doc. Status Manual Transfer Postingnvarchar10
TOPUSA
117PA0104HR Master Record: Infotype 0104 (Bond Denominations NA)47BSTATRegion (State, Province, County)nvarchar30
TOPWarehouse Management
118T311ACross-Reference WM Group for Documents6BSTATProcessing status of document in WM reference numbernvarchar10