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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

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