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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

70 columns | Print definition?ERP 6.0  | TDLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1A501ServcAgent/Incoterms4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
2A514ServcAgent/Ship.type4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
3A519ServcAgent/Suppl. 34TDLNRNumber of forwarding agent in the shipment stagenvarchar100
4A615Condition Table for Pricing A6154TDLNRNumber of forwarding agent in the shipment stagenvarchar100
5S950ES950 - Info structurelles4TDLNRN° du transporteurnvarchar100
6S951ES951 - Info structurelles4TDLNRN° du transporteurnvarchar100
7TROLZIRoutes: Determination in Inbound Deliveries3TDLNRNumber of forwarding agentnvarchar100
TOPConditions
8A112Service agent4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
9A113Service agent/Dep.cntry/Dep.post.code/Dest.cntry/Dest.PC4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
10A115Ser.agnt/Dep.ctry/Dep.PC /Ship-to party4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
11A119Service agent/Dep.ctry/Dep.post.code /Dest. country4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
12A124Service agent/Dep.cntry/Dep. PostCode/Tariff zone Dest. loc.4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
13A125Service agent/Tariff zone dep./Tariff zone target4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
14A126Service Agent/TariffZoneDep/TariffZoneDest/Freight Class4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
15A127Service Agent/TariffZoneDep/TariffZoneDest/Incoterms4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
16A128Service Agent/TariffZoneDep/TariffZoneDest/ShippingMatType4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
17A129Service Agent/TariffZDep/TariffZDest/ShipMatType/VSEGR 14TDLNRNumber of forwarding agent in the shipment stagenvarchar100
18A135Transp. service agent/shipping type/bulk group4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
19A507External agent/Shipping point4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
20A508ServcAgent/Ship.type4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
21A510Condition Table for Pricing A5104TDLNRNumber of forwarding agent in the shipment stagenvarchar100
22A511Condition Table for Pricing A5114TDLNRNumber of forwarding agent in the shipment stagenvarchar100
23A796ServcAgent/DepPostCde/RecipCntry4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
24A797ServcAgent/DestCtry/DepPostCde4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
25A799ServcAgent/DepPostCde/DestCtry/DestRegion4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
26A805ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
27A810ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest/FreightCl.5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
28A815ShipmntTyp/ServcAgent/TfZn P.Dep/FreightCl.5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
29A816ShipmntTyp/ServcAgent/TargPostCd5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
30A817ShipmntTyp/ServcAgent/TargPostCd/FreightCl.5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
31A818ShipmntTyp/ServcAgent/DepPostCde5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
32A819ShipmntTyp/ServcAgent/DepPostCde/FreightCl.5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
33A991ServcAgent/Dlv.Prior./TfZn P.Dep/Tf zn.dest4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
34B023TrspPlPoint, TrspProcessingType and Service Agent6TDLNRNumber of forwarding agentnvarchar100
TOPData Collection
35S050Shipment10TDLNRNumber of forwarding agentnvarchar100
36S050ES050 - Structural Information5TDLNRNumber of forwarding agentnvarchar100
37S051Shipment routes12TDLNRNumber of forwarding agentnvarchar100
38S051ES051 - Structural Information7TDLNRNumber of forwarding agentnvarchar100
39S054Stages of shipment10TDLNRNumber of forwarding agent in the shipment stagenvarchar100
40S054ES054 - Structural Information5TDLNRNumber of forwarding agent in the shipment stagenvarchar100
41S055Shipment: materials10TDLNRNumber of forwarding agentnvarchar100
42S055ES055 - Structural Information5TDLNRNumber of forwarding agentnvarchar100
43S950TRANSPORTS9TDLNRN° du transporteurnvarchar100
44S951TRANSPORTS29TDLNRN° du transporteurnvarchar100
TOPFreight Processing
45A130Service agent/tariff zone dep./tariff zone targ/shipping mat4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
46A131Service Agent/TariffZnDp/TariffZnDest/Packaging Matl/VSEGR14TDLNRNumber of forwarding agent in the shipment stagenvarchar100
47TVFPTZTariff Zone Assignment for Postal Code Area3TDLNRNumber of forwarding agentnvarchar100
48TVFPTZHTariff Zone Assignment for Postal Code Area Header Data3TDLNRNumber of forwarding agentnvarchar100
49VFKPShipment Costs: Item Data25TDLNRNumber of service agentnvarchar100
TOPInterfaces
50VLBLTDExpress Delivery Company's Carrier Assignment2TDLNRNumber of forwarding agentnvarchar100
TOPRemaining Beverage - Obsolete Objects
51/DSD/LD_DFTVALDSD - LD: Load Delivery Standard Value4TDLNRNumber of forwarding agentnvarchar100
TOPTraders and Schedulers Workbench
52OIJ_STAGESTSW (&TD) Shipment Stages33TDLNRNumber of forwarding agent in the shipment stagenvarchar100
TOPTransportation
53B045Shipment Type/Transportation Service Agent5TDLNRNumber of forwarding agentnvarchar100
54TVRABRoute Stages13TDLNRNumber of forwarding agentnvarchar100
55TVRORoutes18TDLNRNumber of forwarding agentnvarchar100
56TVT_CA_SDELISelection Variants of Forwarding Agent for Deliveries2TDLNRNumber of forwarding agentnvarchar100
57TVT_CA_SDELI_RRestriction of Fwdg Agent Selection Variants for Deliveries2TDLNRNumber of forwarding agentnvarchar100
58TVT_CA_SSHIPSelection Variants of Forwarding Agent for Shipments2TDLNRNumber of forwarding agentnvarchar100
59TVT_CA_TRATransportation Basis Data for Forwarding Agent2TDLNRNumber of forwarding agentnvarchar100
60TVT_CA_USRAssignment Between Forwarding Agent and SAP System User2TDLNRNumber of forwarding agentnvarchar100
61VTDSTCCondition of Deliveries for Freight Planning by Fwdng Agent3TDLNRNumber of forwarding agentnvarchar100
62VTSPLSAssignment Forwarding Agent - Log. System for Freight Plng2TDLNRNumber of forwarding agentnvarchar100
63VTTKShipment Header60TDLNRNumber of forwarding agentnvarchar100
64VTTSStage of Shipment43TDLNRNumber of forwarding agent in the shipment stagenvarchar100
TOPTransportation and Distribution
65A408Carrier4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
66A409Carrier, Bulk Shipment Type, Depart. Point, Dest. Point4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
67A413Carrier, vehicle type4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
68A414Carrier, Bulk Shipment Type4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
69A415Carrier, Bulk Shipment Type, Destination Tariff Zone4TDLNRNumber of forwarding agent in the shipment stagenvarchar100
70OIGSSTD Shipment Stages33TDLNRNumber of forwarding agent in the shipment stagenvarchar100