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

145 columns | Print definition?ERP 6.0  | LOEVM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_KTO_PRPRBD Account. Master Data16LOEVMRBD: Deletion Flagnvarchar10
2CNV_20100_CSKBBackup copy - CSKB19LOEVMnvarchar10
3CNV_20800_KNVKCNV backup copy: Customer master contact person72LOEVMCentral Deletion Flag for Master Recordnvarchar10
4DFKK_MA_HHeader Data of Master Agreement11LOEVMFlag Master Agreement for Deletionnvarchar10
5PEG_TASS_HIST_DPegging History: Detail21LOEVMDeletion Indicatornvarchar10
6PEG_TXPT_HISTPegging: intransit stock history13LOEVMDeletion Indicatornvarchar10
7TEWA_EL_OBJBHBehavioral Control (Behavior)10LOEVMDeletion Indicatornvarchar10
TOPAdvertising Management
8JJCPFREESUBIS-M: Free Subscription - Contact Person Relationship14LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
9JJCPRESPONSIBIS-M: Responsibility in Contact Person Relationship15LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
10JJTAFIS-M/AM: Free Subscription for Media Contact Person14LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
11JJTAMIS-M/AM: Media Contact Person4LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
12JJTAZIS-M/AM: Media Contact Person Responsibility15LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
13JJTDIENIS-M/AM: Service8LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
14JJTPEIS-M/AM: Production Units19LOEVMDeletion Indicatornvarchar10
TOPBalancing
15OIUBL01_PBAProduct Balancing Agreement15LOEVMCentral Deletion Flag for Master Recordnvarchar10
TOPBank
16BNKABank master record13LOEVMDeletion Indicatornvarchar10
TOPBusiness Partner
17TIVBPVENDORCMPVendor Preassignment (CoCd Data)7LOEVMDeletion Flag for Master Record (Company Code Level)nvarchar10
18TIVBPVENDORGENVendor Preassignment (General Data)20LOEVMCentral Deletion Flag for Master Recordnvarchar10
TOPContract Accounts Receivable and Payable
19DFKKCIBW_STATCIBW Extraction - Status Table8LOEVMMark Results for Deletionnvarchar10
20DFKKOPBW_STATOIBW Extraction - Status Table7LOEVMMark Results for Deletionnvarchar10
21DFKK_VT_HCT: Header Data of Provider Contract7LOEVMFlag Provider Contract for Deletionnvarchar10
22FKKVKContract Account Header5LOEVMMark Contract Account for Deletionnvarchar10
23FKKVKPContract Account Partner-Specific36LOEVMMark Contract Account for Deletionnvarchar10
TOPContract Billing
24EDSCDisc.Header Data17LOEVMDeletion Indicatornvarchar10
25EPREIMstr Pricing Table for All Prices21LOEVMDeletion Indicatornvarchar10
26EPRESCLPrice Adjustment Clause for All Price Categories10LOEVMDeletion Indicatornvarchar10
27ERCHBilling Doc. Data47LOEVMDeletion Indicatornvarchar10
28ESCHBilling Schema (Header Data)15LOEVMDeletion Indicatornvarchar10
29ETRFRate (Head. Data)21LOEVMDeletion Indicatornvarchar10
30ETTAGeneral Rate Category (Header Data)23LOEVMDeletion Indicatornvarchar10
TOPControlling
31CSKBCost Elements (Data Dependent on Controlling Area)18LOEVMIndicator: Cost element is flagged for deletionnvarchar10
TOPCross-Application Components
32ALM_ME_SYNC_ARCHMAM 1.0 Obsolete26LOEVMnvarchar10
33BC490KKNA1General data in customer master41LOEVMCentral Deletion Flag for Master Recordnvarchar10
34KKNA1General Data in Customer Master41LOEVMCentral Deletion Flag for Master Recordnvarchar10
35SKNA1Customer Master table for BC417 Course41LOEVMCentral Deletion Flag for Master Recordnvarchar10
36SKNVKCustomer Master Contact table for BC417 Course71LOEVMCentral Deletion Flag for Master Recordnvarchar10
TOPCustomer Contact
37BCONTBusiness Partner Contact19LOEVMDeletion Indicatornvarchar10
TOPCustomer Master
38KNA1General Data in Customer Master41LOEVMCentral Deletion Flag for Master Recordnvarchar10
39KNVKCustomer Master Contact Partner71LOEVMCentral Deletion Flag for Master Recordnvarchar10
40KNVVCustomer Master Sales Data9LOEVMDeletion flag for customer (sales level)nvarchar10
TOPCustomer Service
41EDISCDOCDiscDoc.: Header16LOEVMDeletion Indicatornvarchar10
42EINIDATCRInit. Data Cr. Doc.: Premise - Header Data13LOEVMDeletion Indicatornvarchar10
TOPDevice Management
43EDEVGRMaster Data for Device Group9LOEVMDeletion Indicatornvarchar10
44TE271Sample Lot30LOEVMDeletion Indicatornvarchar10
TOPDSD Connector
45/DSD/ME_CUST_SADSD CN: Sales area dependent customer master data15LOEVMDeletion flag for customer (sales level)nvarchar10
TOPEnergy Data Management
46EEDMSETTLDOCSettlement Document (Header)19LOEVMDeletion Indicatornvarchar10
47EEDMSETTLDOCALERSettlement Document (Alerts)24LOEVMDeletion Indicatornvarchar10
48EEDMSETTLDOCERRSettlement Document (Errors)25LOEVMDeletion Indicatornvarchar10
49EEDMSETTLDOCRUNSettlement Document (Run)12LOEVMDeletion Indicatornvarchar10
50EEDMSETTLDOCVARHVariants for Header Info of Settlement Document11LOEVMDeletion Indicatornvarchar10
51EPROFHEADProfile Header Data25LOEVMDeletion Indicatornvarchar10
52EPROFHEAD_TMPHeader Data of Temporary Profile25LOEVMDeletion Indicatornvarchar10
53ESERVPROVService provider12LOEVMDeletion Indicatornvarchar10
TOPFinancial Accounting
54KNB1Customer Master (Company Code)8LOEVMDeletion Flag for Master Record (Company Code Level)nvarchar10
55LFA1Vendor Master (General Section)37LOEVMCentral Deletion Flag for Master Recordnvarchar10
56LFB1Vendor Master (Company Code)8LOEVMDeletion Flag for Master Record (Company Code Level)nvarchar10
TOPFunds Management
57FMFPOFIFM: Commitment Item12LOEVMCommitment item is flagged for deletion (indicator)nvarchar10
TOPIntegration Customer Relationship Management
58ECRM_REPL_HDHeader Data for IS-U Sales Replication Error Handling20LOEVMDeletion Indicatornvarchar10
TOPIntercompany Data Exchange
59EIDESWTDOCSwitch Document Header30LOEVMDeletion Indicatornvarchar10
60EIDESWTDOCTMPTemporary Switch Document Header Data31LOEVMDeletion Indicatornvarchar10
61EIDESWTMSGDATAMessage Data for Switch Document36LOEVMDeletion Indicatornvarchar10
62EIDESWTMSGTMPTemporary Switch Document Message Data38LOEVMDeletion Indicatornvarchar10
63ESERVICEPoint of delivery service20LOEVMDeletion Indicatornvarchar10
TOPInvoicing
64ERDKPrint Document/Header Data44LOEVMDeletion Indicatornvarchar10
TOPMaintenance Processing
65ALM_ME_SYNCSync Status26LOEVMDeletion Indicatornvarchar10
TOPMaster Data
66EANLInstallation25LOEVMDeletion Indicatornvarchar10
67EKONFranchise Contract MasterData17LOEVMDeletion Indicatornvarchar10
68ELACCLoyalty Account Header14LOEVMDeletion Indicatornvarchar10
69EPROPOwner Allocation17LOEVMDeletion Indicatornvarchar10
70EREDEMPRedemption Document for Loyalty Program23LOEVMDeletion Indicatornvarchar10
71EVBSPremise17LOEVMDeletion Indicatornvarchar10
72EVERIS-U Cont.37LOEVMDeletion Indicatornvarchar10
73EVERHIS-U Contract History16LOEVMDeletion Indicatornvarchar10
74EWATWASTESRVPRODService Products for Waste and Recycling10LOEVMDeletion Indicatornvarchar10
TOPMaterials Management
75/ISDFPS/EQUITRPAssignment: Storage Bin --> Equipment (Loading Object)8LOEVMDeletion Indicatornvarchar10
TOPMove-InOut
76EAUSMove-out Doc. for Contract Acc.36LOEVMDeletion Indicatornvarchar10
77EAUSVMove-out Doc. Contract Level26LOEVMDeletion Indicatornvarchar10
78ECAMIOPRHEADIS-U: Parked Document: Header Data14LOEVMDeletion Indicatornvarchar10
79EEINMove-in Doc. for ContAcc.39LOEVMDeletion Indicatornvarchar10
TOPOperative Structures
80PROJProject definition59LOEVMDeletion Indicatornvarchar10
81PRPSWBS (Work Breakdown Structure) Element Master Data79LOEVMDeletion Indicatornvarchar10
TOPPegging, Grouping, and Distribution
82DIS_TOBJSDistribution: cost objects posted to per group21LOEVMDeletion Indicatornvarchar10
83DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)19LOEVMDeletion Indicatornvarchar10
84DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)19LOEVMDeletion Indicatornvarchar10
85DIS_TOBJS_FMSUDistribution: Objects distributed to per Group WBS (Cash)16LOEVMDeletion Indicatornvarchar10
86PEG_STOPegging: Record of goods movements w.r.t STO's13LOEVMDeletion Indicatornvarchar10
87PEG_TACTASSPegging: Current Assignments Based on Goods Movements17LOEVMDeletion Indicatornvarchar10
88PEG_TASSPegging: Assignment Replenishment Element to WBS Elements20LOEVMDeletion Indicatornvarchar10
89PEG_TASS_TMPGrp-to-Grp Transf. Pegging: Assign. of Replen to WBS Elems.20LOEVMDeletion Indicatornvarchar10
90PEG_TASS_WLSTTemp. assignments for sub-components of grp to grp transfers15LOEVMDeletion Indicatornvarchar10
91PEG_TGTGPegging: Record of group to group transfers12LOEVMDeletion Indicatornvarchar10
92PEG_TGTG_EXCA&D GPD: Group to group initial peg15LOEVMDeletion Indicatornvarchar10
93PEG_TSTKPegging: Stock table16LOEVMDeletion Indicatornvarchar10
94PEG_TSTK_TRANSPegging: Stock transfered without costs (Excess)16LOEVMDeletion Indicatornvarchar10
95PEG_TXPTPegging: Record of intransit stock in cross plant transfers13LOEVMDeletion Indicatornvarchar10
TOPPeriodical Sales and Distribution
96JDTPVAIS-M/SD: Editions47LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
97JDTVAUSGBIS-M/SD: Issues53LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
98JKTGUIS-M/SD: Coupon Booklet9LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
99JMTMATIS-M/SD: Promotional Material13LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
100JNTRECHIS-M/SD: Research22LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
101JRTBEABSTIS-M/SD: Unloading Point23LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
102JRTROUTEIS-M/SD: Truck Route Master Data51LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
103JRTRVERTIS-M/SD: Truck Route Contract15LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
104JRTTROUTEIS-M/SD: Daily Truck Routes77LOEVMDeletion Flag for Master Data in Media Sales & Distributionnvarchar10
TOPPoint of delivery
105EUIGRIDAllocation of PoD to Grid13LOEVMDeletion Indicatornvarchar10
106EUIHEADPoD Header Data12LOEVMDeletion Indicatornvarchar10
107EUIINSTLNAllocation of Installation to PoD15LOEVMDeletion Indicatornvarchar10
108EUILNRAllocation of Logical Device to PoD13LOEVMDeletion Indicatornvarchar10
109EUILZWAllocation of Logical Register to PoD13LOEVMDeletion Indicatornvarchar10
110EUITRANSTransformation of Internal/External Point of Delivery No.14LOEVMDeletion Indicatornvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
111TFICA_DEFSamples for Contract Account Types17LOEVMMark Contract Account for Deletionnvarchar10
TOPSimulation
112VSPROJ_CNVersion: Project definition60LOEVMDeletion Indicatornvarchar10
113VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data80LOEVMDeletion Indicatornvarchar10
TOPTemplates
114PROJSStandard project definition59LOEVMDeletion Indicatornvarchar10
115PRPSSStandard WBS Element (WBS element) - Master Data79LOEVMDeletion Indicatornvarchar10
TOPTreasury
116VWPANLAAsset master for securities15LOEVMDeletion Indicatornvarchar10
117VZKNA1Collector for batch input KNA1 from RF-VV45LOEVMCentral Deletion Flag for Master Recordnvarchar10
118VZKNB1Collector for batch input KNB1 from RF-VV41LOEVMDeletion Flag for Master Record (Company Code Level)nvarchar10
TOPValue Adjustment
119/IBS/TRB_KTORBD Account. Master Data16LOEVMRBD: Deletion Flagnvarchar10
TOPVendor Master
120LFM1Vendor master record purchasing organization data7LOEVMDelete flag for vendor at purchasing levelnvarchar10
121LFM2Vendor Master Record: Purchasing Data9LOEVMDelete flag for vendor at purchasing levelnvarchar10
122WYT4Operative Control6LOEVMDeletion Indicatornvarchar10
TOPWaste Management
123EEWA_CAPAB_HEADIS-U Waste: Capacity Planning - Header17LOEVMDeletion Indicatornvarchar10
124EEWA_GUARANTORGuarantor Contract17LOEVMDeletion Indicatornvarchar10
125EEWA_ROBCleaning Object40LOEVMDeletion Indicatornvarchar10
126EWACALENDERDefinition of General Non-Workdays11LOEVMDeletion Indicatornvarchar10
127EWAEHSGPBusiness Partner Integration Table EHS/ IS-W11LOEVMDeletion Indicatornvarchar10
128EWAEQUIIS-U WA: Additional Data for Equipment Master36LOEVMDeletion Indicatornvarchar10
129EWAOBJHeader Data for Service Frequency49LOEVMDeletion Indicatornvarchar10
130EWAROUTEHeader table of route74LOEVMDeletion Indicatornvarchar10
131EWATDEVLOCProvisional Container/Container Location Allocation20LOEVMDeletion Indicatornvarchar10
132EWA_BILL_RELEVNTValuation of Fields Relevant for Billing in Waste Bill.Cat.37LOEVMDeletion Indicatornvarchar10
133EWA_EL_WDPLANTWaste Disposal Facility27LOEVMDeletion Indicatornvarchar10
134EWA_EL_WDPPROCTransaction Within Facility21LOEVMDeletion Indicatornvarchar10
135EWA_EL_WDPPROGRTransaction Group10LOEVMDeletion Indicatornvarchar10
136EWA_EL_WDPPROTETransaction Template12LOEVMDeletion Indicatornvarchar10
137EWA_EL_WDPPROTYProcedure Category16LOEVMDeletion Indicatornvarchar10
138EWA_FAKTORFactors for Billing of Waste Management Services12LOEVMDeletion Indicatornvarchar10
139EWA_OBJADDRESSObject Address15LOEVMDeletion Indicatornvarchar10
140EWA_ORDER_HEADHeader Table for Waste Disposal Order56LOEVMDeletion Indicatornvarchar10
141EWA_SERVADDRESSService Address16LOEVMDeletion Indicatornvarchar10
142EWA_VBSTable Supplement for Premise with Historical Data13LOEVMDeletion Indicatornvarchar10
143EWA_WA_WEIGHOFFLOffline Weighing90LOEVMDeletion Indicatornvarchar10
144TEWA_EL_OBJTRAObject Transaction Configuration (CL_EEWA_TRANSACTION)9LOEVMDeletion Indicatornvarchar10
145TEWA_EL_OBJTRAMObject Transaction Configuration (Overriding Clients)10LOEVMDeletion Indicatornvarchar10