P_ProdAllocCtlgCharcValueUsage

DDL: P_PRODALLOCCTLGCHARCVALUEUSAGE SQL: PCTLGCHARCUS Type: view COMPOSITE
6 Fields 5 Data Sources

P_ProdAllocCtlgCharcValueUsage is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (paobj_charcd, I_ProdAllocCharcMetaDataTP, I_ProdAllocObjCharcValCombn, I_ProdAllocObjCharcValCombn, paobj_cvcd) and exposes 6 fields.

Data Sources (5)

SourceAliasJoin Type
paobj_charcd _ProdAllocCharcMetaDataDraft left_outer
I_ProdAllocCharcMetaDataTP _ProdAllocCharcMetaDataTP left_outer
I_ProdAllocObjCharcValCombn _ProdAllocObjCharcValCombn from
I_ProdAllocObjCharcValCombn _ProdAllocObjCharcValCombn left_outer
paobj_cvcd _ProdAllocObjCharcValCombnD union

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCTLGCHARCUS view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
CharcCatalogPathObjectType
ProductAllocationObject I_ProdAllocCharcMetaDataTP ProductAllocationObject Allocation Object
ProdAllocCharcCtlgPathUUID I_ProdAllocCharcMetaDataTP ProdAllocCharcCtlgPathUUID Product Allocation Characteristic Catalog Path UUID
ProductAllocationObject Allocation Object
ProdAllocCharcCtlgPathUUID paobj_charcd prodalloccharcctlgpathuuid Product Allocation Characteristic Catalog Path UUID
prodalloccharc10endasProdAllocCharc

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 P_ProdAllocCtlgCharcValueUsage.
-- 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: PCTLGCHARCUS

CREATE VIEW P_ProdAllocCtlgCharcValueUsage AS
SELECT
  cast( '01' as characcatalogpathobjecttype ) AS CharcCatalogPathObjectType,
  _ProdAllocCharcMetaDataTP.ProductAllocationObject AS ProductAllocationObject,
  _ProdAllocCharcMetaDataTP.ProdAllocCharcCtlgPathUUID AS ProdAllocCharcCtlgPathUUID,
  case when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC01' then _ProdAllocObjCharcValCombnD.prodalloccharc01 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC02' then _ProdAllocObjCharcValCombnD.prodalloccharc02 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC03' then _ProdAllocObjCharcValCombnD.prodalloccharc03 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC04' then _ProdAllocObjCharcValCombnD.prodalloccharc04 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC05' then _ProdAllocObjCharcValCombnD.prodalloccharc05 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC06' then _ProdAllocObjCharcValCombnD.prodalloccharc06 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC07' then _ProdAllocObjCharcValCombnD.prodalloccharc07 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC08' then _ProdAllocObjCharcValCombnD.prodalloccharc08 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC09' then _ProdAllocObjCharcValCombnD.prodalloccharc09 when _ProdAllocCharcMetaDataDraft.prodalloccharctablecolumnname = 'PRODALLOCCHARC10' then _ProdAllocObjCharcValCombnD.prodalloccharc10 end as ProdAllocCharc AS prodalloccharc10endasProdAllocCharc
FROM I_ProdAllocObjCharcValCombn AS _ProdAllocObjCharcValCombn
LEFT OUTER JOIN I_ProdAllocCharcMetaDataTP AS _ProdAllocCharcMetaDataTP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN paobj_charcd AS _ProdAllocCharcMetaDataDraft ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdAllocObjCharcValCombn AS _ProdAllocObjCharcValCombn ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): paobj_cvcd
;

Learn More