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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

210 columns | Print definition?ERP 6.0  | BEGRU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table73BEGRUAuthorization Groupnvarchar40
2/SMERP/STG_MM002Data staging - Material storage location view complex table73BEGRUAuthorization Groupnvarchar40
3/SMERP/STG_MM003Data staging - Material UoM view complex table74BEGRUAuthorization Groupnvarchar40
4/SMERP/STG_MM004Data staging - Material warehouse view complex table73BEGRUAuthorization Groupnvarchar40
5/SMERP/STG_MM005Data staging - Material batch view complex table73BEGRUAuthorization Groupnvarchar40
6/SMERP/STG_PM001Data staging - Equipment complex table14BEGRUTechnical object authorization groupnvarchar40
7/SMERP/STG_PM002Data staging - Functional Location complex table18BEGRUTechnical object authorization groupnvarchar40
8/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab14BEGRUTechnical object authorization groupnvarchar40
9/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points21BEGRUTechnical object authorization groupnvarchar40
10/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab18BEGRUTechnical object authorization groupnvarchar40
11/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab21BEGRUTechnical object authorization groupnvarchar40
12BBPT_T023Material groups8BEGRUAuthorization Groupnvarchar40
13BSECOne-Time Account Data Document Segment44BEGRUAuthorization Groupnvarchar40
14CNV_20100_SKB1CNV backup copy for SKB15BEGRUAuthorization Groupnvarchar40
15CVP_BEGRUAuthorization Group indicating blocked master data5BEGRUAuthorization Groupnvarchar40
16DFKK_MA_HHeader Data of Master Agreement17BEGRUAuthorization Groupnvarchar40
17TEB037Authorization Groups3BEGRUAuthorization Groupnvarchar40
18TEB037TAuthorization Groups: Texts4BEGRUAuthorization Groupnvarchar40
19TEWA_EL_OBJBHBehavioral Control (Behavior)9BEGRUAuthorization Groupnvarchar40
20TZD0ADarwin: Customer default values per trans. type for KNA19BEGRUAuthorization Groupnvarchar40
21TZD0BDarwin: Customer default values per co.cd/trn.type for KNB19BEGRUAuthorization Groupnvarchar40
22ZEIMMARAUSING FOR STORING EIM MARA DATAS75BEGRUAuthorization Groupnvarchar40
TOPAssortment Maintenance
23TWLVListing procedure, assortments3BEGRUAuthorization to use listing procedurenvarchar40
TOPBasic Functions
24ANKAAsset classes: general data14BEGRUAuthorization Groupnvarchar40
25SKB1G/L account master (company code)4BEGRUAuthorization Groupnvarchar40
26SKM1Sample G/L accounts4BEGRUAuthorization Groupnvarchar40
TOPBilling in Contract Accounts Receivable and Payable
27DFKKBIBILLACC_HBilling Account Header24BEGRUAuthorization Groupnvarchar40
TOPBusiness Partner
28TIVBPVENDORCMPVendor Preassignment (CoCd Data)10BEGRUAuthorization Groupnvarchar40
29TIVBPVENDORGENVendor Preassignment (General Data)7BEGRUAuthorization Groupnvarchar40
TOPBusiness Partner Enhancements for Financial Services
30BP000Business Partner Master (General Data)29BEGRUAuthorization Groupnvarchar40
TOPClinical System
31N2DRAWADocument Info Record17BEGRUAuthorization Groupnvarchar40
TOPCollectionsDisbursements
32VVKKSOLLCDebit Entry - Control Records7BEGRUAuthorization Groupnvarchar40
33VVKKUMSACOpen Item Clearing - Control Records7BEGRUAuthorization Groupnvarchar40
TOPContract Accounts Receivable and Payable
34DFKKDOCFI-CA DMS: Administrative Data of Documents15BEGRUAuthorization Groupnvarchar40
35DFKKZPPayment lot: Data for payment72BEGRUAuthorization Groupnvarchar40
36DFKK_VT_HCT: Header Data of Provider Contract17BEGRUAuthorization Groupnvarchar40
37DPAYCPayment program - administrative records11BEGRUAuthorization Groupnvarchar40
38FKKCOCCVCorrespondence generation - control records8BEGRUAuthorization Groupnvarchar40
39FKKMAHNVControl records for the dunning program in FI-CA14BEGRUAuthorization Group For Parameter Maintenancenvarchar40
40FKKVKPContract Account Partner-Specific53BEGRUAuthorization Groupnvarchar40
41TFK000SPosting Locks4BEGRUAuthorization Groupnvarchar40
42TFK008Locking Reasons for Automatic Payment Transactions4BEGRUAuthorization Groupnvarchar40
43TFK020BShort Account Assignments for Transfer Postings to Cash Desk11BEGRUAuthorization Groupnvarchar40
44TFK020KShort Account Assignments for Transfer Postings13BEGRUAuthorization Groupnvarchar40
45TFK041BMaster Data Groups4BEGRUAuthorization Groupnvarchar40
46TFK047SDunning block reasons4BEGRUAuthorization Groupnvarchar40
47TFK056SBlocking Reasons for Interest Calculation4BEGRUAuthorization Groupnvarchar40
48TFK080R1Lock Reasons for Invoicing3BEGRUAuthorization Groupnvarchar40
49TFK080R2Lock Reasons for Scheduling3BEGRUAuthorization Groupnvarchar40
50TFK080R3Lock Reasons for Correspondence Dunning3BEGRUAuthorization Groupnvarchar40
51TFK090AMass Activity Types15BEGRUAuthorization Groupnvarchar40
TOPContract Billing
52EDSCDisc.Header Data16BEGRUAuthorization Groupnvarchar40
53EPREIMstr Pricing Table for All Prices20BEGRUAuthorization Groupnvarchar40
54EPRESCLPrice Adjustment Clause for All Price Categories9BEGRUAuthorization Groupnvarchar40
55ERCHBilling Doc. Data46BEGRUAuthorization Groupnvarchar40
56ERCH_SHORTHeader Data for Billing Document - Extract22BEGRUAuthorization Groupnvarchar40
57ESCHBilling Schema (Header Data)14BEGRUAuthorization Groupnvarchar40
58ETRFRate (Head. Data)20BEGRUAuthorization Groupnvarchar40
59ETTAGeneral Rate Category (Header Data)22BEGRUAuthorization Groupnvarchar40
TOPCross-Application Components
60BC490KKNA1General data in customer master24BEGRUAuthorization Groupnvarchar40
61KKNA1General Data in Customer Master24BEGRUAuthorization Groupnvarchar40
62MMARAGeneral material data75BEGRUAuthorization Groupnvarchar40
63SKNA1Customer Master table for BC417 Course24BEGRUAuthorization Groupnvarchar40
TOPCustomer Contact
64BCONTBusiness Partner Contact18BEGRUAuthorization Groupnvarchar40
65BCONTAContact Activities7BEGRUAuthorization Groupnvarchar40
66BCONTCContact Classes3BEGRUAuthorization Groupnvarchar40
TOPCustomer Master
67KNA1General Data in Customer Master24BEGRUAuthorization Groupnvarchar40
68KNVVCustomer Master Sales Data8BEGRUAuthorization Groupnvarchar40
TOPCustomer Service
69EDISCDOCDiscDoc.: Header15BEGRUAuthorization Groupnvarchar40
70EINIDATCRInit. Data Cr. Doc.: Premise - Header Data12BEGRUAuthorization Groupnvarchar40
TOPDevice Management
71EDEVGRMaster Data for Device Group8BEGRUAuthorization Groupnvarchar40
72EEAGInput/Output Group5BEGRUAuthorization Groupnvarchar40
73EGERRDevice data: Info record for point of delivery - historical36BEGRUTechnical object authorization groupnvarchar40
74EKOGCommand Group5BEGRUAuthorization Groupnvarchar40
75EZWGRegister Group5BEGRUAuthorization Groupnvarchar40
76EZWG_HEADRegister Group: Header Data5BEGRUAuthorization Groupnvarchar40
77TE271Sample Lot29BEGRUAuthorization Groupnvarchar40
TOPDocument Management System
78DRAWDocument Info Record17BEGRUAuthorization Groupnvarchar40
TOPEnergy Data Management
79EEDMSETTLDOCSettlement Document (Header)18BEGRUAuthorization Groupnvarchar40
80EEDMSETTLDOCALERSettlement Document (Alerts)23BEGRUAuthorization Groupnvarchar40
81EEDMSETTLDOCERRSettlement Document (Errors)24BEGRUAuthorization Groupnvarchar40
82EEDMSETTLDOCRUNSettlement Document (Run)11BEGRUAuthorization Groupnvarchar40
83EEDMSETTLDOCVARHVariants for Header Info of Settlement Document10BEGRUAuthorization Groupnvarchar40
84EPROFHEADProfile Header Data24BEGRUAuthorization Groupnvarchar40
85EPROFHEAD_TMPHeader Data of Temporary Profile24BEGRUAuthorization Groupnvarchar40
86ESERVPROVService provider11BEGRUAuthorization Groupnvarchar40
TOPEquipment
87EQUIEquipment master data8BEGRUTechnical object authorization groupnvarchar40
TOPExternal Services
88ASMDService Master: Basic Data15BEGRUAuthorization Groupnvarchar40
89TMP_SPECModel Service Specifications16BEGRUAuthorization Groupnvarchar40
TOPFinancial Accounting
90KNB1Customer Master (Company Code)12BEGRUAuthorization Groupnvarchar40
91LFA1Vendor Master (General Section)24BEGRUAuthorization Groupnvarchar40
92LFB1Vendor Master (Company Code)11BEGRUAuthorization Groupnvarchar40
93T053GPayment Advice Types3BEGRUAuthorization Groupnvarchar40
TOPFunctional Locations
94IFLOTFunctional Location (Table)12BEGRUTechnical object authorization groupnvarchar40
95IFLOT_VSFunctional Location (Version Table)13BEGRUTechnical object authorization groupnvarchar40
96IRLOTReference Functional Location (Table)11BEGRUTechnical object authorization groupnvarchar40
TOPFunds Management
97FMSPLIT_AUTGAuthorization groups for Rule-Based Account Distributions2BEGRUAuthorization group for PSM account assignment distributionnvarchar40
98FMSPLIT_AUTG_TAuthorization groups for Rule-Based Account Distributions3BEGRUAuthorization group for PSM account assignment distributionnvarchar40
99FMSPLIT_GROUPRule Group for Rule-Based Account Distributions3BEGRUAuthorization group for PSM account assignment distributionnvarchar40
TOPGL Account Posting
100TCJ_C_JOURNALSCash Journals12BEGRUAuthorization Groupnvarchar40
TOPInformation System
101DKKOSBalance Audit Trail59BEGRUAuthorization Groupnvarchar40
102DKOKSOpen Item Account Balance Audit Trail Master Record62BEGRUAuthorization Groupnvarchar40
TOPIntercompany Data Exchange
103EIDESWTDOCSwitch Document Header29BEGRUAuthorization Groupnvarchar40
104EIDESWTDOCTMPTemporary Switch Document Header Data30BEGRUAuthorization Groupnvarchar40
105EIDESWTMSGDATAMessage Data for Switch Document35BEGRUAuthorization Groupnvarchar40
106EIDESWTMSGTMPTemporary Switch Document Message Data37BEGRUAuthorization Groupnvarchar40
107ESERVICEPoint of delivery service19BEGRUAuthorization Groupnvarchar40
TOPInvoicing
108ERDKPrint Document/Header Data43BEGRUAuthorization Groupnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
109TFKVKPTechnical Master Data for Billing & Invoicing in FI-CA6BEGRUAuthorization Groupnvarchar40
TOPLoans Management
110TDPR_PRODUCTProduct, Master Data6BEGRUAuthorization Groupnvarchar40
111TTONFTVDARLTest neue Fima: Grunddaten und VDARL92BEGRUBerechtigungsgruppenvarchar40
112VDARLLoans78BEGRUAuthorization Groupnvarchar40
113VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)18BEGRUAuthorization Groupnvarchar40
114VDHOKOMain file header19BEGRUAuthorization Groupnvarchar40
115VDMEKOCondition Table: Header22BEGRUAuthorization Groupnvarchar40
116VDPOKOFile header19BEGRUAuthorization Groupnvarchar40
117VZFGDRelease data (Informative data for the release procedure)13BEGRUAuthorization Groupnvarchar40
TOPMaintenance Orders
118/CUM/CONMSCU: Construction Measure Master Data6BEGRUTechnical object authorization groupnvarchar40
119/CUM/CUDESIGNCU: Design Header Data8BEGRUTechnical object authorization groupnvarchar40
120/CUM/CUNITCU: Master Data7BEGRUTechnical object authorization groupnvarchar40
TOPMaintenance Program Definition
121MPDPSDMPD: MPD and MP header data12BEGRUTechnical object authorization groupnvarchar40
TOPMaintenance Task Lists
122MPLAMaintenance plan32BEGRUTechnical object authorization groupnvarchar40
TOPMaster Data
123BKK42Current Account Master Data: Operative Data14BEGRUAuthorization Groupnvarchar40
124EANLInstallation24BEGRUAuthorization Groupnvarchar40
125EKONFranchise Contract MasterData16BEGRUAuthorization Groupnvarchar40
126ELACCLoyalty Account Header13BEGRUAuthorization Groupnvarchar40
127EPROPOwner Allocation16BEGRUAuthorization Groupnvarchar40
128EREDEMPRedemption Document for Loyalty Program22BEGRUAuthorization Groupnvarchar40
129EVBSPremise16BEGRUAuthorization Groupnvarchar40
130EVERIS-U Cont.36BEGRUAuthorization Groupnvarchar40
131EWATWASTESRVPRODService Products for Waste and Recycling9BEGRUAuthorization Groupnvarchar40
132JGTGPNRIS-M: Central Business Partner Table14BEGRUAuthorization Groupnvarchar40
TOPMaterial Groups
133T023Material Groups8BEGRUAuthorization Groupnvarchar40
TOPMaterial Master
134MARAGeneral Material Data75BEGRUAuthorization Groupnvarchar40
135MARA_TMPFile for Incorrect Data in Direct Input82BEGRUAuthorization Groupnvarchar40
136MVRACross-version fields for MARA75BEGRUAuthorization Groupnvarchar40
137T134Material Types19BEGRUAuthorization group in the material masternvarchar40
138TMBGMaterial Master: Authorization Groups2BEGRUAuthorization group in the material masternvarchar40
139TMBGTMaterial Master: Descriptions for Authorization Groups3BEGRUAuthorization group in the material masternvarchar40
TOPMeasuring Points and Counters
140IMELEntry List for Measurement Documents9BEGRUTechnical object authorization groupnvarchar40
141IMPTTMeasuring Point (Table)15BEGRUTechnical object authorization groupnvarchar40
TOPMove-InOut
142EAUSMove-out Doc. for Contract Acc.35BEGRUAuthorization Groupnvarchar40
143EAUSVMove-out Doc. Contract Level25BEGRUAuthorization Groupnvarchar40
144ECAMIOPRHEADIS-U: Parked Document: Header Data13BEGRUAuthorization Groupnvarchar40
145EEINMove-in Doc. for ContAcc.38BEGRUAuthorization Groupnvarchar40
TOPNetWeaver Enterprise Search
146ESH_TST_MATES Test Object Material - Main Data7BEGRUAuthorization Groupnvarchar40
147ESH_TST_T134Test Object Material Type and Authorization Group4BEGRUAuthorization Groupnvarchar40
TOPNetwork and Activity
148MLSTMilestone104BEGRUAuthorization Groupnvarchar40
149SMLSStandard milestone74BEGRUAuthorization Groupnvarchar40
TOPNetwork Modeler
150GHO_SIM_INETObject Links for Network Simulation26BEGRUTechnical object authorization groupnvarchar40
TOPObject Networking
151INETObject networking25BEGRUTechnical object authorization groupnvarchar40
TOPPayment Transactions
152CRNUMPayment cards: Card master record23BEGRUAuthorization Groupnvarchar40
TOPPersonnel Time Management
153T559VValidity Period: Absence Quotas for Default Values10BEGRUTime/Measurement Unitnvarchar30
TOPPlant Maintenance
154T370BTechnical object authorization group2BEGRUTechnical object authorization groupnvarchar40
155T370B_TLanguage-dependent texts for authorization group3BEGRUTechnical object authorization groupnvarchar40
TOPPoint of delivery
156EUIGRIDAllocation of PoD to Grid12BEGRUAuthorization Groupnvarchar40
157EUIHEADPoD Header Data11BEGRUAuthorization Groupnvarchar40
158EUIINSTLNAllocation of Installation to PoD14BEGRUAuthorization Groupnvarchar40
159EUILNRAllocation of Logical Device to PoD12BEGRUAuthorization Groupnvarchar40
160EUILZWAllocation of Logical Register to PoD12BEGRUAuthorization Groupnvarchar40
161EUITRANSTransformation of Internal/External Point of Delivery No.13BEGRUAuthorization Groupnvarchar40
TOPPortioning and scheduling
162TE420Sch. Mast. Data: Portion50BEGRUAuthorization Groupnvarchar40
163TE422Schedule Master Data for Meter Reading Unit58BEGRUAuthorization Groupnvarchar40
TOPProduct Catalog
164TWGLVLayout Area8BEGRUAuthorization group for layout areanvarchar40
165TWICOSTOREOnline Stores3BEGRUAuthorization group for online storenvarchar40
166WWMIProduct catalog18BEGRUAuthorization group product catalognvarchar40
TOPProduct definition
167FIPR_PRODUCTProduct, Master Data10BEGRUAuthorization Groupnvarchar40
TOPProduction Allocation
168GHO_INET_LOGChange log table for INET - productive networks27BEGRUTechnical object authorization groupnvarchar40
169GHO_SIMU_INETLOGLog table for simulation changes in production network27BEGRUTechnical object authorization groupnvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
170DFMCA_BRF550BRF: Parameters for Processing Contract Account10BEGRUBRF: Expressionnvarchar200
171DFMCA_BRF570BRF: Parameters for Creating Contract Object7BEGRUBRF: Expressionnvarchar200
172DFMCA_BRF770BRF: Create Location28BEGRUBRF: Expressionnvarchar200
173DFMCA_RETURNData Table for Tax Returns20BEGRUAuthorization Groupnvarchar40
174DFMCA_RETURN_OData Table for Tax Returns23BEGRUAuthorization Groupnvarchar40
175DPSOBContract Object in Collection and Disbursement8BEGRUAuthorization Groupnvarchar40
176TFICA_DEFSamples for Contract Account Types28BEGRUAuthorization Groupnvarchar40
177TPSOB_DEFSamples for Contract Object Types5BEGRUAuthorization Groupnvarchar40
TOPReporting
178MCIPMISPMIS: Master data characteristics for PMIS before image6BEGRUPMIS: Authorization group for equipmentnvarchar40
TOPSimulation
179VSMLST_CNVersion: Milestone105BEGRUAuthorization Groupnvarchar40
TOPTreasury
180VZKNA1Collector for batch input KNA1 from RF-VV6BEGRUAuthorization Groupnvarchar40
181VZKNB1Collector for batch input KNB1 from RF-VV7BEGRUAuthorization Groupnvarchar40
TOPWarranties
182BGMKMaster Warranty Header14BEGRUAuthorization Groupnvarchar40
183BGMKOBJMaster Warranty - Object Assignment10BEGRUAuthorization Groupnvarchar40
TOPWaste Management
184EEWA_CAPAB_HEADIS-U Waste: Capacity Planning - Header16BEGRUAuthorization Groupnvarchar40
185EEWA_GUARANTORGuarantor Contract16BEGRUAuthorization Groupnvarchar40
186EEWA_ROBCleaning Object39BEGRUAuthorization Groupnvarchar40
187EWACALENDERDefinition of General Non-Workdays10BEGRUAuthorization Groupnvarchar40
188EWAEHSGPBusiness Partner Integration Table EHS/ IS-W10BEGRUAuthorization Groupnvarchar40
189EWAEQUIIS-U WA: Additional Data for Equipment Master35BEGRUAuthorization Groupnvarchar40
190EWAOBJHeader Data for Service Frequency48BEGRUAuthorization Groupnvarchar40
191EWAROUTEHeader table of route73BEGRUAuthorization Groupnvarchar40
192EWATDEVLOCProvisional Container/Container Location Allocation19BEGRUAuthorization Groupnvarchar40
193EWA_BILL_RELEVNTValuation of Fields Relevant for Billing in Waste Bill.Cat.36BEGRUAuthorization Groupnvarchar40
194EWA_EL_WDPLANTWaste Disposal Facility26BEGRUAuthorization Groupnvarchar40
195EWA_EL_WDPPROCTransaction Within Facility20BEGRUAuthorization Groupnvarchar40
196EWA_EL_WDPPROGRTransaction Group9BEGRUAuthorization Groupnvarchar40
197EWA_EL_WDPPROTETransaction Template11BEGRUAuthorization Groupnvarchar40
198EWA_EL_WDPPROTYProcedure Category15BEGRUAuthorization Groupnvarchar40
199EWA_FAKTORFactors for Billing of Waste Management Services11BEGRUAuthorization Groupnvarchar40
200EWA_OBJADDRESSObject Address14BEGRUAuthorization Groupnvarchar40
201EWA_ORDER_HEADHeader Table for Waste Disposal Order55BEGRUAuthorization Groupnvarchar40
202EWA_SERVADDRESSService Address15BEGRUAuthorization Groupnvarchar40
203EWA_VBSTable Supplement for Premise with Historical Data12BEGRUAuthorization Groupnvarchar40
204EWA_WA_WEIGHOFFLOffline Weighing89BEGRUAuthorization Groupnvarchar40
205TEWA_EL_OBJTRAObject Transaction Configuration (CL_EEWA_TRANSACTION)8BEGRUAuthorization Groupnvarchar40
206TEWA_EL_OBJTRAMObject Transaction Configuration (Overriding Clients)9BEGRUAuthorization Groupnvarchar40
TOPWork Clearance Management
207WCAAPWCM: Application16BEGRUTechnical object authorization groupnvarchar40
208WCAHEWCM: Work Clearance Document (Header)17BEGRUTechnical object authorization groupnvarchar40
209WCAJWCM: Lineup11BEGRUAuthorization Group in Work Clearance Managementnvarchar40
210WCAWWCM: Work Approval15BEGRUTechnical object authorization groupnvarchar40