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  | P01CVD
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
Personnel Management :: Pension Schemes :: Company Pension Scheme Germany
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0P01CVD812Actuarial CPS DataCompany Pension Scheme Germany
SQL:  selectupdate insert create

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

SELECT MANDT, VMGRD, BLSTG, LTRGR, VMPID, PERNR, VMART, HANSP, SEQNO, IVSTG, BWSTG, CRDAT, CRNAM, VMSTA, MSTVM, AANSP, MODBV, VMANR, BEGAN, ENDAN, BEGAA, WAERS, LGART, ANWRT, KZKWZ, MMKWZ, BEGWZ, RSTGR, ANGRP, LURSP, MITST, BETFI, BTFKZ, BETMA, BETMI, ANZHL, ZEINH, DZPRZ, AVDPZ, DZJHR, DZRTG, BEITR, BEIKZ, WZPVZ, WZTNO, KNZWZ, EWZAB, ENDWZ, BEGUA, UAVER, UAPVZ, UNVNO, UNVAB, ENDUA, UNVAW, STAUA, DATUA, ZFAKM, ZFAKN, ZFAMN, ANZML, RELHR, FEALT, DATRU, EINDT, FEALM, BETGP, WAEGP, BEGGP, ENDGP, GPTYP, DTYBS, GPDJJ, GPBJJ, ZNRGP, GRDVU, DATUE, BETUE, VUWAE, ELTRG, ALTRG FROM P01CVD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VMGRDReason for Generating Interface Datanvarchar20CHAR(N' ')NoT5DC7P01C_VMGRD Allow NULL? 
3BLSTGBalance Sheet Datenvarchar80DATS(N'00000000')NoP01C_BLSTG Allow NULL? 
4LTRGRBenefits Providernvarchar40CHAR(N' ')NoT5DCUP01C_LTRGR Allow NULL? 
5VMPIDIdentification Key for Personnvarchar150CHAR(N' ')NoP01C_VMPID Allow NULL? 
6PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoP_PERNR Allow NULL? 
7VMARTBenefit Typechar10CHAR(N' ')NoP01C_VMART Allow NULL? 
8HANSPCompany Pension Scheme Entitlementnvarchar40CHAR(N' ')NoT5DCAP01C_HANSP Allow NULL? 
9SEQNOSequence Number for Same Entitlementnvarchar40NUMC(N'0000')NoP01C_VMSEQ Allow NULL? 
10IVSTGData Determination Key Datenvarchar80DATS(N'00000000')YesP01C_IVSTG Allow NULL? 
11BWSTGValuation Datenvarchar80DATS(N'00000000')YesP01C_BWSTG Allow NULL? 
12CRDATDate of Runnvarchar80DATS(N'00000000')YesP01C_CRDAT Allow NULL? 
13CRNAMUser Namenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
14VMSTAProcessing Status for Interface Datachar10CHAR(N' ')YesP01C_VMSTA Allow NULL? 
15MSTVMNotification Status for Actuarial Interfacechar10CHAR(N' ')YesP01X_MSTVM Allow NULL? 
16AANSPBenefit Type of Company Pension Schemenvarchar40CHAR(N' ')Yes*P01C_AANSP Allow NULL? 
17MODBVCalculation Variant for Entitlementnvarchar20CHAR(N' ')Yes*P01C_MODBV Allow NULL? 
18VMANRIdentification Number for Assessornvarchar150CHAR(N' ')YesP01C_VMANR Allow NULL? 
19BEGANStart of Entitlementnvarchar80DATS(N'00000000')YesP01C_BEGAN Allow NULL? 
20ENDANEnd of Entitlementnvarchar80DATS(N'00000000')YesP01C_ENDAN Allow NULL? 
21BEGAAAlternative Entitlement Start Date for Valuationnvarchar80DATS(N'00000000')YesP01C_BEGAA Allow NULL? 
22WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
23LGARTWage Typenvarchar40CHAR(N' ')Yes*P01C_LGART Allow NULL? 
24ANWRTLegal Right to Future Pension Paymentsdecimal92CURR((0))YesP01C_ANWRT
25KZKWZIndicator for Reduced Waiting Periodchar10CHAR(N' ')YesP01C_KZKWZ Allow NULL? 
26MMKWZIndicator for Reduced Waiting Periodchar10CHAR(N' ')YesP01C_KZKWZ Allow NULL? 
27BEGWZTechnical Start Date for Waiting Period Checknvarchar80DATS(N'00000000')YesP01C_BEGWZ Allow NULL? 
28RSTGRReserve Groupnvarchar40CHAR(N' ')Yes*P01C_RSTGR Allow NULL? 
29ANGRPPension Plannvarchar40CHAR(N' ')Yes*P01C_ANGRP Allow NULL? 
30LURSPCompany Responsiblenvarchar40CHAR(N' ')Yes*P01C_LURSP Allow NULL? 
31MITSTEntitlement Statuschar10CHAR(N' ')Yes*P01C_MITST Allow NULL? 
32BETFIFixed Amount of Benefitdecimal92CURR((0))YesP01C_BETFI
33BTFKZIndicator for Annual/Monthly Benefitchar10CHAR(N' ')YesP01C_BTFKZ Allow NULL? 
34BETMAMaximum Benefitdecimal92CURR((0))YesP01C_BETMA
35BETMIMinimum Benefitdecimal92CURR((0))YesP01C_BETMI
36ANZHLNumberdecimal72DEC((0))YesANZHL
37ZEINHTime unit for determining next paymentnvarchar30CHAR(N' ')Yes*DZEINZ Allow NULL? 
38DZPRZPercentage Rate for Valuation of Employment Perioddecimal52DEC((0))YesP01C_DZPRZ
39AVDPZAverage Part-Time Percentage Ratedecimal52DEC((0))YesP01C_AVDPZ
40DZJHRFull Entitlement Yearsnvarchar20NUMC(N'00')YesP01C_DZJHR Allow NULL? 
41DZRTGRemaining Entitlement Daysnvarchar30NUMC(N'000')YesP01C_DZRTG Allow NULL? 
42BEITRContributiondecimal92CURR((0))YesP01C_BEITR
43BEIKZContribution Indicatorchar10CHAR(N' ')YesP01C_BEIKZ Allow NULL? 
44WZPVZCheck: Waiting Periodchar10CHAR(N' ')YesP01C_WZPVZ Allow NULL? 
45WZTNOWaiting Period Not Fulfilledchar10CHAR(N' ')YesP01C_WZTNO Allow NULL? 
46KNZWZWaiting Period Filled Indicatorchar10CHAR(N' ')YesP01C_KNZWZ Allow NULL? 
47EWZABCalculated End of Waiting Periodnvarchar80DATS(N'00000000')YesP01C_EWZAB Allow NULL? 
48ENDWZLatest End of Waiting Periodnvarchar80DATS(N'00000000')YesP01C_ENDWZ Allow NULL? 
49BEGUATechnical Start Date for Vesting Checknvarchar80DATS(N'00000000')YesP01C_BEGUA Allow NULL? 
50UAVERWaiver VE Checkchar10CHAR(N' ')YesP01C_UAVER Allow NULL? 
51UAPVZWaiver VE Checkchar10CHAR(N' ')YesP01C_UAPVZ Allow NULL? 
52UNVNOVE Qualification Period Not Fulfilledchar10CHAR(N' ')YesP01C_UNVNO Allow NULL? 
53UNVABCalculated Date for Vestingnvarchar80DATS(N'00000000')YesP01C_UNVAB Allow NULL? 
54ENDUALatest Start of Vestingnvarchar80DATS(N'00000000')YesP01C_ENDUA Allow NULL? 
55UNVAWIndicator for Vested Entitlementchar10CHAR(N' ')YesP01C_UNVAW Allow NULL? 
56STAUAVesting Statuschar10CHAR(N' ')YesP01C_STAUA Allow NULL? 
57DATUAVested Sincenvarchar80DATS(N'00000000')YesP01C_DATUA Allow NULL? 
58ZFAKMEmployment Months Reached (m) for PR Calculationdecimal84DEC((0))YesP01C_ZFAKM
59ZFAKNMaximum Possible Emp. Months for Proportional Reductiondecimal84DEC((0))YesP01C_ZFAKN
60ZFAMNEmployment Period Factor Proportional Reductiondecimal65DEC((0))YesP01C_ZFAMN
61ANZMLNumber of Increase Periodsdecimal84DEC((0))YesP01C_ANZML
62RELHRRelevance for Surviving Dependents Pensionchar10CHAR(N' ')YesP01C_RELHR Allow NULL? 
63FEALTFinal Age (Years)nvarchar20NUMC(N'00')YesP01C_FEALT Allow NULL? 
64DATRUDate of Reimbursementnvarchar80DATS(N'00000000')YesP01C_DATRU Allow NULL? 
65EINDTEntry datenvarchar80DATS(N'00000000')YesP01C_EINDT Allow NULL? 
66FEALMFinal Age (Months)nvarchar20NUMC(N'00')YesP01C_FEALM Allow NULL? 
67BETGPVested Payment Amountdecimal92CURR((0))YesP01C_BETGP
68WAEGPCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
69BEGGPStart of Vested Paymentsnvarchar80DATS(N'00000000')YesP01C_BEGGP Allow NULL? 
70ENDGPEnd of Vested Paymentsnvarchar80DATS(N'00000000')YesP01C_ENDGP Allow NULL? 
71GPTYPVested Payments Typechar10CHAR(N' ')YesP01C_GPTYP Allow NULL? 
72DTYBSType of Vested Payment Dynamic Modificationchar10CHAR(N' ')Yes*P01C_DTYBS Allow NULL? 
73GPDJJNumber of Employment Years for Vested Paymentsdecimal42DEC((0))YesP01C_GPDJJ
74GPBJJEmployment Start Yeardecimal42DEC((0))YesP01C_GPBJJ
75ZNRGPAssignment Number for Vested Paymentsnvarchar40NUMC(N'0000')YesP01C_ZNRGP Allow NULL? 
76GRDVUReason for Capital Transfernvarchar20CHAR(N' ')YesT5DC7P01C_GRDVU Allow NULL? 
77DATUEDate of Capital Transfernvarchar80DATS(N'00000000')YesP01C_DATUE Allow NULL? 
78BETUETransferred Capitaldecimal92CURR((0))YesP01C_BETUE
79VUWAECurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
80ELTRGReceiving Benefits Providernvarchar40CHAR(N' ')YesT5DC3P01C_ELTRG Allow NULL? 
81ALTRGSending Benefits Providernvarchar40CHAR(N' ')YesT5DC3P01C_ALTRG Allow NULL? 
NamePrimaryUniqueTypeColumns
P01CVD~0YesYesCLUSTEREDSEQNO, HANSP, VMART, PERNR, VMPID, LTRGR, BLSTG, VMGRD, MANDT
P01CVD~VMANoNoNONCLUSTEREDPERNR, VMGRD, 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