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  | P01EL_DBEN
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.0P01EL_DBEN391Data Modules ELENA Basic Data for Employer and EmployeeSocial Insurance
SQL:  selectupdate insert create

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

SELECT MANDT, GUID, AVBEG, STKL, FKT, KINDFRB, TTSC, KENNZRK, BYGR, AZWOECH, VSTBREGLF, STBREGLF, VSTBREGSO, STBREGSO, SVBREGLF, SVBREGE, VGSBREG, GSBREG, KVLF, KVE, RVLF, RVE, AVLF, AVE, PVLF, PVE, VLSTLF, LSTLF, VLSTSOB, LSTSOB, VSOLILF, SOLILF, VSOLISOB, SOLISOB, VKISTLF, KISTLF, VKISTSOB, KISTSOB, STAPAG FROM P01EL_DBEN
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? 
3AVBEGStart of the Work/Employment Relationshipnvarchar80DATS(N'00000000')YesP01_SV_EL_AVBEG Allow NULL? 
4STKLTax classchar10CHAR(N' ')YesP01_SV_EL_STKL Allow NULL? 
5FKTFactor for Tax Calculationnvarchar40NUMC(N'0000')YesP01_SV_EL_FKT Allow NULL? 
6KINDFRBTax Exemption for Childrennvarchar30NUMC(N'000')YesP01_SV_EL_KINDFRB Allow NULL? 
7TTSCOccupational Codenvarchar90CHAR(N' ')YesP01_SV_EL_TTSC Allow NULL? 
8KENNZRKPlace of Work (Legal Area) Indicatorchar10CHAR(N' ')YesP01_SV_EL_KENNZRK Allow NULL? 
9BYGRContribution Groupnvarchar40NUMC(N'0000')YesP01_SV_EL_BYGR Allow NULL? 
10AZWOECHWeekly Working Timenvarchar40NUMC(N'0000')YesP01_SV_EL_AZWOECH Allow NULL? 
11VSTBREGLF+/- for Regular Gross Remuneration Subject to Taxchar10CHAR(N' ')YesP01_SV_EL_VZSTBREGLF Allow NULL? 
12STBREGLFCurrent Gross Remuneration Subject to Taxnvarchar100NUMC(N'0000000000')YesP01_SV_EL_STBREGLF Allow NULL? 
13VSTBREGSO+/- Sign for Other Gross Remuneration Subject to Taxchar10CHAR(N' ')YesP01_SV_EL_STBREGSO Allow NULL? 
14STBREGSOOther Gross Remuneration Subject to Taxnvarchar100NUMC(N'0000000000')YesP01_SV_EL_STRBEGSO Allow NULL? 
15SVBREGLFCurrent Gross Remuneration Subject to SI Contributionsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_SVBREGLF Allow NULL? 
16SVBREGEOne-Time SI Gross Paymentnvarchar100NUMC(N'0000000000')YesP01_SV_EL_SVBREGE Allow NULL? 
17VGSBREG+/- for Total Gross Remunerationchar10CHAR(N' ')YesP01_SV_EL_VZGSBREG Allow NULL? 
18GSBREGTotal Gross Remunerationnvarchar100NUMC(N'0000000000')YesP01_SV_EL_GSBREG Allow NULL? 
19KVLFHI Payments on Regular Remunerationsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_KVLF Allow NULL? 
20KVEHI Payments on Non-Recurring Remunerationsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_KVE Allow NULL? 
21RVLFPI Contributions on Current Remunerationnvarchar100NUMC(N'0000000000')YesP01_SV_EL_RVLF Allow NULL? 
22RVEPI Contributions on Once-Only Paymentsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_RVE Allow NULL? 
23AVLFUI Contributions on Current Remunerationnvarchar100NUMC(N'0000000000')YesP01_SV_EL_AVLF Allow NULL? 
24AVEUI Contributions on One-Time Paymentsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_AVE Allow NULL? 
25PVLFCI Contribution for Current Remunerationnvarchar100NUMC(N'0000000000')YesP01_SV_EL_PVLF Allow NULL? 
26PVECare Insurance Contribution for Once-Only Paymentsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_PVE Allow NULL? 
27VLSTLF+/- for Employment Tax Regularchar10CHAR(N' ')YesP01_SV_EL_VZLSTLF Allow NULL? 
28LSTLFEmployment Tax on Regular Paymentsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_LSTLF Allow NULL? 
29VLSTSOB+/- for Employment Tax on Other Paymentschar10CHAR(N' ')YesP01_SV_EL_VZLSTSOB Allow NULL? 
30LSTSOBEmployment Tax Other Paymentnvarchar100NUMC(N'0000000000')YesP01_SV_EL_LSTSOB Allow NULL? 
31VSOLILF+/- for Reunification Tax Regularchar10CHAR(N' ')YesP01_SV_EL_VZSOLILF Allow NULL? 
32SOLILFReunification Tax Currentnvarchar100NUMC(N'0000000000')YesP01_SV_EL_SOLILF Allow NULL? 
33VSOLISOB+/- for Reunification Tax on Other Paymentschar10CHAR(N' ')YesP01_SV_EL_VZSOLISOB Allow NULL? 
34SOLISOBReunification Tax on Other Paymentsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_SOLISOB Allow NULL? 
35VKISTLF+/- for Church Tax on Regular Paymentschar10CHAR(N' ')YesP01_SV_EL_VZKISTLF Allow NULL? 
36KISTLFChurch Tax on Regular Paymentsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_KISTLF Allow NULL? 
37VKISTSOB+/- for Church Tax on Other Paymentschar10CHAR(N' ')YesP01_SV_EL_VZKISTSOB Allow NULL? 
38KISTSOBChurch Tax on Other Paymentsnvarchar100NUMC(N'0000000000')YesP01_SV_EL_KISTSOB Allow NULL? 
39STAPAGEmployer's Tax Deduction Obligationchar10CHAR(N' ')YesP01_SV_EL_STAPAG Allow NULL? 
NamePrimaryUniqueTypeColumns
P01EL_DBEN~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