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

179 tablesERP 6.0 

Logistics Execution :: Transportation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0B04561Shipment Type/Transportation Service AgentTransportation
2ERP EHP76.0T17341Routes: Mode of Transport for Each Shipping TypeTransportation
3ERP EHP76.0T173T41Routes: Mode of Transport by Shipping Type: TextsTransportation
4ERP EHP76.0T644111Routes: Transit Route(s) (Country Sequence)Transportation
5ERP EHP76.0TGAF41Freight Code DeterminationTransportation
6ERP EHP76.0TGAR41Freight CodesTransportation
7ERP EHP76.0TGART51Freight codes:descriptionsTransportation
8ERP EHP76.0TGAV21Freight Code SetsTransportation
9ERP EHP76.0TGAVF51Determine Freight Code SetTransportation
10ERP EHP76.0TGAVT41Freight code set: descriptionsTransportation
11ERP EHP76.0TMFG21Material freight groupsTransportation
12ERP EHP76.0TMFGT41Material freight groups: DescriptionsTransportation
13ERP EHP76.0TROIZ51Route Determination: By Country and ZoneTransportation
14ERP EHP76.0TROLZ91Routes: Determination in DeliveriesTransportation
15ERP EHP76.0TRXEC21Tracking: Main Transaction TypesTransportation
16ERP EHP76.0TRXECT41Tracking: Texts for main process typesTransportation
17ERP EHP76.0TRXEVT31Tracking: Transactions and EventsTransportation
18ERP EHP76.0TRXEVTT51Tracking: Transactions and EventsTransportation
19ERP EHP76.0TRXIC21Tracking: Code Types for Tracking IDsTransportation
20ERP EHP76.0TRXICT41Tracking: Texts for tracking ID code typesTransportation
21ERP EHP76.0TRXLC21Tracking: Code types for locationsTransportation
22ERP EHP76.0TRXLCT51Tracking: Texts for location code typesTransportation
23ERP EHP76.0TRXPC21Tracking: Code types for partnersTransportation
24ERP EHP76.0TRXPCT41Tracking: Texts for partner code typesTransportation
25ERP EHP76.0TRXRT21Tracking: Code types for route typesTransportation
26ERP EHP76.0TRXRTT41Tracking: Texts for route type code typesTransportation
27ERP EHP76.0TRXSEC21Tracking: Types of sub-operationTransportation
28ERP EHP76.0TRXSECT41Tracking: Texts for sub-operation typesTransportation
29ERP EHP76.0TSFG21Forwarding agent freight groupTransportation
30ERP EHP76.0TSFGT41Forward. Agent-Freight Groups:DescriptnTransportation
31ERP EHP76.0TTDS201Organizational Unit: Transportation Scheduling PointTransportation
32ERP EHP76.0TTDST41Organizational Unit: Transportation Scheduling Point: TextsTransportation
33ERP EHP76.0TTPLST41Determination of Transportation Planning Point f. BAPI CallTransportation
34ERP EHP76.0TTSG21Shipment Blocking ReasonTransportation
35ERP EHP76.0TTSGT41Description of Reason for Shipment BlockTransportation
36ERP EHP76.0TVARS161Archiving Control ShipmentTransportation
37ERP EHP76.0TVKN281Routes: Transportation Connection PointsTransportation
38ERP EHP76.0TVKNT51Routes: Transportation connection points: TextsTransportation
39ERP EHP76.0TVRAB224Route StagesTransportation
40ERP EHP76.0TVRO221RoutesTransportation
41ERP EHP76.0TVROT41Routes: TextsTransportation
42ERP EHP76.0TVRSZ52Routes: Legs for each RouteTransportation
43ERP EHP76.0TVSAK21Special Processing IndicatorTransportation
44ERP EHP76.0TVSAKT41Special Processing Indicator: TextsTransportation
45ERP EHP76.0TVSR43Routes: LegsTransportation
46ERP EHP76.0TVTK691Shipment TypesTransportation
47ERP EHP76.0TVTKT41Transport Type: DescriptionTransportation
48ERP EHP76.0TVTR41Routes: Modes of TransportTransportation
49ERP EHP76.0TVTRT41Routes: Method of Transportation TextsTransportation
50ERP EHP76.0TVT_CA_SDELI31Selection Variants of Forwarding Agent for DeliveriesTransportation
51ERP EHP76.0TVT_CA_SDELI_R51Restriction of Fwdg Agent Selection Variants for DeliveriesTransportation
52ERP EHP76.0TVT_CA_SSHIP51Selection Variants of Forwarding Agent for ShipmentsTransportation
53ERP EHP76.0TVT_CA_TRA51Transportation Basis Data for Forwarding AgentTransportation
54ERP EHP76.0TVT_CA_USR31Assignment Between Forwarding Agent and SAP System UserTransportation
55ERP EHP76.0VTADD0121Checking Table Supplement 1Transportation
56ERP EHP76.0VTADD01T41Checking Table Supplement: DescriptionTransportation
57ERP EHP76.0VTADD0221Checking Table Supplement 2Transportation
58ERP EHP76.0VTADD02T41Checking Table Supplement: DescriptionsTransportation
59ERP EHP76.0VTADD0321Checking Table Supplement 3Transportation
60ERP EHP76.0VTADD03T41Checking Table Supplement 3: DescriptionTransportation
61ERP EHP76.0VTADD0421Checking Table Supplement 4Transportation
62ERP EHP76.0VTADD04T41Checking Table Supplement 4: DescriptionTransportation
63ERP EHP76.0VTCFPP91Freight Planning Transfer ProfileTransportation
64ERP EHP76.0VTCFPPT41Text for Freight Planning Communication ProfilesTransportation
65ERP EHP76.0VTDST212Status of deliveries within transportation planningTransportation
66ERP EHP76.0VTDSTC272Condition of Deliveries for Freight Planning by Fwdng AgentTransportation
67ERP EHP76.0VTFA162Shipment Document FlowTransportation
68ERP EHP76.0VTLST61Status of Gen. Location in Ext. Transportatn Planning SystemTransportation
69ERP EHP76.0VTPA201Shipping PartnerTransportation
70ERP EHP76.0VTPRG52Transport. planng system cumulation proc. for delivery itemTransportation
71ERP EHP76.0VTPRK41Cond. Sequence for Loc. Subst. in Transportation PlanningTransportation
72ERP EHP76.0VTPRL102Transportation Planning System Route LimitationsTransportation
73ERP EHP76.0VTPRS21Det. Procedure for Loc. Subst. in Transportation PlanningTransportation
74ERP EHP76.0VTPRST41Texts for Determination Procedures for Location SubstitutionTransportation
75ERP EHP76.0VTRDI362Shipment Planning IndexTransportation
76ERP EHP76.0VTSP41Stage of Transport / Item AllocationTransportation
77ERP EHP76.0VTSPLS61Assignment Forwarding Agent - Log. System for Freight PlngTransportation
78ERP EHP76.0VTTK1403Shipment HeaderTransportation
79ERP EHP76.0VTTP102Shipment ItemTransportation
80ERP EHP76.0VTTS751Stage of ShipmentTransportation
Logistics Execution :: Transportation :: Freight Processing
ProductVersionTableColumnsIndexesDescriptionModule
81ERP EHP76.0A130101Service agent/tariff zone dep./tariff zone targ/shipping matFreight Processing
82ERP EHP76.0A131111Service Agent/TariffZnDp/TariffZnDest/Packaging Matl/VSEGR1Freight Processing
83ERP EHP76.0T685S101Condition Types: Scales for ConditionsFreight Processing
84ERP EHP76.0TIARS61Archiving Control Shipment CostsFreight Processing
85ERP EHP76.0TVFAP61Shipment Cost Information Profile DataFreight Processing
86ERP EHP76.0TVFAPT41Shipment Cost Information Profile: DescriptionsFreight Processing
87ERP EHP76.0TVFAW31Shipment Cost Info Profile - Planning Profile Assig. (VT04)Freight Processing
88ERP EHP76.0TVFBWA101Minimum Weights for Shipping UnitsFreight Processing
89ERP EHP76.0TVFBWAF71Bulkiness FactorsFreight Processing
90ERP EHP76.0TVFBWG31Definition of Bulkiness GroupsFreight Processing
91ERP EHP76.0TVFBWGT51Descriptions for Bulkiness GroupsFreight Processing
92ERP EHP76.0TVFCD21Service Agent Procedure Group for Shipment CostsFreight Processing
93ERP EHP76.0TVFCDT41Description for Service Agent Procedure GroupFreight Processing
94ERP EHP76.0TVFCG21Item Procedure Group for Shipment CostsFreight Processing
95ERP EHP76.0TVFCGT41Description for Item Procedure Group Shipment CostsFreight Processing
96ERP EHP76.0TVFCSF61Pricing Procedure DeterminationFreight Processing
97ERP EHP76.0TVFCV21Shipping Type Procedure Group for Shipment CostsFreight Processing
98ERP EHP76.0TVFCVT41Description for Shipping Type Procedure Group Shipment CostsFreight Processing
99ERP EHP76.0TVFP61Assignment of Purchasing Data for Shipment CostsFreight Processing
100ERP EHP76.0TVFPTZ81Tariff Zone Assignment for Postal Code AreaFreight Processing
101ERP EHP76.0TVFPTZH51Tariff Zone Assignment for Postal Code Area Header DataFreight Processing
102ERP EHP76.0TVFRDR21Rounding RulesFreight Processing
103ERP EHP76.0TVFRDRT41Descriptions for Rounding RulesFreight Processing
104ERP EHP76.0TVFRDRX51Definition of Rounding RulesFreight Processing
105ERP EHP76.0TVFRFQ21Scale BasesFreight Processing
106ERP EHP76.0TVFRFQT41Descriptions for Scale BasesFreight Processing
107ERP EHP76.0TVFSCB571Scale BasesFreight Processing
108ERP EHP76.0TVFT111Shipment Cost Item CategoriesFreight Processing
109ERP EHP76.0TVFTK81Determination: Shipment Cost Item CategoriesFreight Processing
110ERP EHP76.0TVFTR21Rules for Date Determination for Shipment CostingFreight Processing
111ERP EHP76.0TVFTRP41Detail of Rules for Date Determination in Shipment CostingFreight Processing
112ERP EHP76.0TVFTRT41Description of Rules for Date Det. in Shipment CostingFreight Processing
113ERP EHP76.0TVFTT41Shipment Cost Item Categories: DescriptionsFreight Processing
114ERP EHP76.0TVFTZ21Tariff Zones for Shipment CostsFreight Processing
115ERP EHP76.0TVFTZT41Description of Tariff Zone for Shipment CostsFreight Processing
116ERP EHP76.0TVTF71Shipment Cost TypesFreight Processing
117ERP EHP76.0TVTFT41Shipment Cost Types: DescriptionsFreight Processing
118ERP EHP76.0V54IV_SELOPT101Incoming Invoice: Selection Transportation Service ProviderFreight Processing
119ERP EHP76.0VFKGRP361(Freight) Group ConditionsFreight Processing
120ERP EHP76.0VFKK181Shipment Costs: Header DataFreight Processing
121ERP EHP76.0VFKN421Account Determination in Shipment Costs ItemFreight Processing
122ERP EHP76.0VFKONV411(Freight) ConditionsFreight Processing
123ERP EHP76.0VFKONX62Conditions: Dimension-Dependent DataFreight Processing
124ERP EHP76.0VFKP642Shipment Costs: Item DataFreight Processing
125ERP EHP76.0VFPA201Partner for Shipment CostsFreight Processing
126ERP EHP76.0VFSCAH231Scale HeaderFreight Processing
127ERP EHP76.0VFSCAHT41Descriptions for ScalesFreight Processing
128ERP EHP76.0VFSCAID51Scale Item: Gross WeightFreight Processing
129ERP EHP76.0VFSCAIF51Scale Item: Gross VolumeFreight Processing
130ERP EHP76.0VFSCAIF051Scale Item: MeasuringFreight Processing
131ERP EHP76.0VFSCAIL051Scale Item: Postal CodeFreight Processing
132ERP EHP76.0VFSCAIL251Scale Item: Tariff ZoneFreight Processing
133ERP EHP76.0VFSCAIL451Scale Item: Transportation ZoneFreight Processing
134ERP EHP76.0VFSCAIL651Scale Item: RegionFreight Processing
135ERP EHP76.0VFSCAIR51Scale Item: DistanceFreight Processing
136ERP EHP76.0VFSCAIS51Scale Item: Number of Shipping UnitsFreight Processing
137ERP EHP76.0VFSCAIS051Key Item: Shipping MaterialFreight Processing
138ERP EHP76.0VFSCAIS151Scale Item: Length of Loading Platform (Shipping Unit)Freight Processing
139ERP EHP76.0VFSCAIT051Scale Item: Duration (Idle Time, Travel Time, and so on)Freight Processing
140ERP EHP76.0VFSCAR161Freight Rates (One-Dimensional)Freight Processing
141ERP EHP76.0VFSCAR261Freight Rates (Two-Dimensional)Freight Processing
142ERP EHP76.0VFSCAR371Freight Rates (Three-Dimensional)Freight Processing
143ERP EHP76.0VFSI281Shipment Costs: Sub-item DataFreight Processing
144ERP EHP76.0VFZP91Correct Original Assignmen of ConditionsFreight Processing
Logistics Execution :: Transportation :: Interfaces
ProductVersionTableColumnsIndexesDescriptionModule
145ERP EHP76.0CIF_MAP_SP_SL31Unique Mapping of Shipping Point to Storage LocationInterfaces
146ERP EHP76.0CMCONNECT52Setup of Continuous MovesInterfaces
147ERP EHP76.0VLBL61Express Delivery Company's Data FieldInterfaces
148ERP EHP76.0VLBLTD41Express Delivery Company's Carrier AssignmentInterfaces
149ERP EHP76.0VRTCO91Routing Info per Carrier/Country/LocationInterfaces
150ERP EHP76.0VRTCP91Routing Info per Carrier/Country/Zip CodeInterfaces
151ERP EHP76.0VRTCPR101Routing Info per Carrier/Country/Zip Code AreaInterfaces
152ERP EHP76.0VTRKH294Tracking Data - HeaderInterfaces
153ERP EHP76.0VTRKP111Tracking Data - ItemInterfaces
154ERP EHP76.0VXSIFN31Express Dlv. Company: Funct. Module for VXSITDL Data FieldsInterfaces
155ERP EHP76.0VXSIFNT41Small Parcel Carrier: Function Module DescriptionInterfaces
156ERP EHP76.0VXSIG61Express Delivery Company: Weight CodesInterfaces
157ERP EHP76.0VXSIP31Express Delivery Company: Product CodesInterfaces
158ERP EHP76.0VXSIPS61Packing StationInterfaces
159ERP EHP76.0VXSIPST41Description of Packing StationInterfaces
160ERP EHP76.0VXSIPT51Express Delivery Company: Product Code DescriptionInterfaces
161ERP EHP76.0VXSIQ21Small Parcel Carrier: Qualifier for CommunicationInterfaces
162ERP EHP76.0VXSIQE51Small Parcel Carrier: Conversion into External QualifierInterfaces
163ERP EHP76.0VXSIQT41Small Parcel Carrier: Descr. of Qualifier for Ext. Comm.Interfaces
164ERP EHP76.0VXSIS41Small Parcel Carrier: Special Processing (Service Code)Interfaces
165ERP EHP76.0VXSISP41Express Delivery Company: Delivery Priority -> Service CodeInterfaces
166ERP EHP76.0VXSISR41Small Parcel Carrier: Route -> Service CodeInterfaces
167ERP EHP76.0VXSISV41Small Parcel Carrier: Shipping Condition (Service Code)Interfaces
168ERP EHP76.0VXSITD221Express Delivery CompanyInterfaces
169ERP EHP76.0VXSITDL301Express Delivery Company: Meta Description Data FieldInterfaces
170ERP EHP76.0VXSITDLT51Small Parcel Carrier: Data Field (Type Description)Interfaces
171ERP EHP76.0VXSITDLV131Small Parcel Carrier: Data Fields per Shipping PointInterfaces
172ERP EHP76.0VXSITDNSO31Number Range Sub-objectInterfaces
173ERP EHP76.0VXSITDT41Express Delivery Company: DescriptionInterfaces
174ERP EHP76.0VXSITDU61Express Delivery Company: URLsInterfaces
175ERP EHP76.0VXSITS61Express Delivery Company: Service CodesInterfaces
176ERP EHP76.0VXSITST51Small Parcel Carrier: Service Codes DescriptionInterfaces
177ERP EHP76.0VXSIV61Express Delivery Company: Shipping Point: ControlInterfaces
178ERP EHP76.0VXTRKS41Tracking Status DetailsInterfaces
179ERP EHP76.0VXTRKST51Tracking Status DetailsInterfaces