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

143 columns | Print definition?ERP 6.0  | KDGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000464T1515KDGRPnvarchar20
2/1CADMC/00000465T151T6KDGRPnvarchar20
3/1RA/0SD010MIItems for Class SD01 - Raw Data69KDGRPCustomer groupnvarchar20
4/1RA/0SD012MIItems for Class SD01 - Processable53KDGRPCustomer groupnvarchar20
5/1RA/0SD014MIItems for Class SD01 - Processed53KDGRPCustomer groupnvarchar20
6/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item64KDGRPnvarchar20
7/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item122KDGRPnvarchar20
8/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule102KDGRPnvarchar20
9/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.73KDGRPnvarchar20
10/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.67KDGRPnvarchar20
11/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data18KDGRPnvarchar20
12/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item19KDGRPnvarchar20
13/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data19KDGRPnvarchar20
14/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item15KDGRPnvarchar20
15/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.15KDGRPnvarchar20
16/SMD/MD_____00YNSID-Tabelle fuer Customer group3KDGRPCustomer groupnvarchar20
17CE1PR22Périm. résultat IDES65KDGRPGroupe de clientsnvarchar20
18CE2PR22Périm. résultat IDES49KDGRPGroupe de clientsnvarchar20
19CE4PR22Périm. résultat IDES34KDGRPGroupe de clientsnvarchar20
20CE4PR22_ACCTPérim. résultat IDES35KDGRPGroupe de clientsnvarchar20
21CE4PR22_FLAGPérim. résultat IDES31KDGRPFlag : caract. imputée manuellement ou via TKEZUnvarchar10
22CE4PR22_KENCPérim. résultat IDES33KDGRPGroupe de clientsnvarchar20
23FSH_OS_SDOrder Type specific data for sales organisation/distribution14KDGRPCustomer groupnvarchar20
24FSH_OS_STODocument type customizing for STO's13KDGRPCustomer groupnvarchar20
25FSH_SD_PERIODSCondition Records For Season Determination in SD11KDGRPCustomer groupnvarchar20
TOPAdvertising Management
26JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset86KDGRPCustomer groupnvarchar20
27JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order42KDGRPCustomer groupnvarchar20
28JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition49KDGRPCustomer groupnvarchar20
29JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties46KDGRPCustomer groupnvarchar20
30JHTFPIS-M/AM: Billing/Settlement Documents - Item6KDGRPCustomer groupnvarchar20
31JJTBEPARTIS-M/AM: Booking Unit Elements (AI)13KDGRPCustomer groupnvarchar20
TOPBasic Functions
32KNKKCustomer master credit management: Control area data27KDGRPCustomer Groupnvarchar80
TOPBilling
33A145Sales Deal - Customer/Material7KDGRPCustomer groupnvarchar20
34A146Customer Hierarchy9KDGRPCustomer groupnvarchar20
35A147Customer Hierarchy (Sales Deal)9KDGRPCustomer groupnvarchar20
36VBRKBilling Document: Header Data17KDGRPCustomer groupnvarchar20
TOPConditions
37KOTG601DSD-Cust.group/Matl Group4KDGRPCustomer groupnvarchar20
TOPCross-Application Components
38VVBKDSales Document: Business Data5KDGRPCustomer groupnvarchar20
TOPCustomer Master
39KNVVCustomer Master Sales Data13KDGRPCustomer groupnvarchar20
TOPData Collection
40CF703IDES Profitability12KDGRPCustomer groupnvarchar20
41CF720Top EIS Aspect20KDGRPCustomer groupnvarchar20
42S008Communications Table SD -> CO/Projects50KDGRPCustomer groupnvarchar20
43S123Customer / material group70KDGRPCustomer groupnvarchar20
44S124Customer / material70KDGRPCustomer groupnvarchar20
45S140Product Allocations11KDGRPCustomer groupnvarchar20
46S140ES140 - Structural Information6KDGRPCustomer groupnvarchar20
47S260SD - Sales order62KDGRPCustomer groupnvarchar20
48S260BIW1SD - Sales order62KDGRPCustomer groupnvarchar20
49S260BIW2SD - Sales order62KDGRPCustomer groupnvarchar20
50S261SD - Delivery note20KDGRPCustomer groupnvarchar20
51S261BIW1SD - Delivery note20KDGRPCustomer groupnvarchar20
52S261BIW2SD - Delivery note20KDGRPCustomer groupnvarchar20
53S262SD - Billing document24KDGRPCustomer groupnvarchar20
54S262BIW1SD - Billing document24KDGRPCustomer groupnvarchar20
55S262BIW2SD - Billing document24KDGRPCustomer groupnvarchar20
56S263SD - Sales order/delivery note52KDGRPCustomer groupnvarchar20
57S263BIW1SD - Sales order/delivery note52KDGRPCustomer groupnvarchar20
58S263BIW2SD - Sales order/delivery note52KDGRPCustomer groupnvarchar20
59S264SD- Offer64KDGRPCustomer groupnvarchar20
60S264BIW1S264BIW1 * SD - Quotation64KDGRPCustomer groupnvarchar20
61S264BIW2S264BIW2 * SD - Quotation64KDGRPCustomer groupnvarchar20
TOPExcise Duty
62/BEV2/ED911Excise Duty Customer Groups2KDGRPCustomer groupnvarchar20
63/BEV2/ED963Assignment Customer Groups to Special Partner Types2KDGRPCustomer groupnvarchar20
TOPHandheld Connectivity
64/DSD/PR_ASGNMDSD Promotions - Promotion Assignment9KDGRPCustomer groupnvarchar20
65/DSD/PR_CUFCMDSD Promotions - Field Selection11KDGRPDSD Deal Conditions - Customer Group Active Flagnvarchar10
TOPMarketing, Accounting and Pricing
66A420SalesOrg/DistCh/CustGrp/ProdHier/PricDRC6KDGRPCustomer groupnvarchar20
67A421SalesOrg/DistCh/CustGrp/Plant/ProdHier/PricDRC6KDGRPCustomer groupnvarchar20
68A428SalesOrg/DistChann/CustGrp/DRCMetrInd/ProdHier6KDGRPCustomer groupnvarchar20
TOPMaterial Maintenance
69T151Customers: Customer Groups2KDGRPCustomer groupnvarchar20
70T151TCustomers: Customer groups: Texts3KDGRPCustomer groupnvarchar20
TOPMedia Product Sales and Distribution
71JKSDCONTRACTCHARAdditional Fields for Sales Quantity Planning7KDGRPCustomer groupnvarchar20
TOPMedia Sales and Distribution
72/NAM/TJKAPPL_CMPApplication Access for Complaint Charges7KDGRPCustomer groupnvarchar20
73/NAM/TJKAPPL_MONApplication Access for Determination of Monitoring10KDGRPCustomer groupnvarchar20
74/NAM/TJKAPPL_OFRApplication Access for Renewal Offers10KDGRPCustomer groupnvarchar20
75/NAM/TJKOFF_DATARenewal Offer Code Data7KDGRPCustomer groupnvarchar20
TOPNon-Ferrous Metal enhancements
76/NFM/TDEF_DIFFDifferent Rate Determination4KDGRPCustomer groupnvarchar20
TOPPeriodical Sales and Distribution
77JFRKIS-M/SD: Billing - Header Data15KDGRPCustomer groupnvarchar20
78JKAPPRAd Pre-Print Order: Item Data8KDGRPCustomer group for which insertions are madenvarchar20
79JKKDSales Order: Business Data5KDGRPCustomer groupnvarchar20
80JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet15KDGRPCustomer groupnvarchar20
81JVTNCT4IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS31KDGRPCustomer groupnvarchar20
82TJI05IS-M/SD: Basic Audit Report Category Default: Periodical SD4KDGRPCustomer groupnvarchar20
83TJI06IS-M/SD: Basic Audit Report Category Default - Media Product5KDGRPCustomer groupnvarchar20
84TJKWWIS-M/SD: Control Table for Creating Trial Subscriptions10KDGRPCustomer groupnvarchar20
85TJKWWW_FIXIS-M/SD: WWW, Combinations of Fixed Order Values15KDGRPCustomer groupnvarchar20
TOPProfitability Analysis
86CE1850059KDGRPCustomer groupnvarchar20
87CE1BGISErgebnisbereich für59KDGRPKundengruppenvarchar20
88CE1IDEAOp. Concern BR World65KDGRPCustomer groupnvarchar20
89CE1IDEBErgebnisbereich IDES57KDGRPKundengruppenvarchar20
90CE1IDESErgebnisbereich IDES65KDGRPKundengruppenvarchar20
91CE1INT1Ergebnisbereich IDES65KDGRPKundengruppenvarchar20
92CE1OC01Bike International64KDGRPCustomer groupnvarchar20
93CE1S001Sample operating concern42KDGRPCustomer groupnvarchar20
94CE1S_GOQuickstart Template59KDGRPCustomer groupnvarchar20
95CE2850043KDGRPCustomer groupnvarchar20
96CE2BGISErgebnisbereich für43KDGRPKundengruppenvarchar20
97CE2IDEAOp. Concern BR World49KDGRPCustomer groupnvarchar20
98CE2IDEBErgebnisbereich IDES41KDGRPKundengruppenvarchar20
99CE2IDESErgebnisbereich IDES49KDGRPKundengruppenvarchar20
100CE2INT1Ergebnisbereich IDES49KDGRPKundengruppenvarchar20
101CE2OC01Bike International48KDGRPCustomer groupnvarchar20
102CE2S001Sample operating concern32KDGRPCustomer groupnvarchar20
103CE2S_GOQuickstart Template43KDGRPCustomer groupnvarchar20
104CE4850028KDGRPCustomer groupnvarchar20
105CE48500_ACCT29KDGRPCustomer groupnvarchar20
106CE48500_FLAG25KDGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
107CE48500_KENC27KDGRPCustomer groupnvarchar20
108CE4BGISErgebnisbereich für28KDGRPKundengruppenvarchar20
109CE4BGIS_ACCTErgebnisbereich für29KDGRPKundengruppenvarchar20
110CE4BGIS_FLAGErgebnisbereich für25KDGRPFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
111CE4BGIS_KENCErgebnisbereich für27KDGRPKundengruppenvarchar20
112CE4IDEAOp. Concern BR World34KDGRPCustomer groupnvarchar20
113CE4IDEA_ACCTOp. Concern BR World35KDGRPCustomer groupnvarchar20
114CE4IDEA_FLAGOp. Concern BR World31KDGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
115CE4IDEA_KENCOp. Concern BR World33KDGRPCustomer groupnvarchar20
116CE4IDEBErgebnisbereich IDES26KDGRPKundengruppenvarchar20
117CE4IDEB_ACCTErgebnisbereich IDES27KDGRPKundengruppenvarchar20
118CE4IDEB_FLAGErgebnisbereich IDES Banking23KDGRPFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
119CE4IDEB_KENCErgebnisbereich IDES25KDGRPKundengruppenvarchar20
120CE4IDESErgebnisbereich IDES34KDGRPKundengruppenvarchar20
121CE4IDES_ACCTErgebnisbereich IDES35KDGRPKundengruppenvarchar20
122CE4IDES_FLAGErgebnisbereich IDES31KDGRPFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
123CE4IDES_KENCErgebnisbereich IDES33KDGRPKundengruppenvarchar20
124CE4INT1Ergebnisbereich IDES34KDGRPKundengruppenvarchar20
125CE4INT1_ACCTErgebnisbereich IDES35KDGRPKundengruppenvarchar20
126CE4INT1_FLAGErgebnisbereich IDES31KDGRPFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
127CE4INT1_KENCErgebnisbereich IDES33KDGRPKundengruppenvarchar20
128CE4OC01Bike International33KDGRPCustomer groupnvarchar20
129CE4OC01_ACCTBike International34KDGRPCustomer groupnvarchar20
130CE4OC01_KENCBike International32KDGRPCustomer groupnvarchar20
131CE4S001Sample operating concern19KDGRPCustomer groupnvarchar20
132CE4S001_ACCTSample operating con27KDGRPCustomer groupnvarchar20
133CE4S001_FLAGSample Operating Concern 123KDGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
134CE4S001_KENCSample operating con24KDGRPCustomer groupnvarchar20
135CE4S_GOQuickstart Template28KDGRPCustomer groupnvarchar20
136CE4S_GO_ACCTQuickstart Template29KDGRPCustomer groupnvarchar20
137CE4S_GO_FLAGQuickstart Template25KDGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
138CE4S_GO_KENCQuickstart Template27KDGRPCustomer groupnvarchar20
TOPSales
139VBKDSales Document: Business Data5KDGRPCustomer groupnvarchar20
TOPSales and Distribution SD enhancements
140/SAPMP/SD_LEIHGReturnable Packaging Settlement22KDGRPCustomer groupnvarchar20
141/SAPMP/SD_LGFKFree-of-Charge Period for Customer Group4KDGRPCustomer groupnvarchar20
TOPShipping
142LIKPSD Document: Delivery Header Data32KDGRPCustomer groupnvarchar20
TOPSimulation
143VSVBKD_CNVersion: Sales document - commercial data6KDGRPCustomer groupnvarchar20