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  | P01ZS_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
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.0P01ZS_MELD651Data Record and Data Modules for Paying Office ProcedureSocial Insurance
SQL:  selectupdate insert create

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

SELECT MANDT, GUID, DSVZ_VF, DSVZ_BBNRAB, DSVZ_BBNREP, DSVZ_VERNR, DSVZ_ED, DSVZ_FEKZ, DSVZ_FEAN, DSVZ_KVNR, DSVZ_BBNRVU, DSVZ_AZVU, DSVZ_BBNRKK, DSVZ_AZKK, DSVZ_BBNRAS, DSVZ_GD, DSVZ_MMZK, DSVZ_MMNA, DSVZ_MMGA, DSVZ_MMKZ, DSVZ_MMAN, DSVZ_MMPS, DSVZ_VSNR, DBZK_KENNZST, DBZK_GD, DBZK_KENNZBEIH, DBZK_VBBG, DBZK_VBEN, DBZK_VBAEN, DBZK_VBBETR, DBZK_KAPAUSBG, DBZK_KAPZRBG, DBZK_KAPZREN, DBZK_KAPBETR, DBZK_BEITRKV, DBZK_BEITRPV, DBNA_FMNA, DBNA_VONA, DBNA_VOSA, DBNA_NAZU, DBNA_TITEL, DBNA_KENNZAB, DBGA_GBDT, DBGA_GE, DBKZ_KENNZST, DBKZ_GD, DBKZ_KENNZABF, DBKZ_ABFBG, DBKZ_ABFEN, DBKZ_ABFAEN, DBKZ_BYSATZ, DBKZ_KENNZMFB, DBKZ_VBMAX, DBKZ_KENNZANPZ, DBKZ_KENNZAEN, DBKZ_BBNRKKN, DBAN_LDKZ, DBAN_PLZ, DBAN_ORT, DBAN_STR, DBAN_NR, DBAN_ADRZU, DBPS_KENNZST, DBPS_KENNZSOZA, DBPS_ZRBG FROM P01ZS_MELD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GUIDUnique Key for Identification of Notificationnvarchar320CHAR(N' ')NoP01_SVGUID Allow NULL? 
3DSVZ_VFProcedure Feature of Data Recordnvarchar50CHAR(N' ')YesP01_ZSVF Allow NULL? 
4DSVZ_BBNRABCompany Number of Sendernvarchar150CHAR(N' ')YesP01_BBNRAB Allow NULL? 
5DSVZ_BBNREPCompany Number of Recipientnvarchar150CHAR(N' ')YesP01_BBNREP Allow NULL? 
6DSVZ_VERNRVersion Number of Data Recordnvarchar20NUMC(N'00')YesP01_VERNR Allow NULL? 
7DSVZ_EDCreation Date and Time of the Data Recordnvarchar200NUMC(N'00000000000000000000')YesP01_ED Allow NULL? 
8DSVZ_FEKZIndicator for Data Records with Errorschar10NUMC(N'0')YesP01_ZSFEKZ Allow NULL? 
9DSVZ_FEANNumber of Errors in Data Recordchar10NUMC(N'0')YesP01_FEAN Allow NULL? 
10DSVZ_KVNRHealth Insurance Numbernvarchar140CHAR(N' ')YesP01_KVNR Allow NULL? 
11DSVZ_BBNRVUPaying Office Numbernvarchar150CHAR(N' ')YesP01_BBNRVU Allow NULL? 
12DSVZ_AZVUCase Number of Employernvarchar200CHAR(N' ')YesP01_AZVU Allow NULL? 
13DSVZ_BBNRKKCompany Number of Health Insurance Fundnvarchar150CHAR(N' ')YesP01_BBNRKK Allow NULL? 
14DSVZ_AZKKHealth Insurer Referencenvarchar200CHAR(N' ')YesP01_AZKK Allow NULL? 
15DSVZ_BBNRASCompany Number of Accounting Officenvarchar150CHAR(N' ')YesP01_BBNRAS Allow NULL? 
16DSVZ_GDReason for Statutory Payment in DSVZ Data Recordnvarchar20NUMC(N'00')YesP01_DSVZGD Allow NULL? 
17DSVZ_MMZKDBZK Data Module Existschar10CHAR(N' ')YesP01_MMZK Allow NULL? 
18DSVZ_MMNAData Module DBNA Availablechar10CHAR(N' ')YesP01_MMNA Allow NULL? 
19DSVZ_MMGAData Module BDGA Existschar10CHAR(N' ')YesP01_MMGA Allow NULL? 
20DSVZ_MMKZData Module DBKZ Existschar10CHAR(N' ')YesP01_MMKZ Allow NULL? 
21DSVZ_MMANData Module DBAN Availablechar10CHAR(N' ')YesP01_MMAN Allow NULL? 
22DSVZ_MMPSData Module DBPS Existschar10CHAR(N' ')YesP01_MMPS Allow NULL? 
23DSVZ_VSNRPension Insurance Numbernvarchar120CHAR(N' ')YesRVNUM Allow NULL? 
24DBZK_KENNZSTReversal Indicatorchar10CHAR(N' ')YesP01_KENNZST Allow NULL? 
25DBZK_GDReason for Notification in Data Module DBZKchar10NUMC(N'0')YesP01_DBZKGD Allow NULL? 
26DBZK_KENNZBEIHIndicator for Subsidy Entitlementchar10CHAR(N' ')YesP01_KENNZBEIH Allow NULL? 
27DBZK_VBBGStart of Benefits Paymentnvarchar80DATS(N'00000000')YesP01_VBBG Allow NULL? 
28DBZK_VBENEnd of Benefits Paymentnvarchar80DATS(N'00000000')YesP01_VBEN Allow NULL? 
29DBZK_VBAENChange in Pension Paymentnvarchar80DATS(N'00000000')YesP01_VBAEN Allow NULL? 
30DBZK_VBBETRAmount of Pension Paymentnvarchar80NUMC(N'00000000')YesP01_VBBETR Allow NULL? 
31DBZK_KAPAUSBGTime of Capital Paymentnvarchar80DATS(N'00000000')YesP01_KAPAUSBG Allow NULL? 
32DBZK_KAPZRBGStart of Capital Payment Periodnvarchar80DATS(N'00000000')YesP01_KAPZRBG Allow NULL? 
33DBZK_KAPZRENEnd of Capital Payment Periodnvarchar80DATS(N'00000000')YesP01_KAPZREN Allow NULL? 
34DBZK_KAPBETRLevel of Capitalized Amountnvarchar120NUMC(N'000000000000')YesP01_KAPBETR Allow NULL? 
35DBZK_BEITRKVHealth Insurance Contributionnvarchar80NUMC(N'00000000')YesP01_BEITRKV Allow NULL? 
36DBZK_BEITRPVContribution to Care Insurancenvarchar80NUMC(N'00000000')YesP01_BEITRPV Allow NULL? 
37DBNA_FMNAFamily Namenvarchar300CHAR(N' ')YesP01_FMNA Allow NULL? 
38DBNA_VONAFirst Namenvarchar300CHAR(N' ')YesP01_VONA Allow NULL? 
39DBNA_VOSAName Prefixnvarchar200CHAR(N' ')YesP01_VOSA Allow NULL? 
40DBNA_NAZUName Affixnvarchar200CHAR(N' ')YesP01_NAZU Allow NULL? 
41DBNA_TITELTitlenvarchar200CHAR(N' ')YesP01_TITEL Allow NULL? 
42DBNA_KENNZABIndicator: Name Change/Correctionchar10CHAR(N' ')YesP01_KENNZAB Allow NULL? 
43DBGA_GBDTDate of Birthnvarchar80DATS(N'00000000')YesP01_GBDT Allow NULL? 
44DBGA_GEGenderchar10CHAR(N' ')YesP01_GE Allow NULL? 
45DBKZ_KENNZSTReversal Indicatorchar10CHAR(N' ')YesP01_KENNZST Allow NULL? 
46DBKZ_GDReason for Notification in Data Module DBKZchar10NUMC(N'0')YesP01_DBKZGD Allow NULL? 
47DBKZ_KENNZABFDeduction of Contribution Amount Obligationchar10NUMC(N'0')YesP01_KENNZABF Allow NULL? 
48DBKZ_ABFBGStart of Deduction of Contribution Amountnvarchar80DATS(N'00000000')YesP01_ABFBG Allow NULL? 
49DBKZ_ABFENEnd of Deduction of Contribution Amountnvarchar80DATS(N'00000000')YesP01_ABFEN Allow NULL? 
50DBKZ_ABFAENChange in Deduction of Contribution Amountnvarchar80DATS(N'00000000')YesP01_ABFAEN Allow NULL? 
51DBKZ_BYSATZContribution Rate of Health Insurance Fundnvarchar40NUMC(N'0000')YesP01_BYSATZ Allow NULL? 
52DBKZ_KENNZMFBIndicator: Multiple Paymentchar10NUMC(N'0')YesP01_KENNZMFB Allow NULL? 
53DBKZ_VBMAXMaximum Pension Payment Liable to Contributionsnvarchar70NUMC(N'0000000')YesP01_VBMAX Allow NULL? 
54DBKZ_KENNZANPZPaying Office Can Adjust PPmaxchar10CHAR(N' ')YesP01_KENNZANPZ Allow NULL? 
55DBKZ_KENNZAENIndicator: Paying Office Must Generate Change Notificationchar10CHAR(N' ')YesP01_KENNZAEN Allow NULL? 
56DBKZ_BBNRKKNCompany Number of New Health Insurance Fundnvarchar150CHAR(N' ')YesP01_BBNRKKN Allow NULL? 
57DBAN_LDKZCountry Codenvarchar30CHAR(N' ')YesP01_LDKZ Allow NULL? 
58DBAN_PLZPostal Codenvarchar100CHAR(N' ')YesP01_PLZ Allow NULL? 
59DBAN_ORTCitynvarchar340CHAR(N' ')YesP01_ORT Allow NULL? 
60DBAN_STRStreetnvarchar330CHAR(N' ')YesP01_STR Allow NULL? 
61DBAN_NRHouse Numbernvarchar90CHAR(N' ')YesP01_NR Allow NULL? 
62DBAN_ADRZUAddress Affixnvarchar400CHAR(N' ')YesP01_ADRZU Allow NULL? 
63DBPS_KENNZSTReversal Indicatorchar10CHAR(N' ')YesP01_KENNZST Allow NULL? 
64DBPS_KENNZSOZAIndicator: Social Insurance Adjustmentchar10NUMC(N'0')YesP01_SV_ZS_KENNZSOZA Allow NULL? 
65DBPS_ZRBGStart of Period for Which the Notification Is to Applynvarchar80DATS(N'00000000')YesP01_SV_ZS_ZRBG Allow NULL? 
NamePrimaryUniqueTypeColumns
P01ZS_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