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

Home | ERP 6.0  | P01EE_DBMU
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Payroll :: Germany :: Net :: Social Insurance
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0P01EE_DBMU431Data Module DBMU Remuneration Statement Maternity AllowanceSocial Insurance
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, GUID, SFBEG, BVBEG, LBTAGMU, BVENDAM, BVENDZUM, BVGRD, TEILWAE, NETWEEL, ZAHLART, FEHLZT, AEUEB, AEFEST, BEGZR1, ENDZR1, BEZAZ1, MASTD1, AZUNENT1, AZENT1, NETTO1, BEGZR2, ENDZR2, BEZAZ2, MASTD2, AZUNENT2, AZENT2, NETTO2, BEGZR3, ENDZR3, BEZAZ3, MASTD3, AZUNENT3, AZENT3, NETTO3, AZWOECH, ABM, AZUNENTTAGE1, AZENTSCHTAGE1, AZUNENTTAGE2, AZENTSCHTAGE2, AZUNENTTAGE3, AZENTSCHTAGE3 FROM P01EE_DBMU
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUIDUnique Key for Identification of Notificationnvarchar320CHAR(N' ')NoP01_SVGUID Allow NULL? 
3SFBEGStart of Protection Periodnvarchar80DATS(N'00000000')YesP01_SV_EE_SFBEG Allow NULL? 
4BVBEGStart of the Employment Relationshipnvarchar80DATS(N'00000000')YesP01_SV_EE_BVBEG Allow NULL? 
5LBTAGMULast Paid Day Before Deliverynvarchar80DATS(N'00000000')YesP01_SV_EE_LBTAGMU Allow NULL? 
6BVENDAMEnd of Employment Relationship Was Announced Onnvarchar80DATS(N'00000000')YesP01_SV_EE_BVENDAM Allow NULL? 
7BVENDZUMEnd of Employment Relationship Onnvarchar80DATS(N'00000000')YesP01_SV_EE_BVENDZUM Allow NULL? 
8BVGRDReason for End of Employment Relationshipnvarchar20CHAR(N' ')YesP01_SV_EE_BVGRD Allow NULL? 
9TEILWAEContinued Payment of Remunerationnvarchar80DATS(N'00000000')YesP01_SV_EE_TEILWAE Allow NULL? 
10NETWEELNet Remuneration During Payment of Maternity Paynvarchar80NUMC(N'00000000')YesP01_SV_EE_NETWEEL Allow NULL? 
11ZAHLARTPayment Typechar10NUMC(N'0')YesP01_SV_EE_ZAHLART Allow NULL? 
12FEHLZTAbsence Time Before Protection Period/Term. of Work. Rel.nvarchar20NUMC(N'00')YesP01_SV_EE_FEHLZT Allow NULL? 
13AEUEBNet Remuneration for Last 3 Months Exceedschar10CHAR(N' ')YesP01_SV_EE_AEUEB Allow NULL? 
14AEFESTMonthly Salary/Fixed Monthly Remunerationchar10CHAR(N' ')YesP01_SV_EE_AEFEST Allow NULL? 
15BEGZR1Period 1 Startnvarchar80DATS(N'00000000')YesP01_SV_EE_BEGZR1 Allow NULL? 
16ENDZR1Period 1 Endnvarchar80DATS(N'00000000')YesP01_SV_EE_ENDZR1 Allow NULL? 
17BEZAZ1Paid Working Hours Month 1nvarchar50NUMC(N'00000')YesP01_SV_EE_BEZAZ1 Allow NULL? 
18MASTD1Of Which Paid Overtime Hours in Month 1nvarchar50NUMC(N'00000')YesP01_SV_EE_MASTD1 Allow NULL? 
19AZUNENT1Unpaid Working Hours (Not Excused) for Month 1nvarchar50NUMC(N'00000')YesP01_SV_EE_AZUNENT1 Allow NULL? 
20AZENT1Unpaid Working Hours Excused for Month 1nvarchar50NUMC(N'00000')YesP01_SV_EE_AZENT1 Allow NULL? 
21NETTO1Net Remuneration Month 1nvarchar80NUMC(N'00000000')YesP01_SV_EE_NETTO1 Allow NULL? 
22BEGZR2Period 2 Startnvarchar80DATS(N'00000000')YesP01_SV_EE_BEGZR2 Allow NULL? 
23ENDZR2Period 2 Endnvarchar80DATS(N'00000000')YesP01_SV_EE_ENDZR2 Allow NULL? 
24BEZAZ2Paid Working Hours Month 2nvarchar50NUMC(N'00000')YesP01_SV_EE_BEZAZ2 Allow NULL? 
25MASTD2Of Which Paid Overtime Hours in Month 2nvarchar50NUMC(N'00000')YesP01_SV_EE_MASTD2 Allow NULL? 
26AZUNENT2Unpaid Working Hours (Not Excused) for Month 2nvarchar50NUMC(N'00000')YesP01_SV_EE_AZUNENT2 Allow NULL? 
27AZENT2Unpaid Working Hours Excused for Month 2nvarchar50NUMC(N'00000')YesP01_SV_EE_AZENT2 Allow NULL? 
28NETTO2Net Remuneration Month 2nvarchar80NUMC(N'00000000')YesP01_SV_EE_NETTO2 Allow NULL? 
29BEGZR3Period 3 Startnvarchar80DATS(N'00000000')YesP01_SV_EE_BEGZR3 Allow NULL? 
30ENDZR3Period 3 Endnvarchar80DATS(N'00000000')YesP01_SV_EE_ENDZR3 Allow NULL? 
31BEZAZ3Paid Working Hours Month 3nvarchar50NUMC(N'00000')YesP01_SV_EE_BEZAZ3 Allow NULL? 
32MASTD3Of Which Paid Overtime Hours in Month 3nvarchar50NUMC(N'00000')YesP01_SV_EE_MASTD3 Allow NULL? 
33AZUNENT3Unpaid Working Hours (Not Excused) for Month 3nvarchar50NUMC(N'00000')YesP01_SV_EE_AZUNENT3 Allow NULL? 
34AZENT3Unpaid Working Hours Excused for Month 3nvarchar50NUMC(N'00000')YesP01_SV_EE_AZENT3 Allow NULL? 
35NETTO3Net Remuneration Month 3nvarchar80NUMC(N'00000000')YesP01_SV_EE_NETTO3 Allow NULL? 
36AZWOECHRegular Weekly Working Timenvarchar40NUMC(N'0000')YesP01_SV_EE_AZWOECH Allow NULL? 
37ABMJob-Creating Measurechar10CHAR(N' ')YesP01_SV_EE_ABM Allow NULL? 
38AZUNENTTAGE1Unpaid Working Days Not Excused Month 1nvarchar20NUMC(N'00')YesP01_SV_EE_AZUNENTTG1 Allow NULL? 
39AZENTSCHTAGE1Unpaid Working Days Excused Month 1nvarchar20NUMC(N'00')YesP01_SV_EE_AZENTTG1 Allow NULL? 
40AZUNENTTAGE2Unpaid Working Days Not Excused Month 2nvarchar20NUMC(N'00')YesP01_SV_EE_AZUNENTTG2 Allow NULL? 
41AZENTSCHTAGE2Unpaid Working Days Excused Month 2nvarchar20NUMC(N'00')YesP01_SV_EE_AZENTTG2 Allow NULL? 
42AZUNENTTAGE3Unpaid Working Days Not Excused Month 3nvarchar20NUMC(N'00')YesP01_SV_EE_AZUNENTTG3 Allow NULL? 
43AZENTSCHTAGE3Unpaid Working Days Excused Month 3nvarchar20NUMC(N'00')YesP01_SV_EE_AZENTTG3 Allow NULL? 
NamePrimaryUniqueTypeColumns
P01EE_DBMU~0YesYesCLUSTEREDGUID, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy