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

211 columns | Print definition?ERP 6.0  | ERZET

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item47ERZETnvarchar60
2/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule57ERZETnvarchar60
3/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.37ERZETnvarchar60
4/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item42ERZETnvarchar60
5/CCEE/FISC_BS_RGFiscalization Croatia: Business Space Registration8ERZETEntry timenvarchar60
6/CCEE/FISC_CROAFiscalization Croatia: Fiscalized documents14ERZETEntry timenvarchar60
7/SAPF15/DATAF15 Belege (Daten)7ERZETErfassungszeitnvarchar60
8/SAPF15/DATADECOF15 Belege (XPRA_DECOMPRESS)7ERZETErfassungszeitnvarchar60
9/SAPF15/ELKOGESF15 ELKO Daten GES Dateien15ERZETErfassungszeitnvarchar60
10/SAPF15/ELKOHKR1F15 ELKO Daten aus HKR 136ERZETErfassungszeitnvarchar60
11/SAPF15/ELKOHKR2F15 ELKO Daten aus HKR 2 Satzart 2 + HKR 645ERZETErfassungszeitnvarchar60
12/SAPF15/ELKOHKR4F15 ELKO Daten aus HKR 427ERZETErfassungszeitnvarchar60
13/SAPF15/ELKOHKR5F15 ELKO Daten aus HKR 531ERZETErfassungszeitnvarchar60
14/SAPF15/ELKOHKRZF15 ELKO Daten aus HKR 2 Satzart 320ERZETErfassungszeitnvarchar60
15/SAPF15/ELKOZM_VF15 Daten aus ZÜV 101, alte Versionen27ERZETErfassungszeitnvarchar60
16/SAPF15/ELKOZUV1F15 ELKO Daten aus ZÜV 10026ERZETErfassungszeitnvarchar60
17/SAPF15/ELKOZUV2F15 ELKO Daten aus ZÜV 20023ERZETErfassungszeitnvarchar60
18/SAPF15/ELKOZUV5F15 ELKO Daten aus ZÜV 50022ERZETErfassungszeitnvarchar60
19/SAPF15/ELKOZUV6F15 ELKO Daten aus ZÜV 60020ERZETErfassungszeitnvarchar60
20/SAPF15/ELKOZUV9F15 ELKO Daten aus ZÜV 90016ERZETErfassungszeitnvarchar60
21/SAPF15/ELKOZUVMF15 Daten aus ZÜV 10126ERZETErfassungszeitnvarchar60
22/SAPF15/F15F15 Belege (Kopfdaten)12ERZETErfassungszeitnvarchar60
23/SAPF15/F15B01F15 B01 Belege20ERZETErfassungszeitnvarchar60
24/SAPF15/F15B02F15 B02 Belege40ERZETErfassungszeitnvarchar60
25/SAPF15/F15E02F15 E02 Belege15ERZETErfassungszeitnvarchar60
26/SAPF15/F15HF15 Belege (Kopfdaten Historie)13ERZETErfassungszeitnvarchar60
27/SAPF15/RMF15 Rückmeldung Klärungsbestand15ERZETErfassungszeitnvarchar60
28/SAPF15/SMF15 SEPA Mandat8ERZETErfassungszeitnvarchar60
29CMCBC_APPR_CODEApproval Process Code6ERZETEntry timenvarchar60
30IDGT_GTDHGT Document Header28ERZETEntry timenvarchar60
31IDGT_GTDIGT Document Item14ERZETEntry timenvarchar60
32IDGT_GTDMMapping of SAP Document and GT Document14ERZETEntry timenvarchar60
33IDGT_VATHVAT Invoice Header22ERZETEntry timenvarchar60
34IDGT_VATIVAT Invoice Item17ERZETEntry timenvarchar60
35IDGT_VATMMapping of GT Document and VAT Invoice8ERZETEntry timenvarchar60
36NNL_DHD_DLVRYLBZ Anlieferung10ERZETIS-H: Uhrzeit, zu der der Satz hinzugefügt wurdenvarchar60
37REMOB_T_ACTIVITYActivity History master data11ERZETEntry timenvarchar60
38REMOB_T_LOGVisit History11ERZETEntry timenvarchar60
39T7TRK09IFRS : Posting Record9ERZETEntry Timenvarchar60
40WBRDAgency Business: Bank Data Suspense Account4ERZETEntry timenvarchar60
41WSPT_LIKPDocuments For Portugal Webservice17ERZETEntry timenvarchar60
42WSPT_LIKP_REJRejected documents for Portugal Webservice10ERZETEntry timenvarchar60
43ZEIM_LIPSSD document: Delivery: Item data6ERZETEntry timenvarchar60
44ZEIM_VBAKSales Document: Header Data4ERZETEntry timenvarchar60
45ZEIM_VBAPSales Document: Item Data80ERZETEntry timenvarchar60
46ZSMSMcontrol table for SMS in SD8ERZETErfassungszeitnvarchar60
47ZSMSVcontrol table for SMS in SD9ERZETErfassungszeitnvarchar60
48ZSMSV2control table for SMS in SD9ERZETErfassungszeitnvarchar60
TOPAgency Business Global Trade
49WBRCAgency Business: Complaints8ERZETEntry timenvarchar60
50WBRFDocument flow vendor billing document/settlement request9ERZETEntry timenvarchar60
51WBRFNDocument Flow of Reference Document to Agency Document9ERZETEntry timenvarchar60
52WBRKAgency business: Header22ERZETEntry timenvarchar60
53WBRPAgency business: Item39ERZETEntry timenvarchar60
54WLFD_IVRHDRAgency Bus.: DB table for Invoice Request Header13ERZETEntry timenvarchar60
TOPAssortment Maintenance
55WRSZAssignment of assortment user to assortment15ERZETEntry timenvarchar60
TOPBasic Functions
56EIEIForeign Trade: Export/Import Communication Data18ERZETEntry timenvarchar60
57EMBKLegal Control: License Master - Header Data32ERZETEntry timenvarchar60
58VBFASales Document Flow15ERZETEntry timenvarchar60
TOPBasis Components
59ZDS400_VBAKTabelle für Beispielprogramm des ZDS4004ERZETErfassungszeitnvarchar60
60ZSALES_ORD_HEADSales Order Header (IDES DEMO)4ERZETEntry timenvarchar60
61ZSALES_ORD_ITEMSales Order Item(IDES Demo)15ERZETEntry timenvarchar60
TOPBilling
62VBRKBilling Document: Header Data49ERZETEntry timenvarchar60
63VBRPBilling Document: Item Data73ERZETEntry timenvarchar60
TOPConditions
64KONAAgreements13ERZETEntry timenvarchar60
TOPConfirmations
65AFFWGoods Movements with Errors from Confirmations63ERZETEntry timenvarchar60
66AFFWPROLog of deleted AFFW entries17ERZETEntry timenvarchar60
67AFRUOrder Confirmations112ERZETConfirmation entry timenvarchar60
TOPConstruction Equipment Management
68/SAPCEM/BDKOHeader Data for Requisition Note17ERZETEntry timenvarchar60
69/SAPCEM/BDPORequisition Note Item21ERZETEntry timenvarchar60
70/SAPCEM/INVENTURInitial Entry of Stock Balances17ERZETEntry timenvarchar60
71J_3GARCHIVCEM Archiving Lists6ERZETEntry timenvarchar60
72J_3GBELKDocument File - Header Data4ERZETEntry timenvarchar60
73J_3GBELPDocument Data - Item Data6ERZETEntry timenvarchar60
74J_3GZVBAPBackup Table for CEM Data in Rel. 3.066ERZETEntry timenvarchar60
TOPConstruction Progress Report
75/SAPPCE/TPNVConstruction Progress Report13ERZETEntry timenvarchar60
TOPCross-Application Components
76VVBAKSales Document: Header Data4ERZETEntry timenvarchar60
77VVBAPSales Document: Item Data80ERZETEntry timenvarchar60
78VVBFASales Document Flow15ERZETEntry timenvarchar60
TOPData Collection
79S260SD - Sales order88ERZETEntry timenvarchar60
80S260BIW1SD - Sales order88ERZETEntry timenvarchar60
81S260BIW2SD - Sales order88ERZETEntry timenvarchar60
82S261SD - Delivery note83ERZETEntry timenvarchar60
83S261BIW1SD - Delivery note83ERZETEntry timenvarchar60
84S261BIW2SD - Delivery note83ERZETEntry timenvarchar60
85S262SD - Billing document76ERZETEntry timenvarchar60
86S262BIW1SD - Billing document76ERZETEntry timenvarchar60
87S262BIW2SD - Billing document76ERZETEntry timenvarchar60
88S264SD- Offer91ERZETEntry timenvarchar60
89S264BIW1S264BIW1 * SD - Quotation91ERZETEntry timenvarchar60
90S264BIW2S264BIW2 * SD - Quotation91ERZETEntry timenvarchar60
91S270Do not use!8ERZETEntry timenvarchar60
92S270BIW1Do not use!8ERZETEntry timenvarchar60
93S270BIW2Do not use!8ERZETEntry timenvarchar60
94S270ES270 - Structural Information8ERZETEntry timenvarchar60
95S272Do not use!8ERZETEntry timenvarchar60
96S272BIW1Do not use!8ERZETEntry timenvarchar60
97S272BIW2Do not use!8ERZETEntry timenvarchar60
98S272ES272 - Structural Information8ERZETEntry timenvarchar60
99S275Transfer BW: Einkaufsdaten13ERZETInvoertijdnvarchar60
100S275BIW1S275BIW1 * Transfer to BW: Purchasing Data13ERZETEntry timenvarchar60
101S275BIW2S275BIW2 * Transfer to BW: Purchasing Data13ERZETEntry timenvarchar60
102S276Transfer BW: Vertriebsdaten13ERZETInvoertijdnvarchar60
103S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data13ERZETEntry timenvarchar60
104S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data13ERZETEntry timenvarchar60
TOPEmpties Management
105/BEV1/EMDRKKZItem Categories That Are Not Printed8ERZETEntry timenvarchar60
106/BEV1/EMLGFSPREmpties Update Log5ERZETEntry timenvarchar60
TOPForeign Trade
107/SAPSLL/OBJIDXSLL: R/3 BS: Index of Documents Not Transferred8ERZETEntry timenvarchar60
108/SAPSLL/OBJSYNCGTS: R/3 Feeder System: Index of Generated Documents6ERZETEntry timenvarchar60
TOPFreight Processing
109VFKKShipment Costs: Header Data15ERZETEntry timenvarchar60
110VFKPShipment Costs: Item Data46ERZETEntry timenvarchar60
111VFSCAHScale Header20ERZETEntry timenvarchar60
TOPFunds Management-Specific Postings
112FMD1_F15F15 Interface - Documents12ERZETEntry timenvarchar60
TOPGoods Receipt Process
113BORGR_VTTP_NOEXNew inbound deliveries with references8ERZETEntry timenvarchar60
TOPHandheld Connectivity
114/DSD/PR_HEADMDSD Promotion - Promotion Header9ERZETEntry timenvarchar60
TOPInterface to Terminal Automation System
115OIK29IS-OIL/TPI: Status of processed inbound IDoc OILSHI0121ERZETEntry timenvarchar60
116OIK29AIS-OIL/TPI: Status of processed functions6ERZETEntry timenvarchar60
117OIK29DIS-OIL/TPI: Status of processed inbound IDoc OILSHI0122ERZETEntry timenvarchar60
118OIKDCPDelivery confirmation8ERZETEntry timenvarchar60
TOPLogistics - General
119WBHDTrading Contract: Commercial Data22ERZETEntry timenvarchar60
120WBHETrading Contract: Schedule Lines8ERZETEntry timenvarchar60
121WBHITrading Contract: Item Data30ERZETEntry timenvarchar60
TOPMaterial Identification and Reconciliation
122BEREITMaterial identification: staging data20ERZETEntry timenvarchar60
TOPMaterial Sorting
123/BEV1/EMASVMaterial Sorting Variant11ERZETEntry timenvarchar60
124/BEV1/EMFASForm for Material Sorting Variant6ERZETEntry timenvarchar60
TOPMaterials Management
125J_1GVL_MLMaterial Ledger109ERZETEntry timenvarchar60
126J_1GVL_WHBLOG1valuation log table3ERZETEntry timenvarchar60
127J_1GVL_WHBLOG2Circular Valuation Log15ERZETEntry timenvarchar60
TOPNon-Ferrous Metal enhancements
128/NFM/TBWEReporting Base for NF Key, Company Code, Base Key8ERZETEntry timenvarchar60
129/NFM/TCOVHISCoverage History16ERZETEntry timenvarchar60
130/NFM/TNEBBase Keys and Currencies for NF Keys8ERZETEntry timenvarchar60
131/NFM/TNEB_ORGDifferent Base Key on Organizational Level10ERZETEntry timenvarchar60
132/NFM/TNESNF Metal Key8ERZETEntry timenvarchar60
133/NFM/TNES_ORGDifferent NF Key Data on Organizational Level10ERZETEntry timenvarchar60
TOPPatient Accounting
134NVBRKIS-H: Billing document header data38ERZETEntry timenvarchar60
135NVBRPIS-H: Billing document item data39ERZETEntry timenvarchar60
TOPPendulum List Indirect Sales
136/BEV4/PLDANFABHSales Request History17ERZETEntry timenvarchar60
137/BEV4/PLDANFABSSales Request - Header16ERZETEntry timenvarchar60
138/BEV4/PLDANFARTSales Request - Items15ERZETEntry timenvarchar60
139/BEV4/PLDANFKONConverted Request Table with Reporting Period34ERZETEntry timenvarchar60
140/BEV4/PLDANFMELRequest Table with Reporting Period33ERZETEntry timenvarchar60
141/BEV4/PLDANFZEITRequirement Update14ERZETEntry timenvarchar60
142/BEV4/PLDUMARTConversion Table Material Master14ERZETEntry timenvarchar60
143/BEV4/PLDUMKDNConversion Table Customer/Object Numbers26ERZETEntry timenvarchar60
144/BEV4/PLPROTLogs Sales Pendulum List (Master Data)7ERZETEntry timenvarchar60
TOPPeriodical Sales and Distribution
145JFRKIS-M/SD: Billing - Header Data39ERZETEntry timenvarchar60
146JFRPIS-M/SD: Billing Document - Item Data35ERZETEntry timenvarchar60
147JLRKIS-M/SD: Settlement Header Data26ERZETEntry timenvarchar60
148JLRPIS-M/SD: Item Data for Settlement37ERZETEntry timenvarchar60
149TJF31IS-M/SD: Collective Transfer Run to RF/FI8ERZETEntry timenvarchar60
150TJL53IS-M/SD: Log for Settlement Transfer8ERZETEntry timenvarchar60
TOPPosition Management
151WBITAssociation Item at Step Level37ERZETEntry timenvarchar60
TOPProduction and Revenue Accounting
152OIUCM_CONTRACTPRA Contracts4ERZETEntry timenvarchar60
TOPProduction Orders
153COCF_SRShift Reports in PDF Format22ERZETEntry timenvarchar60
154ORDLYTable of delays for production order9ERZETEntry timenvarchar60
TOPProfitability Analysis
155CEERRORCO-PA: Incorrect records from SD30ERZETEntry timenvarchar60
TOPRecycling Administration Core Functions
156J_7LL01REA: Lock Management for Accruals Corrections11ERZETEntry timenvarchar60
157J_7LVBRKNON-SD Interface: Billing: Header Data14ERZETEntry timenvarchar60
158J_7LVBRPOSNON-SD Interface: Billing: Item Data18ERZETEntry timenvarchar60
TOPRemaining Beverage - Obsolete Objects
159/BEV1/BO_DATAProof Table for Rebate Processing37ERZETEntry timenvarchar60
160/BEV1/RBVBAKSales Document: Header Data4ERZETEntry timenvarchar60
161/BEV1/RBVBAPSales Document: Item Data80ERZETEntry timenvarchar60
162/BEV1/RBWEItemized Proof Rebate Settlement59ERZETEntry timenvarchar60
163/BEV1/REWARTRental Items: Delivery Schedule Items23ERZETEntry timenvarchar60
164/BEV1/RSAUAOrder Types for Route Settlement10ERZETEntry timenvarchar60
165/BEV1/RSDIFDifferences of Route Settlement12ERZETEntry timenvarchar60
166/BEV1/RSFSAAssignment of Drivers' Numbers6ERZETEntry timenvarchar60
167/BEV1/RSIMACollection Material11ERZETEntry timenvarchar60
168/BEV1/RSPTYItem Categories for Route Settlement6ERZETEntry timenvarchar60
169/BEV1/RSVBFTCOCIS Document Flow for Shipment9ERZETEntry timenvarchar60
170/BEV1/RSZAPayment Types for Collection5ERZETEntry timenvarchar60
171/BEV1/TSSDBSPRColumn Reference for Main Table Statistics Telephone Sales9ERZETEntry timenvarchar60
172/BEV1/TSSDBTPRCategory Reference for Main Table Statistics Telephone Sales9ERZETEntry timenvarchar60
TOPRetail Pricing
173WKBKPricing document: header9ERZETTime, at Which Record Was Addednvarchar60
174WWKKMarket-Basket Pricing Document: Header5ERZETTime, at Which Record Was Addednvarchar60
TOPRevenue recognition
175VBREVERevenue Recognition: Revenue Recognition Lines32ERZETEntry timenvarchar60
176VBREVKRevenue Recognition: Control Lines22ERZETEntry timenvarchar60
177VBREVRRevenue Recognition: Reference Document Lines15ERZETEntry timenvarchar60
TOPSales
178VBAKSales Document: Header Data4ERZETEntry timenvarchar60
179VBAPSales Document: Item Data80ERZETEntry timenvarchar60
TOPSales Activities
180SADLSTADMAdministrative Data - Address List6ERZETEntry timenvarchar60
181VBKASales Activities4ERZETEntry timenvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
182NLDIS_010ISH NL: DIS - Anlieferungsdatei (kopf)14ERZETInvoertijdnvarchar60
183NLGGZ_DIS_RTIISH NL: DISGGZ - Anlieferungsdatei (kopf)17ERZETErfassungszeitnvarchar60
184NNL_DIS_DLVRYDIS Anlieferung10ERZETIS-H: Uhrzeit, zu der der Satz hinzugefügt wurdenvarchar60
TOPSelf-Billing Proced.
185VSBDITSelf-Billing Procedure Delivery Item w. Automatic Posting7ERZETEntry timenvarchar60
186VSBGRHIDoc Header Regrouping Information7ERZETEntry timenvarchar60
187VSBGRIIDoc Item Regrouping Information8ERZETEntry timenvarchar60
188VSBHDRIDoc Self-Billing Procedure w. Automatic Postings7ERZETEntry timenvarchar60
189VSBITMIDoc-Item Self-Billing Procedure w. Automatic Postings8ERZETEntry timenvarchar60
190VSBPLGProcessing Log: Self-Billing Procedure w. Autom. Postings10ERZETEntry timenvarchar60
TOPService Station Retailing
191OIRCPRCHHEADSSR Pricing - Change header details4ERZETEntry timenvarchar60
TOPShipping
192DVK01R/2-R/3 Link: Delivery Header Data R2 -> R333ERZETEntry timenvarchar60
193LECOMPKomponenten für Lohnbearbeitungsanlieferungen22ERZETEntry timenvarchar60
194LIKPSD Document: Delivery Header Data4ERZETEntry timenvarchar60
195LIPSSD document: Delivery: Item data6ERZETEntry timenvarchar60
TOPSimulation
196VSVBAK_CNVersion: Sales document: Header data5ERZETEntry timenvarchar60
197VSVBAP_CNVersion: Sales document: Item data81ERZETEntry timenvarchar60
TOPSoftware Management
198TOGM4Maintenance Profile5ERZETEntry timenvarchar60
TOPStock Visibility
199/DSD/SV_ERROR_HDDSD SV Error Table Movement Header10ERZETEntry timenvarchar60
200/DSD/SV_MM_HDDSD SV Material Movement Header10ERZETEntry timenvarchar60
201/DSD/SV_RLDSD SV Final Unloading Documents7ERZETEntry timenvarchar60
TOPSubsequent Settlement
202AVORRATWorklist7ERZETEntry timenvarchar60
203EBABSettlement Runs Subsequent Settlement, Header Data4ERZETEntry timenvarchar60
TOPTransportation
204VTFAShipment Document Flow12ERZETEntry timenvarchar60
205VTTKShipment Header8ERZETEntry timenvarchar60
206VTTPShipment Item8ERZETEntry timenvarchar60
207VTTSStage of Shipment9ERZETEntry timenvarchar60
TOPUpstream Graphics
208OIUGT_LAYOUTUpstream Graphics Graphics Variants7ERZETEntry timenvarchar60
209OIUGT_LOGUpstream Graphics Graphics Log4ERZETEntry timenvarchar60
TOPVisit Control
210/DSD/VC_VLHDSD: Visit List - Header Data21ERZETEntry timenvarchar60
211/DSD/VC_VPHDSD: Visit Schedule - Header Data28ERZETEntry timenvarchar60