SAP Reports / Programs

SAPDBPNP SAP ABAP Report - Logical database PNP: Database program







SAPDBPNP is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for In future, the see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter SAPDBPNP into the relevant SAP transactions such as SE38 or SE80


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT SAPDBPNP. "Basic submit
SUBMIT SAPDBPNP AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBPNP VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: PNPSTAT2 = Employment status
Selection Text: PNPSTAT1 = Customer-specific status
Selection Text: PNPSNAME = EE name can be sorted
Selection Text: PNPSBMOD = Administrator group
Selection Text: PNPSASBZ = Administrator group: time
Selection Text: PNPSASBP = Administrator group: personnel
Selection Text: PNPSASBA = Administrator group: payroll
Selection Text: PNPSACHZ = Time recording administrator
Selection Text: PNPSACHP = Personnel administrator
Selection Text: PNPSACHA = Payroll administrator
Selection Text: PNPPLANS = Position
Selection Text: PNPPERSK = Employee subgroup
Selection Text: PNPPERSG = Employee group
Selection Text: PNPPERNR = D Personnel number
Selection Text: PNPPABRP = Period selection: Period
Selection Text: PNPPABRJ = Period selection: Year
Selection Text: PNPOTYPE = Object Type
Selection Text: PNPORGEH = Organizational unit
Selection Text: PNPMSTBR = Supervisor area
Selection Text: PNPMASSN = D Action type
Selection Text: PNPMASSG = Reason for action
Selection Text: PNPMASNG = Action type/action reason
Selection Text: PNPKOSTL = Cost center
Selection Text: PNPKOKTL = Controlling area/cost center
Selection Text: PNPKOKRS = Controlling area
Selection Text: PNPJUPER = Legal person
Selection Text: PNPGSBER = Business area
Selection Text: PNPGRANT = Grant
Selection Text: PNPGEBER = Fund
Selection Text: PNPFKBER = D Functional area
Selection Text: PNPFISTL = Funds Center
Selection Text: PNPENDPS = Person selection: To
Selection Text: PNPENDDA = Data selection: To
Selection Text: PNPENAME = Employee name
Selection Text: PNPBUKRS = D Company code
Selection Text: PNPBTRTL = D Personnel subarea
Selection Text: PNPBEGPS = Person selection: From
Selection Text: PNPBEGDA = Data selection: From





Selection Text: PNPANSVH = D Work contract
Selection Text: PNPSTAT3 = Special payment status
Selection Text: PYXABKR = Payroll Area
Selection Text: PYWERKS = Personnel area
Selection Text: PYVW2_0 = Payday
Selection Text: PYVW1_1 = For-period view
Selection Text: PYVW1_0 = End of for-period
Selection Text: PYVW0_1 = In-period view
Selection Text: PYVW0_0 = End of in-period
Selection Text: PYSRTZA = D Status of result
Selection Text: PYSEQNR = D Sequential number
Selection Text: PYPERSK = Employee subgroup
Selection Text: PYPERSG = Employee group
Selection Text: PYPERNR = Personnel number
Selection Text: PYPAYTY = Payroll type
Selection Text: PYPAYID = Payroll ID
Selection Text: PYPA03R1 = r1
Selection Text: PYPA03R0 = r0
Selection Text: PYKOSTL = D Cost center
Selection Text: PYJUPER = D Legal person
Selection Text: PYENDDA = end
Selection Text: PYBUKRS = Company code
Selection Text: PYBTRTL = Personnel subarea
Selection Text: PYBEGDA = start
Selection Text: PYABRP1 = p1
Selection Text: PYABKRS = Payroll Area
Selection Text: PNPXPGPK = Employee group/subgroup
Selection Text: PNPXBWBK = Pers.area/subarea/cost center
Selection Text: PNPXABKR = Period selection: Payroll area
Selection Text: PNPWERKS = Personnel area
Selection Text: PNPVDSK1 = Organization key
Selection Text: PNPTIMRA = Other period
Selection Text: PNPTIMR9 = Current period
Selection Text: PNPTIMR6 = Other period
Selection Text: PNPTIMR5 = From current date
Selection Text: PNPTIMR4 = To current date
Selection Text: PNPTIMR3 = Current year
Selection Text: PNPTIMR2 = Current month
Selection Text: PNPTIMR1 = Today





Selection Text: PNPSTELL = Job
Selection Text: PNPSTATU = Status 1/status 2/status 3
Selection Text: PNPABKRS = D Payroll area
Title: Logical database PNP: Database program
Text Symbol: DDI = Data Selection Period
Text Symbol: DAI = Period
Text Symbol: BLT = Period
Text Symbol: BLS = Selection
Text Symbol: BLR = Additional data
Text Symbol: BLP = Payroll period
Text Symbol: BLK = Key date
Text Symbol: BIS = To
Text Symbol: AKT = active
Text Symbol: 128 = Enter a date
Text Symbol: 127 = Do not enter a date
Text Symbol: 124 = Do not enter a period
Text Symbol: 123 = Enter a period
Text Symbol: 052 = Last payroll period
Text Symbol: 050 = First payroll period
Text Symbol: 042 = Period
Text Symbol: 041 = Current Period
Text Symbol: 035 = Reason 3: Cost assignment data contains errors
Text Symbol: 034 = Too many personnel nos. cannot be locked; list ended at
Text Symbol: 033 = List of skipped personnel nos. (reason 2)
Text Symbol: 032 = Reason 2: unsuccessful ENQUEUE, no. of skipped personnel nos. :
Text Symbol: 031 = Reason 1: insufficient authorization, no. skipped personnel nos.:
Text Symbol: 030 = Personnel numbers skipped by the database driver
Text Symbol: 026 = no access path exists
Text Symbol: 025 = For search help
Text Symbol: 022 = Value sets are allowed only for entry fields ( >T599X)
Text Symbol: 019 = PNPTIMED not together with PNPXABKR,PNPPABRJ,PNPPABRP
Text Symbol: 018 = PNPTIMED only allows
Text Symbol: 015 = only allowed after
Text Symbol: 014 = is not allowed because field in table PSHDR
Text Symbol: 013 = is not a field in infotype 0001
Text Symbol: 012 = is a delimeter between fields but is not allowed as a field name
Text Symbol: 008 = Enter payroll year
Text Symbol: 007 = Enter payroll area and payroll year
Text Symbol: 006 = Enter payroll period



Text Symbol: 003 = Choose selection fields
Text Symbol: 002 = Selection options
Text Symbol: 001 = Selected personnel numbers
Text Symbol: DDK = Key Date
Text Symbol: ZP2 = Other period
Text Symbol: ZP1 = Current period
Text Symbol: Z27 = Other keydate
Text Symbol: Z26 = Other period
Text Symbol: Z25 = From today
Text Symbol: Z24 = Up to today
Text Symbol: Z23 = Current year
Text Symbol: Z22 = Current month
Text Symbol: Z21 = Today
Text Symbol: YTI = Period
Text Symbol: YTE = Technical selections
Text Symbol: YPY = Payroll-specific selections
Text Symbol: YIP = Other periods
Text Symbol: YEV = Use CD evaluations on in periods
Text Symbol: YCU = Current period
Text Symbol: YB3 = Periods
Text Symbol: YB2 = Selections
Text Symbol: YB1 = Period
Text Symbol: YA2 = Switch off archive access
Text Symbol: YA1 = Switch on archive access
Text Symbol: Y11 = Employee
Text Symbol: Y10 = Period
Text Symbol: Y04 = General employee selectio
Text Symbol: Y03 = Employee
Text Symbol: Y02 = General time selection
Text Symbol: Y01 = Period
Text Symbol: VON = from
Text Symbol: PNP = Selection screen on infotypes
Text Symbol: PAY = Selection screen on payroll results
Text Symbol: P40 = Org. structure
Text Symbol: P30 = Sort order
Text Symbol: P21 = Search help &
Text Symbol: P20 = Search helps
Text Symbol: P11 = Further selections
Text Symbol: P10 = Selections from
Text Symbol: FSL = Dynamic Selections
Text Symbol: DPS = Person selection period
Text Symbol: DPE = Payroll area


INCLUDES used within this REPORT SAPDBPNP

INCLUDE . " CONSTANTS FOR ICONS
INCLUDE DBPNP_PNPCE_COMMON_FORMS.
INCLUDE DBPNP_PNPCE_PLAN_FORMS.
INCLUDE DBPNP_PNPCE_AUTH_FORMS.
INCLUDE DBPNP_PNPCE_F4_FORMS.
INCLUDE DBPNP_PNPCE_LOG_FORMS.


TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

No SAP FUNCTION MODULES are executed within this report code!



Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name SAPDBPNP or its description.