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  | P01EA_MELD
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
Payroll :: Germany :: Net :: Social Insurance
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0P01EA_MELD1031Data Record and Data Modules for the Reimbursement ProcessSocial Insurance
SQL:  selectupdate insert create

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

SELECT MANDT, GUID, DSER_VF, DSER_BBNRAB, DSER_BBNREP, DSER_VERNR, DSER_ED, DSER_FEKZ, DSER_FEAN, DSER_VSNR, DSER_GEBDA, DSER_BBNRVU, DSER_AZVU, DSER_DSID, DSER_BBNRKK, DSER_AZKK, DSER_BBNRAS, DSER_GD, DSER_BESCH, DSER_ARTVERS, DSER_GE, DSER_MMAU, DSER_MMBT, DSER_MMZU, DSER_MMBV, DSER_MMNA, DSER_MMAN, DBAU_KENNZV, DBAU_EABEG, DBAU_EAEND, DBAU_ARTAB, DBAU_EG, DBAU_ARTEG, DBAU_HOEBBG, DBAU_AUSFALLZ, DBAU_ARTAUSF, DBAU_AZWOECH, DBAU_AZTGL, DBAU_FBRUTAU, DBAU_FAGANT, DBAU_ESATZ, DBAU_EBU, DBAU_URAU, DBAU_AUTG, DBAU_AZSTD, DBAU_LAT, DBBT_KENNZV, DBBT_EABEG, DBBT_EAEND, DBBT_ARTAB, DBBT_LETZTAT, DBBT_FBRUTAU, DBBT_FAGANT, DBBT_ESATZ, DBBT_EBU, DBBT_ARTBV, DBZU_KENNZV, DBZU_EABEG, DBZU_EAEND, DBZU_ARTAB, DBZU_SFBEG, DBZU_SFEND, DBZU_BRUTMON, DBZU_NETTG, DBZU_NETMON, DBZU_ZUMUG, DBZU_NETAAG, DBBV_UEBVER, DBBV_VERMO, DBBV_KTO, DBBV_BLZ, DBBV_IBAN, DBBV_BIC, DBBV_KTOIN, DBBV_VZWECK, DBNA_FMNA, DBNA_VONA, DBNA_VOSA, DBNA_NAZU, DBNA_TITEL, DBAN_LDKZ, DBAN_PLZ, DBAN_ORT, DBAN_STR, DBAN_NR, DBAN_ADRZU, DBAA_ANRAA, DBAA_NAMEAA, DBAA_TELAA, DBAA_FAXAA, DBAA_EMAILAA, DBAA_NAME1BETR, DBAA_NAME2BETR, DBAA_NAME3BETR, DBAA_PLZBETR, DBAA_ORTBETR, DBAA_STRBETR, DBAA_NRBETR, DSER_APRO, DSER_MMAA, DBAU_ABTG, DBBT_MUTEN, DBZU_MUTEN FROM P01EA_MELD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GUIDUnique Key for Identification of Notificationnvarchar320CHAR(N' ')NoP01EA_STATP01_SVGUID Allow NULL? 
3DSER_VFProcedure Feature of Data Recordnvarchar50CHAR(N' ')YesP01_EAVF Allow NULL? 
4DSER_BBNRABCompany Number of Sendernvarchar150CHAR(N' ')YesP01_BBNRAB Allow NULL? 
5DSER_BBNREPCompany Number of Recipientnvarchar150CHAR(N' ')YesP01_BBNREP Allow NULL? 
6DSER_VERNRVersion Number of Data Recordnvarchar20NUMC(N'00')YesP01_VERNR Allow NULL? 
7DSER_EDCreation Date and Time of the Data Recordnvarchar200NUMC(N'00000000000000000000')YesP01_ED Allow NULL? 
8DSER_FEKZIndicator for Data Records with Errorschar10NUMC(N'0')YesP01_BVFEKZ Allow NULL? 
9DSER_FEANNumber of Errors in Data Recordchar10NUMC(N'0')YesP01_FEAN Allow NULL? 
10DSER_VSNRPension Insurance Numbernvarchar120CHAR(N' ')YesRVNUM Allow NULL? 
11DSER_GEBDABirth Date of Insured Personnvarchar80NUMC(N'00000000')YesP01_EAGEBDA Allow NULL? 
12DSER_BBNRVUCompany Number of Notifying Employernvarchar150CHAR(N' ')YesP01_EABBNRVU Allow NULL? 
13DSER_AZVUCase Number of Employernvarchar200CHAR(N' ')YesP01_BVAZVU Allow NULL? 
14DSER_DSIDIdentification Number of the Data Recordnvarchar200CHAR(N' ')YesP01_DSID Allow NULL? 
15DSER_BBNRKKCompany Number of Health Insurance Fundnvarchar150CHAR(N' ')YesP01_BBNRKK Allow NULL? 
16DSER_AZKKHealth Insurer Referencenvarchar200CHAR(N' ')YesD3AZKK Allow NULL? 
17DSER_BBNRASCompany Number of Accounting Officenvarchar150CHAR(N' ')YesP01_BBNRAS Allow NULL? 
18DSER_GDReason for Issue in Data Record DSERnvarchar20NUMC(N'00')YesP01_DSERGD Allow NULL? 
19DSER_BESCHEmployed fromnvarchar80DATS(N'00000000')YesP01_BESCH Allow NULL? 
20DSER_ARTVERSType of Insurance in the Data Record DSERchar10NUMC(N'0')YesP01_DSERAV Allow NULL? 
21DSER_GEGenderchar10CHAR(N' ')YesP01_EAGE Allow NULL? 
22DSER_MMAUData Module DBAU Availablechar10CHAR(N' ')YesP01_EAMMAU Allow NULL? 
23DSER_MMBTData Module DBBT Availablechar10CHAR(N' ')YesP01_EAMMBT Allow NULL? 
24DSER_MMZUData Module DBZU Availablechar10CHAR(N' ')YesP01_EAMMZU Allow NULL? 
25DSER_MMBVData Module DBBV Availablechar10CHAR(N' ')YesP01_EAMMBV Allow NULL? 
26DSER_MMNAData Module DBNA Availablechar10CHAR(N' ')YesP01_EAMMNA Allow NULL? 
27DSER_MMANData Module DBAN Availablechar10CHAR(N' ')YesP01_EAMMAN Allow NULL? 
28DBAU_KENNZVProcessing Indicatorchar10NUMC(N'0')YesP01_EAKENNZ Allow NULL? 
29DBAU_EABEGStart of the Reimbursement Periodnvarchar80DATS(N'00000000')YesP01_EABEG Allow NULL? 
30DBAU_EAENDEnd of Reimbursement Periodnvarchar80DATS(N'00000000')YesP01_EAEND Allow NULL? 
31DBAU_ARTABType of Payrollchar10NUMC(N'0')YesP01_EAAAB Allow NULL? 
32DBAU_EGRemunerationnvarchar90NUMC(N'000000000')YesP01_EAEG Allow NULL? 
33DBAU_ARTEGType of Remuneration in DBAUchar10NUMC(N'0')YesP01_DBAUAE Allow NULL? 
34DBAU_HOEBBGUse of the Miners' Insurance Income Thresholdchar10CHAR(N' ')YesP01_EAHOEBBG Allow NULL? 
35DBAU_AUSFALLZDowntimenvarchar50NUMC(N'00000')YesP01_EAAUSF Allow NULL? 
36DBAU_ARTAUSFType of Downtimechar10NUMC(N'0')YesP01_DBAUAA Allow NULL? 
37DBAU_AZWOECHWeekly Working Timenvarchar40NUMC(N'0000')YesP01_EAAZWOE Allow NULL? 
38DBAU_AZTGLDaily Working Timenvarchar40NUMC(N'0000')YesP01_EAAZTGL Allow NULL? 
39DBAU_FBRUTAUContinued Pay Gross Remunerationnvarchar90NUMC(N'000000000')YesP01_EAFBRUT Allow NULL? 
40DBAU_FAGANTContinued Pay Employer Contributionsnvarchar90NUMC(N'000000000')YesP01_EAAGANT Allow NULL? 
41DBAU_ESATZPercentage of the Reimbursementnvarchar50NUMC(N'00000')YesP01_EAESATZ Allow NULL? 
42DBAU_EBUReimbursement Amountnvarchar90NUMC(N'000000000')YesP01_EAERSTBT Allow NULL? 
43DBAU_URAUCause of the Work Incapacitychar10NUMC(N'0')YesP01_DBAUUA Allow NULL? 
44DBAU_AUTGWorked on the First Day of Work Incapacitychar10CHAR(N' ')YesP01_EAAUTG Allow NULL? 
45DBAU_AZSTDNumber of Hours Worked on the First Day of Work Incapacitynvarchar40NUMC(N'0000')YesP01_EAAZSTD Allow NULL? 
46DBAU_LATLast Working Daynvarchar80DATS(N'00000000')YesP01_EALAT Allow NULL? 
47DBBT_KENNZVProcessing Indicatorchar10NUMC(N'0')YesP01_EAKENNZ Allow NULL? 
48DBBT_EABEGStart of the Reimbursement Periodnvarchar80DATS(N'00000000')YesP01_EABEG Allow NULL? 
49DBBT_EAENDEnd of Reimbursement Periodnvarchar80DATS(N'00000000')YesP01_EAEND Allow NULL? 
50DBBT_ARTABType of Payrollchar10NUMC(N'0')YesP01_EAAAB Allow NULL? 
51DBBT_LETZTATLast Working Daynvarchar80DATS(N'00000000')YesP01_EALAT Allow NULL? 
52DBBT_FBRUTAUContinued Pay Gross Remunerationnvarchar90NUMC(N'000000000')YesP01_EAFBRUT Allow NULL? 
53DBBT_FAGANTContinued Pay Employer Contributionsnvarchar90NUMC(N'000000000')YesP01_EAAGANT Allow NULL? 
54DBBT_ESATZPercentage of the Reimbursementnvarchar50NUMC(N'00000')YesP01_EAESATZ Allow NULL? 
55DBBT_EBUReimbursement Amountnvarchar90NUMC(N'000000000')YesP01_EAERSTBT Allow NULL? 
56DBBT_ARTBVType of Prohibition of Employmentchar10NUMC(N'0')YesP01_EAARTBV Allow NULL? 
57DBZU_KENNZVProcessing Indicatorchar10NUMC(N'0')YesP01_EAKENNZ Allow NULL? 
58DBZU_EABEGStart of the Reimbursement Periodnvarchar80DATS(N'00000000')YesP01_EABEG Allow NULL? 
59DBZU_EAENDEnd of Reimbursement Periodnvarchar80DATS(N'00000000')YesP01_EAEND Allow NULL? 
60DBZU_ARTABType of Payrollchar10NUMC(N'0')YesP01_EAAAB Allow NULL? 
61DBZU_SFBEGStart of Protection Periodnvarchar80DATS(N'00000000')YesP01_EASFBEG Allow NULL? 
62DBZU_SFENDEnd of Protection Periodnvarchar80DATS(N'00000000')YesP01_EASFEND Allow NULL? 
63DBZU_BRUTMONAmount of the Monthly Gross Remunerationnvarchar90NUMC(N'000000000')YesP01_EABRUMO Allow NULL? 
64DBZU_NETTGCalendar Daily Net Remunerationnvarchar90NUMC(N'000000000')YesP01_EANETTG Allow NULL? 
65DBZU_NETMONMonthly Net Remunerationnvarchar90NUMC(N'000000000')YesP01_EANETMO Allow NULL? 
66DBZU_ZUMUGMaternity Pay Allowancenvarchar90NUMC(N'000000000')YesP01_EAZUMUG Allow NULL? 
67DBZU_NETAAGCalendar Daily Net Remuneration from Other Employmentnvarchar90NUMC(N'000000000')YesP01_EANETAAG Allow NULL? 
68DBBV_UEBVERPayment Method of the Reimbursementchar10NUMC(N'0')YesP01_DBBVVG Allow NULL? 
69DBBV_VERMOPeriod of the Clearing with the Contribution Statementnvarchar60NUMC(N'000000')YesP01_EAVERMO Allow NULL? 
70DBBV_KTOAccount Numbernvarchar100NUMC(N'0000000000')YesP01_EAKTO Allow NULL? 
71DBBV_BLZBank Numbernvarchar80NUMC(N'00000000')YesP01_EABLZ Allow NULL? 
72DBBV_IBANIBAN of the Employing Companynvarchar340CHAR(N' ')YesP01_EAIBAN Allow NULL? 
73DBBV_BICSWIFT BIC of the Employing Companynvarchar110CHAR(N' ')YesP01_EABIC Allow NULL? 
74DBBV_KTOINAccount Holdernvarchar500CHAR(N' ')YesP01_EAKTOIN Allow NULL? 
75DBBV_VZWECKNote to Payeenvarchar500CHAR(N' ')YesP01_EAVZWECK Allow NULL? 
76DBNA_FMNAFamily Namenvarchar300CHAR(N' ')YesD3FMNA Allow NULL? 
77DBNA_VONAFirst Namenvarchar300CHAR(N' ')YesD3VONA Allow NULL? 
78DBNA_VOSAName Affixnvarchar200CHAR(N' ')YesD3VOSA Allow NULL? 
79DBNA_NAZUName Affixesnvarchar200CHAR(N' ')YesD3NAZU Allow NULL? 
80DBNA_TITELTitlenvarchar200CHAR(N' ')YesD3TITEL Allow NULL? 
81DBAN_LDKZCountry (License Plate) Codenvarchar30CHAR(N' ')YesD3LDKZ Allow NULL? 
82DBAN_PLZPostal Codenvarchar100CHAR(N' ')YesD3PLZ Allow NULL? 
83DBAN_ORTCitynvarchar340CHAR(N' ')YesD3ORT Allow NULL? 
84DBAN_STRStreetnvarchar330CHAR(N' ')YesD3STR Allow NULL? 
85DBAN_NRHouse Numbernvarchar90CHAR(N' ')YesD3NR Allow NULL? 
86DBAN_ADRZUAddress Affixnvarchar400CHAR(N' ')YesD3ADRZU Allow NULL? 
87DBAA_ANRAAForm of Address for Contact Person (Mr., Mrs...etc)char10CHAR(N' ')YesP01_ANRAP Allow NULL? 
88DBAA_NAMEAAName of Contact Personnvarchar300CHAR(N' ')YesP01_NAMEAP Allow NULL? 
89DBAA_TELAATelephone Number of Contact Personnvarchar200CHAR(N' ')YesP01_TELAP Allow NULL? 
90DBAA_FAXAAFax Number of Contact Personnvarchar200CHAR(N' ')YesP01_FAXAP Allow NULL? 
91DBAA_EMAILAAE-Mail Address of Contact for Logs at Creator's Officenvarchar700CHAR(N' ')YesP01_EMAILAP Allow NULL? 
92DBAA_NAME1BETRSender's Namenvarchar300CHAR(N' ')YesP01_NAME1 Allow NULL? 
93DBAA_NAME2BETRSender's Second Namenvarchar300CHAR(N' ')YesP01_NAME2 Allow NULL? 
94DBAA_NAME3BETRSender's Third Namenvarchar300CHAR(N' ')YesP01_NAME3 Allow NULL? 
95DBAA_PLZBETRPostal Codenvarchar100CHAR(N' ')YesD3PLZ Allow NULL? 
96DBAA_ORTBETRCitynvarchar340CHAR(N' ')YesD3ORT Allow NULL? 
97DBAA_STRBETRStreetnvarchar330CHAR(N' ')YesD3STR Allow NULL? 
98DBAA_NRBETRHouse Numbernvarchar90CHAR(N' ')YesD3NR Allow NULL? 
99DSER_APROType of Payroll Program Usedchar10NUMC(N'0')YesP01_APRO Allow NULL? 
100DSER_MMAAData Module DBAA Existschar10CHAR(N' ')YesP01_EAMMAA Allow NULL? 
101DBAU_ABTGCession According to Sec.5 AAG Is Explainedchar10CHAR(N' ')YesP01_ABTG Allow NULL? 
102DBBT_MUTENExpected Date of Deliverynvarchar80DATS(N'00000000')YesP01_MUTEN Allow NULL? 
103DBZU_MUTENExpected Date of Deliverynvarchar80DATS(N'00000000')YesP01_MUTEN Allow NULL? 
NamePrimaryUniqueTypeColumns
P01EA_MELD~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