I_AltvBsdConfRmngQtyAssgmt

DDL: I_ALTVBSDCONFRMNGQTYASSGMT Type: view_entity BASIC Package: ATP_ABC_SUBSTITUTION_STRATEGY
6 Fields 1 Data Sources 1 Associations

Remaining Requirement Quantity Assignment

I_AltvBsdConfRmngQtyAssgmt is a Basic CDS View that provides data about "Remaining Requirement Quantity Assignment" in SAP S/4HANA. It reads from 1 data source (abcrgqtyassgmt) and exposes 6 fields with key field AltvBsdConfRmngQtyAssgmtUUID. It has 1 association to related views. Part of development package ATP_ABC_SUBSTITUTION_STRATEGY.

Data Sources (1)

SourceAliasJoin Type
abcrgqtyassgmt abcrgqtyassgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AltvBsdConfSubstnStrgy _Strategy $projection.AltvBsdConfSubstnStrgyUUID = _Strategy.AltvBsdConfSubstnStrgyUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Remaining Requirement Quantity Assignment view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
ObjectModel.representativeKey AltvBsdConfRmngQtyAssgmtUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Analytics.technicalName IRMNGQTY view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AltvBsdConfRmngQtyAssgmtUUID altvbsdconfrmngqtyassgmtuuid UUID of the assignment of remaining requirement quantity
AltvBsdConfSubstnStrgyUUID altvbsdconfsubstnstrgyuuid Substitution Strategy UUID
OrdinalNumberValue ordinalnumbervalue Ordinal Number
AltvBsdConfRmngQtyAssgmtMode altvbsdconfrmngqtyassgmtmode Rmng Qty Assgmt Mode
AltvConfRmngQtyAssgmtModeName altvconfrmngqtyassgmtmodename Rmng Qty Assgmt Mode
_Strategy _Strategy

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 I_AltvBsdConfRmngQtyAssgmt.
-- 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 I_AltvBsdConfRmngQtyAssgmt AS
SELECT
  AltvBsdConfRmngQtyAssgmtUUID,
  AltvBsdConfSubstnStrgyUUID,
  OrdinalNumberValue,
  AltvBsdConfRmngQtyAssgmtMode,
  AltvConfRmngQtyAssgmtModeName
FROM abcrgqtyassgmt
LEFT OUTER JOIN I_AltvBsdConfSubstnStrgy AS _Strategy ON AltvBsdConfSubstnStrgyUUID = _Strategy.AltvBsdConfSubstnStrgyUUID  -- association [1..1]
;

Learn More