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  | PAPBSDEVA_VLTSV1
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 :: Public Sector :: Pension Administration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PAPBSDEVA_VLTSV1401Results Treaty on Sharing of Pension CostsPension Administration
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, APRFNR, BEGDA, ENDDA, NEUER_DIENSTHERR, RGHFDB, RGHFDB_MAN, DZ_QUOT_YEAR, DZ_QUOT_MONTH, DZ_QUOT_MONATE, ABW_BEMESS_SATZ, ABFINDUNG, ABF_ZINSEN, ERH_ABFINDUNG, ERH_ABF_ZINSEN, UEB_BETRAG, UEB_BETRAG_MAN, BERECHNUNGSDATUM, RELKZ, REL_DATUM, KEIN_P3, EINVF, DH_WECHSEL_DAT, RGFDB_WAERS, BERECHNUNG_WAERS, AEDTM, UNAME, BERECH_ART, BERECH_GRUND, APRFNR_REF, SONDERZAHLUNG, BOX_SOZA, SONDERZAHL_MASCH, RECHTS_GRUNDLAGE, ABW_BER_STICHTAG, VZWECK, SPRKZ, ABRKZ, ABRDAT FROM PAPBSDEVA_VLTSV1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoPERNR_D Allow NULL? 
3APRFNRApplication reference numbernvarchar60NUMC(N'000000')NoP00_PBS_APRFNR Allow NULL? 
4BEGDAValidity Start Date of Severance Pay Periodnvarchar80DATS(N'00000000')YesPDE_PBS_VLTSV_ABF_BEGDA Allow NULL? 
5ENDDAValidity End Date of Severance Pay Periodnvarchar80DATS(N'00000000')YesPDE_PBS_VLTSV_ABF_ENDDA Allow NULL? 
6NEUER_DIENSTHERRNew Public Sector Employernvarchar80CHAR(N' ')YesT536CPDE_PBS_VLTSV_NEUER_DIENSTHERR Allow NULL? 
7RGHFDBPensionable Paydecimal152CURR((0))YesPDE_PBS_RGHFDB
8RGHFDB_MANPensionable Pay Manualdecimal152CURR((0))YesPDE_PBS_RGHFDB_MAN
9DZ_QUOT_YEAREmployment Periods for Quotas in Yearsnvarchar30NUMC(N'000')YesPDE_PBS_VLTSV_DZ_QUOT_YEAR Allow NULL? 
10DZ_QUOT_MONTHEmployment Periods for Quotas in Monthsnvarchar20NUMC(N'00')YesPDE_PBS_VLTSV_DZ_QUOT_MONTH Allow NULL? 
11DZ_QUOT_MONATEEmployment Periods from Quotas in Monthsnvarchar40NUMC(N'0000')YesPDE_PBS_VLTSV_DZ_QUOT_MONATE Allow NULL? 
12ABW_BEMESS_SATZAlternative Assessment Ratenvarchar20CHAR(N' ')YesPDE_PBS_VLTSV_ABW_BEMESS_SATZ Allow NULL? 
13ABFINDUNGSeverance Pay Amountdecimal152CURR((0))YesPDE_PBS_VLTSV_ABFINDUNG
14ABF_ZINSENInterest Accruing on Severance Paymentdecimal152CURR((0))YesPDE_PBS_VLTSV_ABFINDUNG_ZINSEN
15ERH_ABFINDUNGSeverance Pay Receiveddecimal132CURR((0))YesPDE_PBS_VLTSV_RELEVANT_ERH_ABF
16ERH_ABF_ZINSENInterest Accruing on Received Severance Paymentsdecimal152CURR((0))YesPDE_PBS_VLTSV_ERH_ABF_ZINSEN
17UEB_BETRAGTransfer Amount for Severance Paydecimal152CURR((0))YesPDE_PBS_VLTSV_UEBERW_BETRAG
18UEB_BETRAG_MANTransfer Amount for Severance Pay Manualdecimal152CURR((0))YesPDE_PBS_VLTSV_UEBERW_BET_MAN
19BERECHNUNGSDATUMCalculation Date of Severance Paynvarchar80DATS(N'00000000')YesPDE_PBS_VLTSV_BERECHNUNGSDATUM Allow NULL? 
20RELKZRelease Indicator Severance Paychar10CHAR(N' ')YesPDE_PBS_VLTSV_RELKZ Allow NULL? 
21REL_DATUMRelease Date for Severance Paynvarchar80DATS(N'00000000')YesPDE_PBS_VLTSV_REL_DATUM Allow NULL? 
22KEIN_P3Prerequisites Accordin to Sec.3 VLTSV Are Not Fulfilledchar10CHAR(N' ')YesPDE_PBS_VLTSV_KEIN_P3 Allow NULL? 
23EINVFEntry: Pension Eventnvarchar80DATS(N'00000000')YesEINVF Allow NULL? 
24DH_WECHSEL_DATDate of Change of Employer After Start of Treatynvarchar80DATS(N'00000000')YesPDE_PBS_VLTSV_DH_WECHSEL_DAT Allow NULL? 
25RGFDB_WAERSCurrency Keynvarchar50CUKY(N' ')YesT500WWAERS Allow NULL? 
26BERECHNUNG_WAERSCurrency Keynvarchar50CUKY(N' ')YesT500WWAERS Allow NULL? 
27AEDTMChanged onnvarchar80DATS(N'00000000')YesAEDTM Allow NULL? 
28UNAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
29BERECH_ARTCalculation Type of Severance Pay Processnvarchar20CHAR(N' ')YesT7DEPBSVLT01PDE_PBS_VLTSV_BERECH_ART Allow NULL? 
30BERECH_GRUNDCalculation Reason for Severance Pay (Change of Employer)nvarchar20CHAR(N' ')YesT7DEPBSVLT0APDE_PBS_VLTSV_BERECH_GRUND Allow NULL? 
31APRFNR_REFApplication reference numbernvarchar60NUMC(N'000000')YesP00_PBS_APRFNR Allow NULL? 
32SONDERZAHLUNGManually Entered Special Payment for Calc. of Severance Paydecimal152CURR((0))YesPDE_PBS_VLTSV_SOZUW_MAN
33BOX_SOZACheckbox for Entry of Special Paymentchar10CHAR(N' ')YesPDE_PBS_VLTSV_BOX_SOZA Allow NULL? 
34SONDERZAHL_MASCHAutomatically Calculated Special Paymentdecimal152CURR((0))YesPDE_PBS_VLTSV_SOZUW_MASCH
35RECHTS_GRUNDLAGELegal Basis of Employernvarchar20CHAR(N' ')YesT7DEPBSVLT05PDE_PBS_VLTSV_RECHTSGRDL Allow NULL? 
36ABW_BER_STICHTAGDeviating Calculation Key Datenvarchar80DATS(N'00000000')YesPDE_PBS_VLTSV_BDATE Allow NULL? 
37VZWECKNote to Payeenvarchar300CHAR(N' ')YesPDE_PBS_VLTSV_PAY_VZWECK Allow NULL? 
38SPRKZ'Payment' Lock Indicatorchar10CHAR(N' ')YesPDE_PBS_VLTSV_SPRKZ Allow NULL? 
39ABRKZPayroll Indicatorchar10CHAR(N' ')YesPDE_PBS_VLTSV_ABRKZ Allow NULL? 
40ABRDATPayroll Datenvarchar80DATS(N'00000000')YesPDE_PBS_VLTSV_ABRDAT Allow NULL? 
NamePrimaryUniqueTypeColumns
PAPBSDEVA_VLTSV1~0YesYesCLUSTEREDAPRFNR, PERNR, 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