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

38 columns | Print definition?ERP 6.0  | LLAND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1A945Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region7LLANDCountry of Destinationnvarchar30
2A960Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region7LLANDCountry of Destinationnvarchar30
3A990CoCode/Dest. Ctry/Material5LLANDCountry of Destinationnvarchar30
4TVSROShipping points: Countries in Which Routes are Defined3LLANDCountry of Destinationnvarchar30
TOPAdvertising Management
5JHTFXIS-M/AM: Billing Index - Order Billing18LLANDCountry of Destinationnvarchar30
TOPBasic Functions
6A340Foreign Trade: CAP: Restitution rates5LLANDCountry of Destinationnvarchar30
7T604UForeign Trade: Convert Commodity Code/Import Code No.4LLANDCountry of Destinationnvarchar30
8T605UForeign Trade: Convert Export/Import Bus. Trans. Type4LLANDCountry of Destinationnvarchar30
9T615UForeign Trade: Import/Export Customs Office Conversion4LLANDCountry of Destinationnvarchar30
10T616UForeign Trade: Import/Export Procedure Conversion4LLANDCountry of Destinationnvarchar30
11T617Foreign Trade: Proposal for Foreign Trade Header Data5LLANDCountry Keynvarchar30
12T618UForeign Trade: Conversion of Import/Export Mode of Transport4LLANDCountry of Destinationnvarchar30
13TROAZRoutes: Determination in Sales Documents6LLANDCountry of Destinationnvarchar30
TOPConditions
14A011Country/Country of Dest./Customer Classif./Material Classif.5LLANDCountry of Destinationnvarchar30
15A078Departure Country / Destination Country5LLANDCountry of Destinationnvarchar30
16A080Taxes: Material4LLANDCountry of Destinationnvarchar30
17A086Taxes: Material, Plant and Origin4LLANDCountry of Destinationnvarchar30
18A087Taxes: Plant, Account Assignment and Origin4LLANDCountry of Destinationnvarchar30
19A088Taxes: Material, Plant, Account Assignment and Origin4LLANDCountry of Destinationnvarchar30
20A094Taxes: Material, Plant, Origin and Region4LLANDCountry of Destinationnvarchar30
21A110Sales Organization/Destination Country5LLANDCountry of Destinationnvarchar30
22A150Dest. Ctry/Material4LLANDCountry of Destinationnvarchar30
23A156Country of Departure/Destination Country/Del. Country5LLANDCountry of Destinationnvarchar30
24A518Limit value determination for stock transport order5LLANDCountry of Destinationnvarchar30
25A796ServcAgent/DepPostCde/RecipCntry6LLANDCountry of Destinationnvarchar30
TOPData Collection
26S005SIS: Shipping Point/Route/Forwarding Agent/Receiving Country11LLANDCountry of Destinationnvarchar30
27S005BIW1S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country6LLANDCountry of Destinationnvarchar30
28S005BIW2S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country6LLANDCountry of Destinationnvarchar30
29S005ES005 - Structural Information6LLANDCountry of Destinationnvarchar30
30S050Shipment13LLANDCountry: shipment endnvarchar30
31S050ES050 - Structural Information8LLANDCountry: shipment endnvarchar30
TOPLocalization
32A151Dest. Ctry/Comm. code4LLANDCountry of Destinationnvarchar30
TOPLogistics - General
33A191Condition Table for Pricing A1915LLANDCountry of Destinationnvarchar30
TOPPeriodical Sales and Distribution
34JFDFSIS-M/SD: Billing/Settlement Index19LLANDCountry of Destinationnvarchar30
TOPRecycling Administration Core Functions
35J_7LV1PREA Document: Item Data62LLANDCountry of Destinationnvarchar30
TOPSales
36VKDFSSD Index: Billing Initiator7LLANDCountry of Destinationnvarchar30
TOPTransportation
37TROIZRoute Determination: By Country and Zone4LLANDCountry of Destinationnvarchar30
38TROLZRoutes: Determination in Deliveries6LLANDCountry of Destinationnvarchar30