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

76 columns | Print definition?ERP 6.0  | INCO1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item62INCO1nvarchar30
2/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item120INCO1nvarchar30
3/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule100INCO1nvarchar30
4/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.71INCO1nvarchar30
5/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.65INCO1nvarchar30
6/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data16INCO1nvarchar30
7/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item17INCO1nvarchar30
8/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data17INCO1nvarchar30
9/SMD/MD_____00GUSID-Tabelle fuer Incoterms3INCO1Incoterms (Part 1)nvarchar30
10/SMD/MD_____00OISID-Tabelle fuer Incoterms3INCO1Incoterms (Part 1)nvarchar30
11/SMD/MD_____00ZTSID-Tabelle fuer Incoterms3INCO1Incoterms (Part 1)nvarchar30
12A501ServcAgent/Incoterms5INCO1Incoterms (Part 1)nvarchar30
13LOP_D_LIST_ITOption list items16INCO1Incoterms (Part 1)nvarchar30
14LOP_D_MASTER_ITOption List items as master data16INCO1Incoterms (Part 1)nvarchar30
15ZCATT_DEMANDTP41Input Data for CATT PC_TPVS_TA_DEMAND19INCO1Incoterms (Part 1)nvarchar30
16ZCMM_MTM_01MtM Persistency per Transaction31INCO1Incoterms (Part 1)nvarchar30
17ZCMM_MTM_TCMtM per TC38INCO1Incoterms (Part 1)nvarchar30
TOPAdvertising Management
18JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header19INCO1Incoterms (Part 1)nvarchar30
TOPAgency Business Global Trade
19WBRKAgency business: Header154INCO1Incoterms (Part 1)nvarchar30
TOPBasic Functions
20A301Info Record Type and Incoterms5INCO1Incoterms (Part 1)nvarchar30
21AKKPDocumentary Payment Guarantee: Fin.Doc.Master - Header Data60INCO1Incoterms (Part 1)nvarchar30
22TINCCustomers: Incoterms2INCO1Incoterms (Part 1)nvarchar30
23TINCTCustomers: Incoterms: Texts3INCO1Incoterms (Part 1)nvarchar30
TOPBilling
24VBRKBilling Document: Header Data20INCO1Incoterms (Part 1)nvarchar30
TOPConditions
25A033Incoterms7INCO1Incoterms (Part 1)nvarchar30
26A034Incoterms Part 1 + 27INCO1Incoterms (Part 1)nvarchar30
27A048Sales conditions sample structure for pricing6INCO1Incoterms (Part 1)nvarchar30
28A050Sales conditions sample structure for pricing5INCO1Incoterms (Part 1)nvarchar30
29A127Service Agent/TariffZoneDep/TariffZoneDest/Incoterms7INCO1Incoterms (Part 1)nvarchar30
30A511Condition Table for Pricing A5115INCO1Incoterms (Part 1)nvarchar30
31A800Sales Org/ Dis Channel/Incoterms6INCO1Incoterms (Part 1)nvarchar30
32A909Sales org./Distr. Chl/Sold-to pt/Incoterms/Inco. 27INCO1Incoterms (Part 1)nvarchar30
33A910Sales org./Distr. Chl/Ship-to/Incoterms/Inco. 27INCO1Incoterms (Part 1)nvarchar30
34A933Sales Organization/Incoterms5INCO1Incoterms (Part 1)nvarchar30
35A936Sales org./Distr. Chl/Shpg Cond./Incoterms/Plant/Ship-to7INCO1Incoterms (Part 1)nvarchar30
TOPConstruction Equipment Management
36J_3GBELKDocument File - Header Data75INCO1Incoterms (Part 1)nvarchar30
TOPCross-Application Components
37VVBKDSales Document: Business Data8INCO1Incoterms (Part 1)nvarchar30
TOPCustomer Master
38KNVVCustomer Master Sales Data18INCO1Incoterms (Part 1)nvarchar30
TOPData Collection
39S055Shipment: materials11INCO1Incoterms (Part 1)nvarchar30
40S055ES055 - Structural Information6INCO1Incoterms (Part 1)nvarchar30
41S260SD - Sales order64INCO1Incoterms (Part 1)nvarchar30
42S260BIW1SD - Sales order64INCO1Incoterms (Part 1)nvarchar30
43S260BIW2SD - Sales order64INCO1Incoterms (Part 1)nvarchar30
44S261SD - Delivery note28INCO1Incoterms (Part 1)nvarchar30
45S261BIW1SD - Delivery note28INCO1Incoterms (Part 1)nvarchar30
46S261BIW2SD - Delivery note28INCO1Incoterms (Part 1)nvarchar30
47S263SD - Sales order/delivery note54INCO1Incoterms (Part 1)nvarchar30
48S263BIW1SD - Sales order/delivery note54INCO1Incoterms (Part 1)nvarchar30
49S263BIW2SD - Sales order/delivery note54INCO1Incoterms (Part 1)nvarchar30
50S264SD- Offer66INCO1Incoterms (Part 1)nvarchar30
51S264BIW1S264BIW1 * SD - Quotation66INCO1Incoterms (Part 1)nvarchar30
52S264BIW2S264BIW2 * SD - Quotation66INCO1Incoterms (Part 1)nvarchar30
TOPData Retention Tool
53TXW_S_EKKORetrieve EKKO from archive11INCO1Incoterms (Part 1)nvarchar30
54TXW_S_EKPORetrieve EKPO from archive8INCO1Incoterms (Part 1)nvarchar30
55TXW_S_VBRKRetrieve VBRK from archive16INCO1Incoterms (Part 1)nvarchar30
TOPIntegration
56FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts13INCO1Incoterms (Part 1)nvarchar30
TOPInventory Management
57MWZDM07M1ZDM07M159INCO1Incoterms (Part 1)nvarchar30
TOPLocalization
58J_1BNFDOCNota Fiscal Header40INCO1Incoterms (Part 1)nvarchar30
TOPPeriodical Sales and Distribution
59JKKDSales Order: Business Data7INCO1Incoterms (Part 1)nvarchar30
TOPPurchasing
60EINEPurchasing Info Record: Purchasing Organization Data54INCO1Incoterms (Part 1)nvarchar30
61EKKOPurchasing Document Header47INCO1Incoterms (Part 1)nvarchar30
62EKPOPurchasing Document Item108INCO1Incoterms (Part 1)nvarchar30
63WRF_POHF_POLOrder list49INCO1Incoterms (Part 1)nvarchar30
TOPSales
64VBKDSales Document: Business Data8INCO1Incoterms (Part 1)nvarchar30
TOPShipping
65LIKPSD Document: Delivery Header Data18INCO1Incoterms (Part 1)nvarchar30
TOPSimulation
66VSVBKD_CNVersion: Sales document - commercial data9INCO1Incoterms (Part 1)nvarchar30
TOPTariffs, Duties and Permits
67A424Exception for States (FOB)6INCO1Incoterms (Part 1)nvarchar30
68A425State Tax FOB5INCO1Incoterms (Part 1)nvarchar30
69A426State Tax on delivered goods5INCO1Incoterms (Part 1)nvarchar30
70A434Incoterms / Material group 2 - Federal4INCO1Incoterms (Part 1)nvarchar30
TOPTraders and Schedulers Workbench
71TOI0_REL_MMRelevance customizing for MM Documents23INCO1Incoterms (Part 1)nvarchar30
72TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents26INCO1Incoterms (Part 1)nvarchar30
TOPTransportation
73VTRDIShipment Planning Index23INCO1Incoterms (Part 1)nvarchar30
74VTTSStage of Shipment15INCO1Incoterms for printoutnvarchar30
TOPVendor Master
75LFM1Vendor master record purchasing organization data14INCO1Incoterms (Part 1)nvarchar30
76LFM2Vendor Master Record: Purchasing Data16INCO1Incoterms (Part 1)nvarchar30