C_ProdAllocSqncMngCapGrpWD

DDL: C_PRODALLOCSQNCMNGCAPGRPWD Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 2 Associations

Manage Product Allocation Sequences Capacity Group

C_ProdAllocSqncMngCapGrpWD is a Consumption CDS View that provides data about "Manage Product Allocation Sequences Capacity Group" in SAP S/4HANA. It reads from 1 data source (I_ProdAllocSqncGroupTP) and exposes 17 fields with key field ProdAllocSequenceGroupUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdAllocSqncGroupTP I_ProdAllocSqncGroupTP from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_ProdAllocSqncMngCapGrpTWD _ProdAllocSqncGroupTTP _ProdAllocSqncGroupTTP.ProdAllocSequenceGroupUUID = $projection.ProdAllocSequenceGroupUUID and _ProdAllocSqncGroupTTP.Language = $session.system_language
[0..*] C_ProdAllocSqncMngCapCstrtWD _ProdAllocSqncCstrtTP _ProdAllocSqncCstrtTP.ProdAllocSequenceGroupUUID = $projection.ProdAllocSequenceGroupUUID

Annotations (13)

NameValueLevelField
EndUserText.label Manage Product Allocation Sequences Capacity Group view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ProdAllocSequenceGroupUUID view
UI.headerInfo.typeName Capacity Sequence Group view
UI.headerInfo.typeNamePlural Capacity Sequence Groups view
UI.headerInfo.title.label Manage Capacity Sequence Group view
UI.headerInfo.title.value ProductAllocationSequenceGroup view
UI.headerInfo.description.value _ProdAllocSqncGroupTTP.ProdAllocSequenceGroupDesc view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocSequenceGroupUUID ProdAllocSequenceGroupUUID Product Allocation Sequence Group UUID
ProductAllocationSequenceUUID ProductAllocationSequenceUUID Product Allocation Sequence UUID
ProductAllocationSequence ProductAllocationSequence Allocation Sequence
ProdAllocSqncGrpPriorityValue ProdAllocSqncGrpPriorityValue Priority
ProductAllocationSequenceGroup ProductAllocationSequenceGroup Sequence Group
ProdAllocSqncConsumptionUnit _ProdAllocationSequenceTP ProdAllocSqncConsumptionUnit Consumption Unit
ProdAllocSqncGrpCnsmpnUnit ProdAllocSqncGrpCnsmpnUnit Group Consumption Unit
NumberOfBackwardCnsmpnPeriods NumberOfBackwardCnsmpnPeriods Backward Consumption
NumberOfForwardCnsmpnPeriods NumberOfForwardCnsmpnPeriods Forward Consumption
HorizontalConsumptionDirection HorizontalConsumptionDirection Consumption Direction
PastPeriodIsAllowed PastPeriodIsAllowed Past Period Allowed
OnlyOverlappingQtyIsConsumed OnlyOverlappingQtyIsConsumed Consume Overlapping Quantity Only
ProdAllocSequenceGroupType ProdAllocSequenceGroupType Sequence Group Type
IsDeleted IsDeleted TRUE
_ProdAllocSqncGroupTTP _ProdAllocSqncGroupTTP
_ProdAllocSqncCstrtTP _ProdAllocSqncCstrtTP
_ConsumptionUnitOfMeasure _ConsumptionUnitOfMeasure

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_ProdAllocSqncMngCapGrpWD.
-- 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_ProdAllocSqncMngCapGrpWD AS
SELECT
  ProdAllocSequenceGroupUUID,
  ProductAllocationSequenceUUID,
  ProductAllocationSequence,
  ProdAllocSqncGrpPriorityValue,
  ProductAllocationSequenceGroup,
  _ProdAllocationSequenceTP.ProdAllocSqncConsumptionUnit AS ProdAllocSqncConsumptionUnit,
  ProdAllocSqncGrpCnsmpnUnit,
  NumberOfBackwardCnsmpnPeriods,
  NumberOfForwardCnsmpnPeriods,
  HorizontalConsumptionDirection,
  PastPeriodIsAllowed,
  OnlyOverlappingQtyIsConsumed,
  ProdAllocSequenceGroupType,
  IsDeleted
FROM I_ProdAllocSqncGroupTP
LEFT OUTER JOIN C_ProdAllocSqncMngCapGrpTWD AS _ProdAllocSqncGroupTTP ON _ProdAllocSqncGroupTTP.ProdAllocSequenceGroupUUID = ProdAllocSequenceGroupUUID AND _ProdAllocSqncGroupTTP.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ProdAllocSqncMngCapCstrtWD AS _ProdAllocSqncCstrtTP ON _ProdAllocSqncCstrtTP.ProdAllocSequenceGroupUUID = ProdAllocSequenceGroupUUID  -- association [0..*]
;

Learn More