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

72 columns | Print definition?ERP 6.0  | VSBED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header39VSBEDnvarchar20
2/OPT/X176Delay parameters by shipping condition3VSBEDShipping Instructionsnvarchar20
3/OPT/Y176Delay parameters by shipping condition3VSBEDShipping Instructionsnvarchar20
4/OPT/Z176Delay parameters by shipping condition3VSBEDShipping Instructionsnvarchar20
5/SMD/MD_____00INSID-Tabelle fuer Shipping Conditions3VSBEDShipping Conditionsnvarchar20
6/SMD/MD_____00ZOSID-Tabelle fuer Shipping Conditions3VSBEDShipping Conditionsnvarchar20
7A633Sales Org/Distribution Channel/Division/Shipping Conditions7VSBEDShipping Conditionsnvarchar20
8A710Surcharge/TradeLane/ServiceType/ContainerTypeSize6VSBEDShipping Conditionsnvarchar20
9A711Surcharge/TradeLane/ServiceType/POL/ContainerTypeSize6VSBEDShipping Conditionsnvarchar20
10A712Surcharge/TradeLane/ServiceType/POD/ContainerTypeSize6VSBEDShipping Conditionsnvarchar20
11A720Trade Lane/POR - City/POD - City/ServiceType/Cont.TypeSize7VSBEDShipping Conditionsnvarchar20
12A721TradeLane/POR-Countr/POD-Countr/ServiceType/Cont.TypeSize7VSBEDShipping Conditionsnvarchar20
13A722TradeLane/POR - City/POD-Countr/ServiceType/Cont.TypeSize7VSBEDShipping Conditionsnvarchar20
14A723TradeLane/POR-Countr/POD - City/ServiceType/Cont.TypeSize7VSBEDShipping Conditionsnvarchar20
15A724TradeLane/POL/POD/ServiceType/Cont.TypeSize7VSBEDShipping Conditionsnvarchar20
16A730TradeLane/ServiceType/ContainerTypeSize5VSBEDShipping Conditionsnvarchar20
17A731TradeLane/ServiceType/POL/ContainerTypeSize5VSBEDShipping Conditionsnvarchar20
18A732TradeLane/ServiceType/POD/ContainerTypeSize5VSBEDShipping Conditionsnvarchar20
19A925Camp. ID/Shpg Cond.5VSBEDShipping Conditionsnvarchar20
20A944Sales org./Distr. Chl/Mat.pr.grp/Shp.Cond.7VSBEDShipping Conditionsnvarchar20
21A945Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region6VSBEDShipping Conditionsnvarchar20
22A947Sales Org/Distr.Channel/Shipping Conditions6VSBEDShipping Conditionsnvarchar20
23A960Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region6VSBEDShipping Conditionsnvarchar20
24A963Sales Org/Distr.Channel/Shipping Conditions6VSBEDShipping Conditionsnvarchar20
25A996Sales org./Distr. Chl/Shp.Cond./TG6VSBEDShipping Conditionsnvarchar20
26ZEIM_VBAKSales Document: Header Data35VSBEDShipping Conditionsnvarchar20
TOPBasic Functions
27TROAZRoutes: Determination in Sales Documents4VSBEDShipping Conditionsnvarchar20
28TVAKSales Document Types28VSBEDShipping conditionsnvarchar20
29TVSTZOrganizational Unit: Shipping Points per Plant2VSBEDShipping Conditionsnvarchar20
30TVSTZ_STORLOCStorage-Location-Specific Shipping Point Determination2VSBEDShipping Conditionsnvarchar20
TOPBilling
31VBRKBilling Document: Header Data11VSBEDShipping Conditionsnvarchar20
TOPConditions
32A740SD Doc./Cust.grp.2/POR - City/POD - City/Shpg Cond./Variant8VSBEDShipping Conditionsnvarchar20
33A741SD Doc./Cust.grp.2/POR-Countr/POD-Countr/Shpg Cond./Variant8VSBEDShipping Conditionsnvarchar20
34A742SD Doc./Cust.grp.2/POR - City/POD-Countr/Shpg Cond./Variant8VSBEDShipping Conditionsnvarchar20
35A743SD Doc./Cust.grp.2/POR-Countr/POD - City/Shpg Cond./Variant8VSBEDShipping Conditionsnvarchar20
36A744SD Doc./Cust.grp.2/POL/POD/Shpg Cond./Variant8VSBEDShipping Conditionsnvarchar20
37A936Sales org./Distr. Chl/Shpg Cond./Incoterms/Plant/Ship-to6VSBEDShipping Conditionsnvarchar20
38B501Delivery Type / Shipping cond.5VSBEDShipping Conditionsnvarchar20
TOPCross-Application Components
39/PTGWFI/F_SHPCONDelay parameters by shipping condition3VSBEDShipping Instructionsnvarchar20
40VVBAKSales Document: Header Data35VSBEDShipping Conditionsnvarchar20
TOPCustomer Master
41KNVVCustomer Master Sales Data28VSBEDShipping Conditionsnvarchar20
42TVSBShipping Conditions2VSBEDShipping Conditionsnvarchar20
43TVSBTShipping Conditions: Texts3VSBEDShipping Conditionsnvarchar20
TOPData Collection
44S159W&S: Picking Waves41VSBEDShipping Conditionsnvarchar20
TOPGoods Receipt Process
45BORRTFIRegular tour determinatin (route schedule inbound delivery)5VSBEDShipping Conditionsnvarchar20
TOPInterface to Terminal Automation System
46OIK01IS-OIL/TAS: LID Document Data85VSBEDShipping Conditionsnvarchar20
47OIK01DIS-OIL/TAS: deactivated LID Document Data86VSBEDShipping Conditionsnvarchar20
48OIKCFTAS - Control Field Data21VSBEDShipping Conditionsnvarchar20
49OIKCFWTAS - Control Field Data21VSBEDShipping Conditionsnvarchar20
50OIKLIDTAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)52VSBEDShipping Conditionsnvarchar20
51OIKLIDRTD - TAS Reference Table52VSBEDShipping Conditionsnvarchar20
52OIKLIDWTAS LID Working version (NOTE: keep DB eq to DB OIKLID)52VSBEDShipping Conditionsnvarchar20
53OIKTPIRDTPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL16VSBEDShipping Conditionsnvarchar20
54TOIKTRVLID TAS relevance determination14VSBEDShipping Conditionsnvarchar20
TOPInterfaces
55VXSISVSmall Parcel Carrier: Shipping Condition (Service Code)3VSBEDShipping Conditionsnvarchar20
TOPPurchasing
56EKPVShipping Data For Stock Transfer of Purchasing Document Item16VSBEDShipping Conditionsnvarchar20
TOPRemaining Beverage - Obsolete Objects
57/BEV1/RBVBAKSales Document: Header Data35VSBEDShipping Conditionsnvarchar20
TOPSales
58VBAKSales Document: Header Data35VSBEDShipping Conditionsnvarchar20
TOPShipping
59DVK01R/2-R/3 Link: Delivery Header Data R2 -> R338VSBEDShipping Conditionsnvarchar20
60LIKPSD Document: Delivery Header Data29VSBEDShipping Conditionsnvarchar20
61VAWKDelivery Plan: Itinerary Determination, Customer-Specific5VSBEDShipping Conditionsnvarchar20
62VAWZDelivery Plan: Itinerary Determination, Zone-Specific5VSBEDShipping Conditionsnvarchar20
TOPSimulation
63VSVBAK_CNVersion: Sales document: Header data36VSBEDShipping Conditionsnvarchar20
TOPStructures Workbench
64/ISDFPS/MATSPPLNMaterials Planned for Force Element65VSBEDShipping Conditionsnvarchar20
65HRT1981Table Section Infotype 198114VSBEDShipping Conditionsnvarchar20
TOPTraders and Schedulers Workbench
66TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents18VSBEDShipping Conditionsnvarchar20
TOPTransportation
67TROLZRoutes: Determination in Deliveries4VSBEDShipping Conditionsnvarchar20
68VTRDIShipment Planning Index10VSBEDShipping Conditionsnvarchar20
69VTTKShipment Header20VSBEDShipping Conditionsnvarchar20
TOPTransportation Management Integration
70TMS_C_SHPExt. Transport Manag.: Determination of Transfer Relev. SHP4VSBEDShipping Conditionsnvarchar20
71TMS_C_SLSExt.Transport Manag.: Determination of Transfer Relevance SD6VSBEDShipping Conditionsnvarchar20
TOPVendor Master
72LFM1Vendor master record purchasing organization data48VSBEDShipping Conditionsnvarchar20

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