SBN_DRF_SUB_PI

DDL: SBN_DRF_SUB_PI SQL: SBN_SUB_PI Type: view
4 Fields 1 Data Sources

Get Parent PI

SBN_DRF_SUB_PI is a CDS View that provides data about "Get Parent PI" in SAP S/4HANA. It reads from 1 data source (packpo) and exposes 4 fields.

Data Sources (1)

SourceAliasJoin Type
packpo packpo from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SBN_SUB_PI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Get Parent PI view

Fields (4)

KeyFieldSource TableSource FieldDescription
packitemid packitemid PObItem ID
itcount itcount Numerator
packnr packnr Text number
subpacknr subpacknr Packing object

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 SBN_DRF_SUB_PI.
-- 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: SBN_SUB_PI

CREATE VIEW SBN_DRF_SUB_PI AS
SELECT
  packitemid,
  itcount,
  packnr,
  subpacknr
FROM packpo
;

Learn More