PPH_PICPsRl

DDL: PPH_PICPSRL SQL: PPHPICPSRL Type: view
16 Fields 1 Data Sources

CDS view to mask old view picpsrl

PPH_PICPsRl is a CDS View that provides data about "CDS view to mask old view picpsrl" in SAP S/4HANA. It reads from 1 data source (v_picpsrl) and exposes 16 fields with key fields pickey, piccat, picnum, picpos, counter.

Data Sources (1)

SourceAliasJoin Type
v_picpsrl v_picpsrl from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPHPICPSRL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view to mask old view picpsrl view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY pickey pickey PIC key
KEY piccat piccat PIC category
KEY picnum picnum GrpNo.for PIC
KEY picpos picpos Item no.
KEY counter counter Version
KEY seqnr seqnr Tank ID
KEY datfr datfr Valid from date
KEY inttype inttype Interest Type
KEY piccode piccode Interch code
KEY picgid picgid Generic ID
matnr matnr Vehicle Model
werks werks Receiving Plant
berid berid Single-Character Flag
mrpgr mrpgr MPN-MRP Set
lmatn lmatn Leading part
rdatfr rdatfr Valid from date

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 PPH_PICPsRl.
-- 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: PPHPICPSRL

CREATE VIEW PPH_PICPsRl AS
SELECT
  pickey,
  piccat,
  picnum,
  picpos,
  counter,
  seqnr,
  datfr,
  inttype,
  piccode,
  picgid,
  matnr,
  werks,
  berid,
  mrpgr,
  lmatn,
  rdatfr
FROM v_picpsrl
;

Learn More