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  | P2RP_VA
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
1ERP EHP76.0P2RP_VA411HR-PT: Payroll Results: Vacation allowance grouping (VA)
SQL:  selectupdate insert create

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

SELECT MANDT, DCT_PERNR, DCT_SEQNR, DCT_ROWID, VAGRP, ALLTY, REGTY, TERMX, FIXCO, VARCO, PAMNT, CPAMT, PDAYS, CPDAY, EAMNT, CEAMT, VDAYS, CVDAY, ESTAM, AMT_CURR, NQUOT, NLDAY, TQUOT, TLDAY, TUNIT, PAYFL, CPAYF, ADJFL, TERFL, AWART, OBEGD, OENDD, GWTYP, GAPZN, GLDAY, GZEIN, CLAMT, CLDAY, CDURP, EDIFF, GENER FROM P2RP_VA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DCT_PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoP_PERNR Allow NULL? 
3DCT_SEQNRSequence Numbernvarchar50NUMC(N'00000')NoHRPY_RGDIRCDSEQ Allow NULL? 
4DCT_ROWIDUnique Row Numbernvarchar50NUMC(N'00000')NoHRDCT_ROWID Allow NULL? 
5VAGRPVacation allowance groupingnvarchar20CHAR(N' ')YesPPT_VAGRP Allow NULL? 
6ALLTYType of vacation allowancechar10CHAR(N' ')YesPPT_ALLTY Allow NULL? 
7REGTYType of regime (normal/alternative)char10CHAR(N' ')YesPPT_REGTY Allow NULL? 
8TERMXSpecial processing for terminationchar10CHAR(N' ')YesPPT_TERMX Allow NULL? 
9FIXCOFixed component of VA reference remunerationdecimal152CURR((0))YesPPT_FIXCO
10VARCOVariable component of VA reference remunerationdecimal152CURR((0))YesPPT_VARCO
11PAMNTVA amount paid in perioddecimal152CURR((0))YesPPT_PAMNT
12CPAMTPaid VA amount cumulated until perioddecimal152CURR((0))YesPPT_CPAMT
13PDAYSNo.of leave days covered by VA payment in perioddecimal105DEC((0))YesPPT_PDAYS
14CPDAYNo.of cumulated leave days covered by VA paymentdecimal105DEC((0))YesPPT_CPDAY
15EAMNTVA amount earned in perioddecimal152CURR((0))YesPPT_EAMNT
16CEAMTCumulated amount of earned VAdecimal152CURR((0))YesPPT_CEAMT
17VDAYSNumber of leave days takendecimal105DEC((0))YesPPT_VDAYS
18CVDAYNo.of cumulated leave days takendecimal105DEC((0))YesPPT_CVDAY
19ESTAMEstimated annual VA amountdecimal152CURR((0))YesPPT_ESTAM
20AMT_CURRCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
21NQUOTAbsence quota type for annual leave entitlementnvarchar20NUMC(N'00')Yes*PPT_NQUOT Allow NULL? 
22NLDAYAnnual leave entitlement daysdecimal105DEC((0))YesPPT_NLDAY
23TQUOTAbsence quota type for termination entitlementnvarchar20NUMC(N'00')Yes*PPT_TQUOT Allow NULL? 
24TLDAYEntitlement days for contract terminationdecimal105DEC((0))YesPPT_TLDAY
25TUNITTime unitnvarchar30CHAR(N' ')Yes*PPT_TUNIT Allow NULL? 
26PAYFLType of payment frequency (A - annual; P - periodic)char10CHAR(N' ')YesPPT_PAYFL Allow NULL? 
27CPAYFType of payment frequency at least occuring once in yearchar10CHAR(N' ')YesPPT_CPAYF Allow NULL? 
28ADJFLFlag for adjustment payment in periodchar10CHAR(N' ')YesPPT_ADJFL Allow NULL? 
29TERFLFlag for contract termination adjustmentchar10CHAR(N' ')YesPPT_TERFL Allow NULL? 
30AWARTAbsence type of leave period triggering allowance paymentnvarchar40CHAR(N' ')Yes*PPT_AWART Allow NULL? 
31OBEGDOld start datenvarchar80DATS(N'00000000')YesOBEGD Allow NULL? 
32OENDDOld end datenvarchar80DATS(N'00000000')YesOENDD Allow NULL? 
33GWTYPWage type generated for allowance paymentnvarchar40CHAR(N' ')Yes*PPT_GWTYP Allow NULL? 
34GAPZNPC205 assignmentvarbinary10RAWYesAPZNR
35GLDAYNo.of leave days for which a payment was generateddecimal105DEC((0))YesPPT_GLDAY
36GZEINTime/Measurement Unitnvarchar30CHAR(N' ')Yes*PT_ZEINH Allow NULL? 
37CLAMTAmount to be cleared (due to as-earned principle)decimal152CURR((0))YesPPT_CLAMT
38CLDAYTaken leave days to be cleared (due to as-earned principle)decimal105DEC((0))YesPPT_CLDAY
39CDURPNo.of months in same processing variant (in year)decimal42DEC((0))YesPPT_CDURP
40EDIFFDifference between estimated VA amount and reference remun.decimal152CURR((0))YesPPT_EDIFF
41GENERIndicator for automatic generation of allowance paymentchar10CHAR(N' ')YesPPT_GENER Allow NULL? 
NamePrimaryUniqueTypeColumns
P2RP_VA~0YesYesCLUSTEREDDCT_ROWID, DCT_SEQNR, DCT_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