I_SupProtPermConsumptionTP

DDL: I_SUPPROTPERMCONSUMPTIONTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 3 Associations

Supply Protection Perm Consumed Prot

I_SupProtPermConsumptionTP is a Transactional CDS View that provides data about "Supply Protection Perm Consumed Prot" in SAP S/4HANA. It reads from 1 data source (I_SupProtPermConsumption) and exposes 16 fields with key field SupProtPermConsumptionUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SupProtPermConsumption I_SupProtPermConsumption from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SupplyProtectionTimeBucketTP _SupplyProtectionTimeBucketTP $projection.SupProtTimeBucketUUID = _SupplyProtectionTimeBucketTP.SupProtTimeBucketUUID
[1..1] I_SupplyProtectionTP _SupplyProtectionTP $projection.SupplyProtectionUUID = _SupplyProtectionTP.SupplyProtectionUUID
[1..*] I_ATPRlvtDocumentCategoryText _ATPRlvtDocumentCategoryText $projection.SupplyProtectionDocumentType = _ATPRlvtDocumentCategoryText.ATPRelevantDocumentCategory

Annotations (7)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Supply Protection Perm Consumed Prot view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SupProtPermConsumptionUUID SupProtPermConsumptionUUID Waste Partner UUID
SupProtTimeBucketUUID SupProtTimeBucketUUID Time Bucket UUID
SupplyProtectionDocumentType SupplyProtectionDocumentType Order Type
SupProtAssignedDocument SupProtAssignedDocument Routing slip doc. ID
SupProtAssignedDocumentItem SupProtAssignedDocumentItem DocumentItem ID
ATPRelevantDocScheduleLine ATPRelevantDocScheduleLine Scheduling
SupProtConsumedQuantity SupProtConsumedQuantity Consumed Quantity
SupProtConsumedQuantityUnit SupProtConsumedQuantityUnit Unit for Cons. Prot.
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
SupplyProtectionUUID _SupplyProtectionTimeBucketTP SupplyProtectionUUID UUID
_SupplyProtectionTP _SupplyProtectionTP
_SupplyProtectionTimeBucketTP _SupplyProtectionTimeBucketTP
_ATPRlvtDocumentCategoryText _ATPRlvtDocumentCategoryText

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_SupProtPermConsumptionTP.
-- 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_SupProtPermConsumptionTP AS
SELECT
  SupProtPermConsumptionUUID,
  SupProtTimeBucketUUID,
  SupplyProtectionDocumentType,
  SupProtAssignedDocument,
  SupProtAssignedDocumentItem,
  ATPRelevantDocScheduleLine,
  SupProtConsumedQuantity,
  SupProtConsumedQuantityUnit,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  _SupplyProtectionTimeBucketTP.SupplyProtectionUUID AS SupplyProtectionUUID
FROM I_SupProtPermConsumption
LEFT OUTER JOIN I_SupplyProtectionTimeBucketTP AS _SupplyProtectionTimeBucketTP ON SupProtTimeBucketUUID = _SupplyProtectionTimeBucketTP.SupProtTimeBucketUUID  -- association [1..1]
LEFT OUTER JOIN I_SupplyProtectionTP AS _SupplyProtectionTP ON SupplyProtectionUUID = _SupplyProtectionTP.SupplyProtectionUUID  -- association [1..1]
LEFT OUTER JOIN I_ATPRlvtDocumentCategoryText AS _ATPRlvtDocumentCategoryText ON SupplyProtectionDocumentType = _ATPRlvtDocumentCategoryText.ATPRelevantDocumentCategory  -- association [1..*]
;

Learn More