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

97 columns | Print definition?ERP 6.0  | BRGEW

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item39BRGEWdecimal150
2/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item35BRGEWdecimal150
3/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item30BRGEWdecimal150
4/SMERP/STG_MM001Data staging - Material master plant view complex table30BRGEWGross Weightdecimal133
5/SMERP/STG_MM002Data staging - Material storage location view complex table30BRGEWGross Weightdecimal133
6/SMERP/STG_MM003Data staging - Material UoM view complex table31BRGEWGross Weightdecimal133
7/SMERP/STG_MM004Data staging - Material warehouse view complex table30BRGEWGross Weightdecimal133
8/SMERP/STG_MM005Data staging - Material batch view complex table30BRGEWGross Weightdecimal133
9/SMERP/STG_PM001Data staging - Equipment complex table20BRGEWWeight of objectdecimal133
10/SMERP/STG_PM002Data staging - Functional Location complex table48BRGEWGross Weightdecimal133
11/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab20BRGEWWeight of objectdecimal133
12/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab48BRGEWGross Weightdecimal133
13J_1I_PM_COODETEXIM: COO line items10BRGEWGross weightdecimal153
14J_1I_PM_PACKLISTEXIM: Packing List Items12BRGEWGross weightdecimal153
15J_3RFGTD_ITEMImport Customs Declaration Items10BRGEWGross Weightdecimal133
16SGT_MARMSegmentation | Weights and Volumes7BRGEWGross Weightdecimal133
17WB2_D_BVDETAILCCS: Detailed Statement for Settlement15BRGEWGross Weightdecimal133
18ZEIMMARAUSING FOR STORING EIM MARA DATAS30BRGEWGross Weightdecimal133
19ZEIM_LIPSSD document: Delivery: Item data23BRGEWGross weightdecimal153
20ZEIM_VBAPSales Document: Item Data56BRGEWGross Weight of the Itemdecimal153
TOPAccounting Interface
21GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)264BRGEWGross weightdecimal153
22GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)264BRGEWGross weightdecimal153
TOPAdvertising Management
23JHTAKIS-M/AM: Settlement Run Sales Document Header17BRGEWGross weight of all processed documentsdecimal133
24JHTFPIS-M/AM: Billing/Settlement Documents - Item52BRGEWGross Weightdecimal133
TOPAgency Business Global Trade
25WBRPAgency business: Item21BRGEWGross Weightdecimal153
TOPAllocation
26AUVDIWorklist for Deliveries (Follow-on Doc. Generation)27BRGEWOpen gross weight of all schedule lines for this keydecimal153
TOPBasic functions
27HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting16BRGEWTotal Weight of Handling Unitdecimal153
TOPBasic Functions
28VBFASales Document Flow24BRGEWGross weightdecimal153
29VBSKCollective Processing for a Sales Document Header9BRGEWGross weight of all processed documentsdecimal133
TOPBasic functions
30VEKPHandling Unit - Header Table7BRGEWTotal Weight of Handling Unitdecimal153
TOPBasic Functions
31VETVGDelivery Due Index for Stock Transfer17BRGEWOpen gross weight of all schedule lines for this keydecimal153
TOPBilling
32VBRPBilling Document: Item Data14BRGEWGross weightdecimal153
TOPContract Accounts Receivable and Payable
33FKK_JLRPHD_SHORTItem Data for IS-M/SD Home Delivery Settlement - Extracts20BRGEWIS-M: Gross Weight (Issue Weight Incl. Weight of Inserts)nvarchar160
TOPCross-Application Components
34MMARAGeneral material data30BRGEWGross Weightdecimal133
35VVBAPSales Document: Item Data56BRGEWGross Weight of the Itemdecimal153
36VVBFASales Document Flow24BRGEWGross weightdecimal153
TOPData Collection
37S005SIS: Shipping Point/Route/Forwarding Agent/Receiving Country17BRGEWGross weight of deliveriesdecimal153
38S005BIW1S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country17BRGEWGross weight of deliveriesdecimal153
39S005BIW2S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country17BRGEWGross weight of deliveriesdecimal153
40S015Subsequent Settlement: Evaluation29BRGEWVendor business volume: gross weight (subsequent settlement)decimal153
41S074Subsequent Settlement: Operative27BRGEWVendor business volume: gross weight (subsequent settlement)decimal153
42S260SD - Sales order105BRGEWGross Weight of the Itemdecimal153
43S260BIW1SD - Sales order105BRGEWGross Weight of the Itemdecimal153
44S260BIW2SD - Sales order105BRGEWGross Weight of the Itemdecimal153
45S261SD - Delivery note87BRGEWGross weightdecimal153
46S261BIW1SD - Delivery note87BRGEWGross weightdecimal153
47S261BIW2SD - Delivery note87BRGEWGross weightdecimal153
48S262SD - Billing document83BRGEWGross weightdecimal153
49S262BIW1SD - Billing document83BRGEWGross weightdecimal153
50S262BIW2SD - Billing document83BRGEWGross weightdecimal153
51S264SD- Offer108BRGEWGross Weight of the Itemdecimal153
52S264BIW1S264BIW1 * SD - Quotation108BRGEWGross Weight of the Itemdecimal153
53S264BIW2S264BIW2 * SD - Quotation108BRGEWGross Weight of the Itemdecimal153
TOPEquipment
54EQUIEquipment master data14BRGEWWeight of objectdecimal133
TOPFreight Processing
55TVFBWAMinimum Weights for Shipping Units5BRGEWGross weightdecimal153
TOPFunctional Locations
56IFLOTFunctional Location (Table)42BRGEWGross Weightdecimal133
57IFLOT_VSFunctional Location (Version Table)43BRGEWGross Weightdecimal133
TOPInterfaces
58VXSIGExpress Delivery Company: Weight Codes5BRGEWGross Weightdecimal133
TOPInventory Management
59MWXVM07MFields: Update Control of Module Pool SAPMM07M136BRGEWGross weightdecimal153
60MWZVM07MFields: Update Control of Module Pool SAPMM07M136BRGEWGross weightdecimal153
TOPLocalization
61J_1BNFDOCNota Fiscal Header46BRGEWGross weightdecimal153
62J_1IEXCDTLExcise invoice line item details78BRGEWGross weightdecimal153
63J_3RSCCDITEMCargo Customs Declaration Item12BRGEWGross Weightdecimal133
TOPLogistics - General
64WBHITrading Contract: Item Data42BRGEWGross Weight of the Itemdecimal153
TOPMain Process
65/VSO/M_I_DLY_ITMInput Data: Delivery Items (Vehicle Space Optimization)13BRGEWGross Weight (Vehicle Space Optimization)nvarchar130
TOPMaterial Master
66MARAGeneral Material Data30BRGEWGross Weightdecimal133
67MARA_TMPFile for Incorrect Data in Direct Input37BRGEWGross Weightdecimal133
68MARMUnits of Measure for Material15BRGEWGross Weightdecimal133
69MARM_TMPFile for Incorrect Data in Direct Input18BRGEWGross Weightdecimal133
70MVRACross-version fields for MARA30BRGEWGross Weightdecimal133
71MVRMUnits of Measure for Material15BRGEWGross Weightdecimal133
TOPPeriodical Sales and Distribution
72JLRPIS-M/SD: Item Data for Settlement69BRGEWIS-M: Gross weight (issue weight incl.weight of inserts)decimal133
73JLSKIS-M/SD: Header for Settlement in Collective Processing10BRGEWGross weight of all processed documentsdecimal133
TOPProfitability Analysis
74CEERRORCO-PA: Incorrect records from SD35BRGEWGross weightdecimal153
TOPPurchasing
75EKPOPurchasing Document Item105BRGEWGross Weightdecimal133
TOPR2-R3 Link
76LDK01Communication Record 01 Decentralized WMS: GR/GI R/2 -> ERP30BRGEWGross weight (NUMC format)nvarchar140
77LDK02Communicat.Record 02 Decentralized WMS: Transfer R/2 -> ERP36BRGEWGross weight (NUMC format)nvarchar140
78LDK03Communication Rec. 03 Decentralized WMS: Del.Doc. R/2 -> ERP23BRGEWGross weight (NUMC format)nvarchar140
79LDK05Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master22BRGEWGross weight (NUMC format)nvarchar140
TOPRecycling Administration Core Functions
80J_7LM03REA Article Master: Sales Units11BRGEWGross Weightdecimal133
TOPRemaining Beverage - Obsolete Objects
81/BEV1/CLCONT1Container Information21BRGEWGross weightdecimal153
82/BEV1/RBVBAPSales Document: Item Data56BRGEWGross Weight of the Itemdecimal153
83/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents9BRGEWGross weight of all processed documentsdecimal133
TOPRemote Logistics Management
84OIO_MX_OBJECTRLM tracking extract object data48BRGEWGross weightdecimal153
85OIO_RT_RTDOC_CTReturns document - container items10BRGEWTotal Weight of Handling Unitdecimal153
TOPRepetitive Manufacturing
86COMPMOVEGoods Movement of Components224BRGEWGross weightdecimal153
TOPSales
87VBAPSales Document: Item Data56BRGEWGross Weight of the Itemdecimal153
88VEPVGDelivery Due Index18BRGEWOpen gross weight of all schedule lines for this keydecimal153
TOPShipping
89DVK02R/2-R/3 Link: Delivery Item Data R2 -> R317BRGEWGross weight (special storage for decentralized shipping)nvarchar160
90DVM01R/2-R/3 Link: R/3 Input Data for Material Master51BRGEWGross weight (special storage for decentralized shipping)nvarchar140
91LIPSSD document: Delivery: Item data23BRGEWGross weightdecimal153
TOPSimulation
92VSVBAP_CNVersion: Sales document: Item data57BRGEWGross Weight of the Itemdecimal153
TOPSubsequent Settlement
93S015BIW1S015BIW1 * Supplementary settlement - Evaluation29BRGEWVendor business volume: gross weight (subsequent settlement)decimal153
94S015BIW2S015BIW2 * Supplementary settlement - Evaluation29BRGEWVendor business volume: gross weight (subsequent settlement)decimal153
TOPWarehouse Management
95LTAPTransfer order item30BRGEWGross weight of transfer order itemdecimal113
96LTBKTransfer requirement header26BRGEWTotal Weight of Transfer Requestdecimal113
97LTBPTransfer requirement item30BRGEWWeight of Materialdecimal113