HRPY_PCC_TPY_EVP

DDL: HRPY_PCC_TPY_EVP SQL: HRPY_PCC_TE Type: view
38 Fields 5 Data Sources

PCC Evaluation Period for Test Payroll

HRPY_PCC_TPY_EVP is a CDS View that provides data about "PCC Evaluation Period for Test Payroll" in SAP S/4HANA. It reads from 5 data sources (t52ocrt, t52ocrt, p2rx_eval_period, p2rx_tpy_eval_p, p2rx_tpy_eval_p) and exposes 38 fields with key fields pernr, seqnr, iabkrs, inper, ipend.

Data Sources (5)

SourceAliasJoin Type
t52ocrt oc_reason_text left_outer
t52ocrt oc_reason_text_1 left_outer
p2rx_eval_period p2rx_eval_period union
p2rx_tpy_eval_p p2rx_tpy_eval_p from
p2rx_tpy_eval_p p2rx_tpy_eval_p left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName HRPY_PCC_TE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PCC Evaluation Period for Test Payroll view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY pernr p2rx_tpy_eval_p dct_pernr Personnel No.
KEY seqnr p2rx_tpy_eval_p dct_seqnr Sequence Number
KEY iabkrs p2rx_tpy_eval_p iabkrs Payroll area
KEY inper p2rx_tpy_eval_p inper In-Period
KEY ipend p2rx_tpy_eval_p ipend In-Period End Date
KEY inpty p2rx_tpy_eval_p inpty Payroll type
KEY inpid p2rx_tpy_eval_p inpid Payroll Identifier
KEY srtza p2rx_tpy_eval_p srtza Indicator: Result
dct_is_tpy p2rx_tpy_eval_p dct_is_tpy Payroll Test Results
abkrs p2rx_tpy_eval_p abkrs Process. group
fpper p2rx_tpy_eval_p fpper For-period for garnishment
fpbeg p2rx_tpy_eval_p fpbeg For-Period Strt D
fpend p2rx_tpy_eval_p fpend For-Period EndD.
payty p2rx_tpy_eval_p payty Payroll type
payid p2rx_tpy_eval_p payid Payroll Identifier
calcd p2rx_tpy_eval_p calcd accounted
void p2rx_tpy_eval_p void Void Komponente
ocrsn payroll_directory ocrsn Off-cycle reas.
ocrtx t52ocrt ocrtx Offcycle reason
KEY seqnr p2rx_eval_period dct_seqnr Sequence Number
KEY iabkrs p2rx_eval_period iabkrs Payroll area
KEY inper p2rx_eval_period inper In-Period
KEY ipend p2rx_eval_period ipend In-Period End Date
KEY inpty p2rx_eval_period inpty Payroll type
KEY inpid p2rx_eval_period inpid Payroll Identifier
KEY srtza p2rx_eval_period srtza Indicator: Result
dct_is_tpy p2rx_tpy_eval_p dct_is_tpy Payroll Test Results
abkrs p2rx_eval_period abkrs Process. group
fpper p2rx_eval_period fpper For-period for garnishment
fpbeg p2rx_eval_period fpbeg For-Period Strt D
fpend p2rx_eval_period fpend For-Period EndD.
payty p2rx_eval_period payty Payroll type
payid p2rx_eval_period payid Payroll Identifier
calcd p2rx_eval_period calcd accounted
void p2rx_eval_period void Void Komponente
ocrsn payroll_directory_1 ocrsn Off-cycle reas.
ocrtx t52ocrt ocrtx Offcycle reason
period_key p2rx_eval_period period_key Period Key

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view HRPY_PCC_TPY_EVP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: HRPY_PCC_TE

CREATE VIEW HRPY_PCC_TPY_EVP AS
SELECT
  p2rx_tpy_eval_p.dct_pernr AS pernr,
  p2rx_tpy_eval_p.dct_seqnr AS seqnr,
  p2rx_tpy_eval_p.iabkrs AS iabkrs,
  p2rx_tpy_eval_p.inper AS inper,
  p2rx_tpy_eval_p.ipend AS ipend,
  p2rx_tpy_eval_p.inpty AS inpty,
  p2rx_tpy_eval_p.inpid AS inpid,
  p2rx_tpy_eval_p.srtza AS srtza,
  p2rx_tpy_eval_p.dct_is_tpy AS dct_is_tpy,
  p2rx_tpy_eval_p.abkrs AS abkrs,
  p2rx_tpy_eval_p.fpper AS fpper,
  p2rx_tpy_eval_p.fpbeg AS fpbeg,
  p2rx_tpy_eval_p.fpend AS fpend,
  p2rx_tpy_eval_p.payty AS payty,
  p2rx_tpy_eval_p.payid AS payid,
  p2rx_tpy_eval_p.calcd AS calcd,
  p2rx_tpy_eval_p.void AS void,
  payroll_directory.ocrsn AS ocrsn,
  oc_reason_text.ocrtx AS ocrtx,
  p2rx_eval_period.period_key AS period_key
FROM p2rx_tpy_eval_p
LEFT OUTER JOIN t52ocrt AS oc_reason_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t52ocrt AS oc_reason_text_1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN p2rx_tpy_eval_p ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): p2rx_eval_period
;

Learn More