C_ProdAllocSqncMngCapGrpTWD

DDL: C_PRODALLOCSQNCMNGCAPGRPTWD Type: view_entity CONSUMPTION

Manage Product Allocation Sequences Capacity Group - Text

C_ProdAllocSqncMngCapGrpTWD is a Consumption CDS View that provides data about "Manage Product Allocation Sequences Capacity Group - Text" in SAP S/4HANA. It reads from 1 data source (I_ProdAllocSqncGroupTTP) and exposes 6 fields with key fields ProdAllocSequenceGroupUUID, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdAllocSqncGroupTTP I_ProdAllocSqncGroupTTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_ProdAllocSqncMngCapGrpWD _ProdAllocSqncGroupTP _ProdAllocSqncGroupTP.ProdAllocSequenceGroupUUID = $projection.ProdAllocSequenceGroupUUID

Annotations (10)

NameValueLevelField
EndUserText.label Manage Product Allocation Sequences Capacity Group - Text view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
UI.headerInfo.typeName Product Allocation Sequence Capacity Group Text view
UI.headerInfo.typeNamePlural Product Allocation Sequence Capacity Group Texts view
UI.headerInfo.title.label Product Allocation Sequence Capacity Group Texts view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocSequenceGroupUUID ProdAllocSequenceGroupUUID Product Allocation Sequence Group UUID
KEY Language Language Report Text Language
ProductAllocationSequenceUUID ProductAllocationSequenceUUID Product Allocation Sequence UUID
ProdAllocSequenceGroupDesc ProdAllocSequenceGroupDesc Description
_ProdAllocSqncGroupTP _ProdAllocSqncGroupTP
_Language _Language

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 C_ProdAllocSqncMngCapGrpTWD.
-- 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.

CREATE VIEW C_ProdAllocSqncMngCapGrpTWD AS
SELECT
  ProdAllocSequenceGroupUUID,
  Language,
  ProductAllocationSequenceUUID,
  ProdAllocSequenceGroupDesc
FROM I_ProdAllocSqncGroupTTP
LEFT OUTER JOIN C_ProdAllocSqncMngCapGrpWD AS _ProdAllocSqncGroupTP ON _ProdAllocSqncGroupTP.ProdAllocSequenceGroupUUID = ProdAllocSequenceGroupUUID  -- association [1..1]
;