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  | PS_PSP_PNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items155PS_PSP_PNRnvarchar80
2/SMERP/STG_PM001Data staging - Equipment complex table194PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
3/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab188PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
4CNVCMIS_M_VMPAACMIS: Temp. Generated Pooltable for Matchcode Id VMPA-A2PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
5CNVCMIS_M_VMPABCMIS: Temp. Generated Pooltable for Matchcode ID VMPA B4PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
6CNVTDMS_05_VMPACollector table for Work Breakdown Structure Element3PS_PSP_PNRPS_PSP_PNR for VMPAnvarchar80
7GLPCA_CTProfit Center Documents95PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
8GLPCA_T_CTProfit Center Documents111PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
9S550ES550 - Structural Information5PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
10ZEIM_LIPSSD document: Delivery: Item data106PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
11ZEIM_VBAKSales Document: Header Data60PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
12ZEIM_VBAPSales Document: Item Data134PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
13T7PIQSINGLEFEESDefine Attributes for Individual Fees18PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
14TCMAC06DDerivation of ISR Scenario Related Data18PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPAccounting Interface
15GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)174PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
16GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)174PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPActual CostingMaterial Ledger
17MLCOMaterial valuation document account assignment information22PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPAgency Business Global Trade
18WBRPAgency business: Item143PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPAlternative Valuation Run
19CKMLAVRDOCITLines for Cumulation Posting Document45PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPBilling
20VBRPBilling Document: Item Data103PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPConfirmations
21AFFWGoods Movements with Errors from Confirmations62PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPConstruction Equipment Management
22/SAPCEM/PSKOKMWBS Element per Controlling Area for Material Sales3PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
23/SAPCEM/PSPBUKRSCEM Assignment WBS Element to Company Code3PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPConstruction Progress Report
24/SAPPCE/TPNVConstruction Progress Report3PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
25/SAPPCE/TPNV02WBS Elements for which a CPR has been created2PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPContract Accounts Receivable and Payable
26DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)35PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
27DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations17PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
28DFKKMOPKItems in contract account document14PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
29DFKKOPKItems in contract account document14PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
30DFKKORDERPOSRequests: Items51PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
31DFKKORDERPOS_SRequest Templates: Items45PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
32DFKKSUMPosting totals from FI-CA23PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
33DFKKSUMOLDTotals Records Without Account Assignment Changes10PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
34DFKK_VT_ICT: Items of Provider Contract43PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
35FKKDEFREVTrigger Table for Deferred Revenue Postings23PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
36TECODIS-U: CO account assignment key / allocation12PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
37TFKCODFI-CA: CO Account Assignment Key/Allocation10PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPContract Billing
38DBERCHZIndividual Line Items133PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
39DBERCHZ3Individual line items (amount and price data)25PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
40DBERCHZ7Document line items (amount/price data, unimportant rows)25PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPCross-Application Components
41VVBAKSales Document: Header Data60PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
42VVBAPSales Document: Item Data134PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPData Collection
43S008Communications Table SD -> CO/Projects36PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
44S409Contract & Billing14PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
45S409ES409 - Structure Information9PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
46S550Info Structure 0610PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPData Retention Tool
47TXW_S_MSEGRetrieve MSEG from archive47PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPElectronic Bank Statement
48FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)31PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
49FEB_ACTAcct Assignment Templates31PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPExternal Services
50ESKNAccount Assignment in Service Package27PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPFinancial Accounting
51ACCRFIAccruals/Deferrals Master Data FI/CO Account Assignment10PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
52ACCTITCompressed Data from FI/CO Document66PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
53T076KFI-EDI: Additional Account Assignments14PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
54VBSEGADocument Segment for Document Parking - Asset Database33PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
55VBSEGSDocument Segment for Document Parking - G/L Account Database78PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPFreight Processing
56VFKNAccount Determination in Shipment Costs Item25PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPFunds Management
57FIWF_ACGRPAccount Assignment Groups for Role Definition9PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPFunds Management-Specific Postings
58FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years77PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
59PSOSEGADocument Segment for Assets Document Parking34PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
60PSOSEGSRecurring Request Document Segment, G/L Accounts76PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPGeneral Ledger Accounting
61FAGL_SPLINFOSplittling Information of Open Items28PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPGeneral Ledger Reorganization
62FAGL_R_SPLReorganization: Splitting Information of the Open Items32PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPGL Account Posting
63TCJ_POSITIONSCash Journal Document Items38PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPIntercompany Data Exchange
64TINV_INV_LINE_BBill Line with Posting Information29PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
65TINV_INV_LINE_IBill Line Item with Information (Not Relevant to Posting)29PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
66TINV_INV_TRANSFTransfer Table for Bill Data to FI-CA33PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
67TINV_LINEB_SHORTExtract of Bill Receipt (Evaluation System): Bill Lines26PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPInventory Management
68ISEGPhysical Inventory Document Items42PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
69MSEGDocument Segment: Material113PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
70MWXMSEGZMSEG: Interface for Posting of Value113PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
71MWZMSEGZMSEG:Interface for Posting of Value113PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
72RKPFDocument Header: Reservation30PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPInvoice Verification
73RBCODocument Item, Incoming Invoice, Account Assignment24PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPInvoicing
74DBERDZDB Table: Individ. Lines - Print Document159PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPJapan
75T7JPSK_CONTTShukko Contract Template11PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPLocalization
76J_1BNFLINNota Fiscal line items91PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPLogistics - General
77WBHITrading Contract: Item Data135PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
78WBHKTrading Contract: Header Data101PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPMaintenance Orders
79AUFMGoods movements for order36PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPMaster Data
80EVERIS-U Cont.42PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPMaterial
81LFINFDelivery information Project System13PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
82RSPSPIndex: Reservations for WBS elements/Sales order items5PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPMaterials Management
83J_1GVL_MLMaterial Ledger90PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPOverhead Cost Orders
84COBRBDistribution Rules Settlement Rule Order Settlement36PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPPayment Transactions
85CRACCPayment Cards: Account Assignments in Card Master Record28PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
86CRNUMPayment cards: Card master record49PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPPeriodical Sales and Distribution
87JLRPIS-M/SD: Item Data for Settlement52PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPProfit Center Accounting
88GLPCAEC-PCA: Actual Line Items71PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
89GLPCPEC-PCA: Plan Line Items129PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPProject System
90VMPASelection Methods for Search Help VMPA2PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPPurchasing
91EBKNPurchase Requisition Account Assignment29PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
92EKCPAPurchasing Contract Commitment Plan Account Assignment Data21PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
93EKKNAccount Assignment in Purchasing Document32PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPQuality Inspection
94QALSInspection lot record109PS_PSP_PNRValuated Sales Order Stock WBS Elementnvarchar80
TOPQuality Notifications
95TQ8COAssignment of reference orders to notification type9PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPReal Estate Localization Czech Republic
96/CEERE/SDANPProperty tax - master120PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPReal Estate Management
97VIAKBSEGDocument Line Item from SCS for Interface169PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
98VIMI17RE: Adjustment Run Header21PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
99VIMI29Maintenance orders - Modernization measure allocation4PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
100VIMI30Allocation of WBS elements to modernization measure3PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPRemaining Beverage - Obsolete Objects
101/BEV1/RBVBAKSales Document: Header Data60PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
102/BEV1/RBVBAPSales Document: Item Data134PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPRemote Logistics Management
103OIO_RT_RTDOC_MTReturns document - material items15PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPRepetitive Manufacturing
104COMPMOVEGoods Movement of Components115PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPRevenue recognition
105VBREVACRevenue Recognition: Compression of FI Revenue Postings8PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
106VBREVERevenue Recognition: Revenue Recognition Lines25PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
107VBREVKRevenue Recognition: Control Lines26PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPSales
108VBAKSales Document: Header Data60PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
109VBAPSales Document: Item Data134PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPSelf-Service Procurement
110/SRMERP/D_ACC_ITAccount assignment item26PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPSerial Numbers
111EQBSSerial Number Stock Segment12PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPShipping
112LIPSSD document: Delivery: Item data106PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPSimulation
113VSEBKN_CNVersion: Purchase requisition account assignment30PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
114VSVBAK_CNVersion: Sales document: Header data61PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
115VSVBAP_CNVersion: Sales document: Item data135PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
TOPWaste Management
116EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment24PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
117EHSWAT_ENACCDisposal Processing: Account Assignments for Entry Document21PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80
118EHSWAT_MNACCAccount Assignments for Disposal Document20PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80