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

Home | ERP 6.0 
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

157 columns | Print definition?ERP 6.0  | VSTEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item58VSTELnvarchar40
2/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item110VSTELnvarchar40
3/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule93VSTELnvarchar40
4/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.67VSTELnvarchar40
5/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data38VSTELnvarchar40
6/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item30VSTELnvarchar40
7/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item97VSTELnvarchar40
8CNVCMIS_M_VMVLACMIS: Temp. Generated Structure for MC-Id2VSTELShipping Point/Receiving Pointnvarchar40
9CNVCMIS_M_VMVLBCMIS: Generated Pooltable for Matchcode ID VMVL -B2VSTELShipping Point/Receiving Pointnvarchar40
10CNVCMIS_M_VMVLCCMIS: Temp. Generated Structure for MC-Id2VSTELShipping Point/Receiving Pointnvarchar40
11CNVCMIS_M_VMVLDCMIS: Generated Pooltable for Matchcode ID VMVL -D10VSTELShipping Point/Receiving Pointnvarchar40
12CNVCMIS_M_VMVMECMIS: Generated Pooltable for Matchcode ID VMVM -E2VSTELShipping Point/Receiving Pointnvarchar40
13CNVCMIS_M_VMVMFCMIS: Generated Pooltable for Matchcode ID VMVM -F2VSTELShipping Point/Receiving Pointnvarchar40
14DVK00unused dummy structure xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx3VSTELShipping Point/Receiving Pointnvarchar40
15T630LShipping Determination: Loading Times2VSTELShipping Point/Receiving Pointnvarchar40
16T630RDelivery Scheduling: Pick/Pack Time for Materials2VSTELShipping Point/Receiving Pointnvarchar40
17TNAD5Output Control: Printers by Shipping Point4VSTELShipping Point/Receiving Pointnvarchar40
18TVSROShipping points: Countries in Which Routes are Defined2VSTELShipping Point/Receiving Pointnvarchar40
19ZEIM_VBAPSales Document: Item Data71VSTELShipping Point/Receiving Pointnvarchar40
20ZGWPAM_INVENTORYGWPAM Demo Material Inventory4VSTELShipping Point/Receiving Pointnvarchar40
21ZID_KREDICATTBasis Data for CATT zid_apowe6VSTELShipping Point/Receiving Pointnvarchar40
22ZPR01SD-Organization Profile7VSTELShipping Point/Receiving Pointnvarchar40
TOPAccount Determination
23TVSTTOrganizational Unit: Shipping Points: Texts3VSTELShipping Point/Receiving Pointnvarchar40
24TVSWZShipping Points per Plant3VSTELShipping Point/Receiving Pointnvarchar40
TOPAllocation
25AUVDIWorklist for Deliveries (Follow-on Doc. Generation)2VSTELShipping Point/Receiving Pointnvarchar40
26AUVTShipping-Specific Data of Plants for Delivery Generation5VSTELShipping Point/Receiving Pointnvarchar40
TOPBasic Functions
27T323VError handling (Host)- Decentralized SD (Definition of mail)2VSTELShipping Point/Receiving Pointnvarchar40
28TVKOLPicking: Storage Location Determination for Deliveries2VSTELShipping Point/Receiving Pointnvarchar40
29TVLAOrg.unit: Loading points per shipping point2VSTELShipping Point/Receiving Pointnvarchar40
30TVLATOrg.Unit: Loading points per shipping point: Texts3VSTELShipping Point/Receiving Pointnvarchar40
31TVSTZOrganizational Unit: Shipping Points per Plant6VSTELProposed shipping pointnvarchar40
32TVSTZ_STORLOCStorage-Location-Specific Shipping Point Determination6VSTELProposed shipping pointnvarchar40
33VBSKCollective Processing for a Sales Document Header13VSTELShipping Point/Receiving Pointnvarchar40
TOPBasic functions
34VEKPHandling Unit - Header Table5VSTELShipping Point/Receiving Pointnvarchar40
TOPBasic Functions
35VETVGDelivery Due Index for Stock Transfer2VSTELShipping Point/Receiving Pointnvarchar40
TOPBilling
36J_1AOFNR3Exception table for deal type determ.(export/domestic)2VSTELShipping Point/Receiving Pointnvarchar40
37J_1ASNRDT1Branch Determination for Deliveries3VSTELShipping Point/Receiving Pointnvarchar40
38J_1A_WS_BRANCHAR:WS Branch determination(Shipping Point)3VSTELShipping Point/Receiving Pointnvarchar40
39VBRPBilling Document: Item Data39VSTELShipping Point/Receiving Pointnvarchar40
TOPComplaints and Returns
40/SPE/RET_SHP_PNTDefault shipping point determination for returns deliveries3VSTELShipping Point/Receiving Pointnvarchar40
41/SPE/SHP_IDX_QISPL Returns Deliveries: Relevant for Quality Inspection4VSTELShipping Point/Receiving Pointnvarchar40
TOPConditions
42A507External agent/Shipping point5VSTELShipping Point/Receiving Pointnvarchar40
43B010Shipping Point/Route4VSTELShipping Point/Receiving Pointnvarchar40
44B014Grouping Type/Shipping Point5VSTELShipping Point/Receiving Pointnvarchar40
45B021DlvType/Shipping Point5VSTELShipping Point/Receiving Pointnvarchar40
46B900Shipping point4VSTELShipping Point/Receiving Pointnvarchar40
TOPCross-Application Components
47VVBAPSales Document: Item Data71VSTELShipping Point/Receiving Pointnvarchar40
TOPData Collection
48S005SIS: Shipping Point/Route/Forwarding Agent/Receiving Country8VSTELShipping Point/Receiving Pointnvarchar40
49S005BIW1S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country3VSTELShipping Point/Receiving Pointnvarchar40
50S005BIW2S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country3VSTELShipping Point/Receiving Pointnvarchar40
51S005ES005 - Structural Information3VSTELShipping Point/Receiving Pointnvarchar40
52S053Shipment: shipping data10VSTELShipping Point/Receiving Pointnvarchar40
53S053ES053 - Structural Information5VSTELShipping Point/Receiving Pointnvarchar40
54S159W&S: Picking Waves37VSTELShipping Point/Receiving Pointnvarchar40
55S260SD - Sales order42VSTELShipping Point/Receiving Pointnvarchar40
56S260BIW1SD - Sales order42VSTELShipping Point/Receiving Pointnvarchar40
57S260BIW2SD - Sales order42VSTELShipping Point/Receiving Pointnvarchar40
58S261SD - Delivery note14VSTELShipping Point/Receiving Pointnvarchar40
59S261BIW1SD - Delivery note14VSTELShipping Point/Receiving Pointnvarchar40
60S261BIW2SD - Delivery note14VSTELShipping Point/Receiving Pointnvarchar40
61S262SD - Billing document42VSTELShipping Point/Receiving Pointnvarchar40
62S262BIW1SD - Billing document42VSTELShipping Point/Receiving Pointnvarchar40
63S262BIW2SD - Billing document42VSTELShipping Point/Receiving Pointnvarchar40
64S263SD - Sales order/delivery note38VSTELShipping Point/Receiving Pointnvarchar40
65S263BIW1SD - Sales order/delivery note38VSTELShipping Point/Receiving Pointnvarchar40
66S263BIW2SD - Sales order/delivery note38VSTELShipping Point/Receiving Pointnvarchar40
67S264SD- Offer44VSTELShipping Point/Receiving Pointnvarchar40
68S264BIW1S264BIW1 * SD - Quotation44VSTELShipping Point/Receiving Pointnvarchar40
69S264BIW2S264BIW2 * SD - Quotation44VSTELShipping Point/Receiving Pointnvarchar40
TOPData Retention Tool
70TXW_S_LIKPRetrieve LIKP from archive12VSTELShipping Point/Receiving Pointnvarchar40
TOPDelivery Processing
71TVDSSProfiles for Subsequent Outbound Delivery Split12VSTELShipping Point for Outputs and Delivery Split Lognvarchar40
TOPForeign Trade
72/SAPSLL/TSKCR3Customs Processing: Method of Processing for Safekeeping2VSTELShipping Point/Receiving Pointnvarchar40
TOPInterface to Terminal Automation System
73OIK01IS-OIL/TAS: LID Document Data71VSTELShipping Point/Receiving Pointnvarchar40
74OIK01DIS-OIL/TAS: deactivated LID Document Data72VSTELShipping Point/Receiving Pointnvarchar40
75OIKCFTAS - Control Field Data7VSTELShipping Point/Receiving Pointnvarchar40
76OIKCFWTAS - Control Field Data7VSTELShipping Point/Receiving Pointnvarchar40
77OIKLIDTAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)38VSTELShipping Point/Receiving Pointnvarchar40
78OIKLIDRTD - TAS Reference Table38VSTELShipping Point/Receiving Pointnvarchar40
79OIKLIDWTAS LID Working version (NOTE: keep DB eq to DB OIKLID)38VSTELShipping Point/Receiving Pointnvarchar40
80OIKTPIRDTPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL9VSTELShipping Point/Receiving Pointnvarchar40
81TOIKTRVLID TAS relevance determination7VSTELShipping Point/Receiving Pointnvarchar40
TOPInterfaces
82CIF_MAP_SP_SLUnique Mapping of Shipping Point to Storage Location2VSTELShipping Point/Receiving Pointnvarchar40
83VXSIPSPacking Station3VSTELShipping Point/Receiving Pointnvarchar40
84VXSITDLVSmall Parcel Carrier: Data Fields per Shipping Point4VSTELShipping Point/Receiving Pointnvarchar40
85VXSIVExpress Delivery Company: Shipping Point: Control3VSTELShipping Point/Receiving Pointnvarchar40
TOPInventory Management
86MWXVM07MFields: Update Control of Module Pool SAPMM07M178VSTELShipping Point/Receiving Pointnvarchar40
87MWZVM07MFields: Update Control of Module Pool SAPMM07M178VSTELShipping Point/Receiving Pointnvarchar40
TOPLoading Units
88/BEV1/LUTLLU: Permitted Document Types Delivery3VSTELShipping Point/Receiving Pointnvarchar40
TOPLocalization
89J_1BNFDOCNota Fiscal Header52VSTELShipping Point/Receiving Pointnvarchar40
90J_1BNFE_ACTIVEElectronic Nota Fiscal: Actual Status24VSTELShipping Point/Receiving Pointnvarchar40
91J_1IEXSRDETExcise / Series group determination5VSTELShipping Point/Receiving Pointnvarchar40
TOPLogistics Basic Data
92DMF_D_T001WTransferred Sites54VSTELShipping Point/Receiving Pointnvarchar40
TOPLogistics Execution LE Enhancements
93/SAPMP/LBA_CUSTIS-MP: Control Table DTUC Processing2VSTELShipping Point/Receiving Pointnvarchar40
TOPMaterial
94LFINFDelivery information Project System4VSTELShipping Point/Receiving Pointnvarchar40
TOPMaterial Maintenance
95TVSTOrganizational Unit: Shipping Points2VSTELShipping Point/Receiving Pointnvarchar40
TOPMaterial Master
96T001LStorage Locations15VSTELShipping Point/Receiving Pointnvarchar40
TOPMaterial Sorting
97/BEV1/EMFAS2Material Sorting: Shipping Documents3VSTELShipping Point/Receiving Pointnvarchar40
98/BEV1/EMFAS3Material Sorting: Groups3VSTELShipping Point/Receiving Pointnvarchar40
TOPMaterials Management
99/ISDFPS/1DPERHEHS: Single Permit Header13VSTELShipping Point/Receiving Pointnvarchar40
TOPMedia Product Sales and Distribution
100JKSECONTRINDEXIndex Table for IS-M Contracts22VSTELShipping Point/Receiving Pointnvarchar40
TOPOutput Determination
101B024Shipping point4VSTELShipping Point/Receiving Pointnvarchar40
TOPPeriodical Sales and Distribution
102JKSDREQ_ORDSHIPPIS-M/SD: Requirements Table for Shipping Point Change9VSTELShipping Point/Receiving Pointnvarchar40
103JLSKIS-M/SD: Header for Settlement in Collective Processing14VSTELShipping Point/Receiving Pointnvarchar40
TOPPlant Master
104T001WPlants/Branches54VSTELShipping Point/Receiving Pointnvarchar40
TOPPOS Interface
105WVFBDRS Interface, Intermediate Buffer, Order Item FM51VSTELShipping pointnvarchar40
TOPProduct Safety
106TCGR5EHS: Condition Schema for RGV Selection - Table 57VSTELShipping Point/Receiving Pointnvarchar40
TOPPurchasing
107EKPVShipping Data For Stock Transfer of Purchasing Document Item4VSTELShipping Point/Receiving Pointnvarchar40
TOPR2-R3 Link
108LDK00Status Record for WM Communication Records18VSTELShipping Point/Receiving Pointnvarchar40
TOPRemaining Beverage - Obsolete Objects
109/BEV1/LAAUSFALLShipping: Downtimes Loading Places2VSTELShipping Point/Receiving Pointnvarchar40
110/BEV1/LALPLTZTCustomizing Shipping: Loading Places per Ship./Load. Point3VSTELShipping Point/Receiving Pointnvarchar40
111/BEV1/LATERMINEShipping: Standard Dates Loading Places2VSTELShipping Point/Receiving Pointnvarchar40
112/BEV1/LATLPLTZOrganizational Unit: Loading Places per Loading Point2VSTELShipping Point/Receiving Pointnvarchar40
113/BEV1/LAZEITFShipping: Loading Agenda2VSTELShipping Point/Receiving Pointnvarchar40
114/BEV1/LAZFSICHTShipping: Loading Agenda: Retain View4VSTELShipping Point/Receiving Pointnvarchar40
115/BEV1/RBVBAPSales Document: Item Data71VSTELShipping Point/Receiving Pointnvarchar40
116/BEV1/REMIETERental Items: Shadow Table for VBAK/VBAP/VBEP18VSTELShipping Point/Receiving Pointnvarchar40
117/BEV1/RPFADriver Master (Route Planning)4VSTELShipping Point/Receiving Pointnvarchar40
118/BEV1/RPFZVehicle Master (Route Planning)5VSTELShipping Point/Receiving Pointnvarchar40
119/BEV1/RPTORoute Master (Route Planning)5VSTELShipping Point/Receiving Pointnvarchar40
120/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents13VSTELShipping Point/Receiving Pointnvarchar40
121/DSD/LD_DFTVALDSD - LD: Load Delivery Standard Value5VSTELShipping Point/Receiving Pointnvarchar40
122/DSD/ME_CPT_USERData from Handheld User6VSTELShipping Point/Receiving Pointnvarchar40
123/DSD/ME_CPT_VEHIMaintenance Table for Vehicles in DSD Cockpit5VSTELShipping Point/Receiving Pointnvarchar40
TOPRemote Logistics Management
124OIO_RT_RTDOCRLM returns document - header7VSTELShipping Point/Receiving Pointnvarchar40
TOPSales
125VBAPSales Document: Item Data71VSTELShipping Point/Receiving Pointnvarchar40
126VEPVGDelivery Due Index2VSTELShipping Point/Receiving Pointnvarchar40
127VKDFSSD Index: Billing Initiator15VSTELShipping Point/Receiving Pointnvarchar40
TOPSCM Basis
128CIF_IMSPNTIM Reference Table for Shipping Points2VSTELShipping Point/Receiving Pointnvarchar40
TOPShipping
129DVK01R/2-R/3 Link: Delivery Header Data R2 -> R325VSTELShipping Point/Receiving Pointnvarchar40
130KNVSCustomer Master Shipping Data3VSTELShipping Point/Receiving Pointnvarchar40
131LIKPSD Document: Delivery Header Data7VSTELShipping Point/Receiving Pointnvarchar40
132SHP_IDX_CREDOutbound Deliveries in Credit Check: Blocked and Released11VSTELShipping Point/Receiving Pointnvarchar40
133SHP_IDX_GDRCInbound Deliveries: Not Posted for Goods Receipt4VSTELShipping Point/Receiving Pointnvarchar40
134SHP_IDX_GDSIOutbound Deliveries: Not Posted for Goods Issue3VSTELShipping Point/Receiving Pointnvarchar40
135SHP_IDX_PICKOutbound Deliveries: Not Picked3VSTELShipping Point/Receiving Pointnvarchar40
136SHP_IDX_PUTAInbound Deliveries: Not Putaway4VSTELShipping Point/Receiving Pointnvarchar40
137SHP_IDX_UNCHOutbound Deliveries: Unchecked3VSTELShipping Point/Receiving Pointnvarchar40
138VARKDelivery Plan: Customer-Specific Itinerary2VSTELShipping Point/Receiving Pointnvarchar40
139VARZDelivery Plan: Zone-Specific Itinerary2VSTELShipping Point/Receiving Pointnvarchar40
140VAWADelivery Plan: Exclusion of Itinerary2VSTELShipping Point/Receiving Pointnvarchar40
141VAWKDelivery Plan: Itinerary Determination, Customer-Specific2VSTELShipping Point/Receiving Pointnvarchar40
142VAWZDelivery Plan: Itinerary Determination, Zone-Specific2VSTELShipping Point/Receiving Pointnvarchar40
143VBLKSD Document: Delivery Note Header4VSTELShipping Point/Receiving Pointnvarchar40
144VLKPASD Index: Deliveries by Partner Functions4VSTELShipping Point/Receiving Pointnvarchar40
145VLPMASD Index: Delivery Items by Material3VSTELShipping Point/Receiving Pointnvarchar40
TOPSimulation
146VSVBAP_CNVersion: Sales document: Item data72VSTELShipping Point/Receiving Pointnvarchar40
TOPTraders and Schedulers Workbench
147OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE32VSTELShipping Point/Receiving Pointnvarchar40
148OIJ_EL_TICKET_IUniversal ticket item table73VSTELShipping Point/Receiving Pointnvarchar40
149OIJ_STAGESTSW (&TD) Shipment Stages19VSTELShipping point at point of departurenvarchar40
150TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents11VSTELShipping Point/Receiving Pointnvarchar40
TOPTransportation
151TTPLSTDetermination of Transportation Planning Point f. BAPI Call2VSTELShipping Point/Receiving Pointnvarchar40
152TVKNRoutes: Transportation Connection Points23VSTELShipping Point/Receiving Pointnvarchar40
153VTRDIShipment Planning Index3VSTELShipping Point/Receiving Pointnvarchar40
154VTTSStage of Shipment19VSTELShipping point at point of departurenvarchar40
TOPTransportation and Distribution
155OIGSSTD Shipment Stages19VSTELShipping point at point of departurenvarchar40
TOPTransportation Management Integration
156TMS_C_SHPExt. Transport Manag.: Determination of Transfer Relev. SHP2VSTELShipping Point/Receiving Pointnvarchar40
TOPWarehouse Management
157T340DWM Default Values50VSTELShipping Point/Receiving Pointnvarchar40

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy