I_SupProtSitnDocItemDet

DDL: I_SUPPROTSITNDOCITEMDET Type: view COMPOSITE
37 Fields 2 Data Sources 3 Associations

Document Item Details for Situations

I_SupProtSitnDocItemDet is a Composite CDS View that provides data about "Document Item Details for Situations" in SAP S/4HANA. It reads from 2 data sources (I_SupProtSitnNrOfObjByDocItem, I_SupProtSitnNrOfObjByDocItem) and exposes 37 fields with key field SupProtPermConsumptionUUID. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SupProtSitnNrOfObjByDocItem I_SupProtSitnNrOfObjByDocItem from
I_SupProtSitnNrOfObjByDocItem I_SupProtSitnNrOfObjByDocItem union_all

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SupProtSitnPermConsumption _SupProtSitnPermConsumption $projection.SupplyProtectionDocumentType = _SupProtSitnPermConsumption.SupplyProtectionDocumentType and $projection.SupProtAssignedDocument = _SupProtSitnPermConsumption.SupProtAssignedDocument and $projection.SupProtAssignedDocumentItem = _SupProtSitnPermConsumption.SupProtAssignedDocumentItem
[1..1] I_SalesDocumentItem _SalesDocumentItem $projection.SupProtAssignedDocument = _SalesDocumentItem.SalesDocument and $projection.SupProtAssignedDocumentItem = _SalesDocumentItem.SalesDocumentItem
[0..1] I_PurchasingDocumentItem _PurchasingDocumentItem I_SupProtSitnNrOfObjByDocItem.SupProtAssignedDocument = _PurchasingDocumentItem.PurchasingDocument and I_SupProtSitnNrOfObjByDocItem.SupProtAssignedDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem

Annotations (11)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISUPSIDOCITD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Document Item Details for Situations view
Metadata.ignorePropagatedAnnotations true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY SupProtPermConsumptionUUID _SupProtSitnPermConsumption SupProtPermConsumptionUUID
SupplyProtectionUUID _SupProtSitnPermConsumption SupplyProtectionUUID UUID
Material _SupProtSitnPermConsumption Material Vehicle Model
Plant _SupProtSitnPermConsumption Plant Valuation Area
SupplyProtectionName _SupProtSitnPermConsumption SupplyProtectionName
MaterialGroup _SalesDocumentItem MaterialGroup Product Group
SalesDistrict _SalesDocumentItem SalesDistrict Sales District
SalesOrganization _SalesDocumentItem SalesOrganization Sales Organization
DistributionChannel _SalesDocumentItem DistributionChannel RefDistCh-Cust/Mat.
Division _SalesDocumentItem Division Org. Division
CompanyCode Receiver Company Code
CustomerGroup _SalesDocumentItem CustomerGroup Customer Group
DeliveryGroup _SalesDocumentItem DeliveryGroup Delivery Group
SoldToParty Sold-to Party
ShipToParty Ship-To Party (obsolete)
SupProtNumberOfObjects SupProtNumberOfObjects
SupProtAssignedDocument SupProtAssignedDocument
SupProtAssignedDocumentItem SupProtAssignedDocumentItem
SupProtPermConsumptionUUID
SupplyProtectionUUID _SupProtSitnPermConsumption SupplyProtectionUUID UUID
Material _SupProtSitnPermConsumption Material Vehicle Model
Plant _SupProtSitnPermConsumption Plant Valuation Area
SupplyProtectionName _SupProtSitnPermConsumption SupplyProtectionName
MaterialGroup _PurchasingDocumentItem MaterialGroup Product Group
SalesDistrict _SupDmndSalesArea SalesDistrict Sales District
SalesOrganization _Shipping SalesOrganization Sales Organization
DistributionChannel _Shipping DistributionChannel RefDistCh-Cust/Mat.
Division _Shipping OrganizationDivision Org. Division
CompanyCode _PurchasingDocumentItem CompanyCode Receiver Company Code
CustomerGroup _SupDmndSalesArea CustomerGroup Customer Group
DeliveryGroup Delivery Group
SoldToParty _Shipping SoldToParty Sold-to Party
ShipToParty _Shipping ShipToParty Ship-To Party (obsolete)
SupProtNumberOfObjects I_SupProtSitnNrOfObjByDocItem SupProtNumberOfObjects
SupProtAssignedDocument I_SupProtSitnNrOfObjByDocItem SupProtAssignedDocument
SupProtAssignedDocumentItem I_SupProtSitnNrOfObjByDocItem SupProtAssignedDocumentItem
SupplyProtectionDocumentType I_SupProtSitnNrOfObjByDocItem SupplyProtectionDocumentType

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_SupProtSitnDocItemDet.
-- 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_SupProtSitnDocItemDet AS
SELECT
  _SupProtSitnPermConsumption.SupProtPermConsumptionUUID AS SupProtPermConsumptionUUID,
  _SupProtSitnPermConsumption.SupplyProtectionUUID AS SupplyProtectionUUID,
  _SupProtSitnPermConsumption.Material AS Material,
  _SupProtSitnPermConsumption.Plant AS Plant,
  _SupProtSitnPermConsumption.SupplyProtectionName AS SupplyProtectionName,
  _SalesDocumentItem.MaterialGroup AS MaterialGroup,
  _SalesDocumentItem.SalesDistrict AS SalesDistrict,
  _SalesDocumentItem.SalesOrganization AS SalesOrganization,
  _SalesDocumentItem.DistributionChannel AS DistributionChannel,
  _SalesDocumentItem.Division AS Division,
  _SalesDocumentItem._SalesDocument.BillingCompanyCode AS CompanyCode,
  _SalesDocumentItem.CustomerGroup AS CustomerGroup,
  _SalesDocumentItem.DeliveryGroup AS DeliveryGroup,
  _SalesDocumentItem._SalesDocument._StandardPartner.SoldToParty AS SoldToParty,
  _SalesDocumentItem._SalesDocument._StandardPartner.ShipToParty AS ShipToParty,
  SupProtNumberOfObjects,
  SupProtAssignedDocument,
  SupProtAssignedDocumentItem,
  I_SupProtSitnNrOfObjByDocItem.SupplyProtectionDocumentType AS SupplyProtectionDocumentType
FROM I_SupProtSitnNrOfObjByDocItem
LEFT OUTER JOIN I_SupProtSitnPermConsumption AS _SupProtSitnPermConsumption ON SupplyProtectionDocumentType = _SupProtSitnPermConsumption.SupplyProtectionDocumentType AND SupProtAssignedDocument = _SupProtSitnPermConsumption.SupProtAssignedDocument AND SupProtAssignedDocumentItem = _SupProtSitnPermConsumption.SupProtAssignedDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SupProtAssignedDocument = _SalesDocumentItem.SalesDocument AND SupProtAssignedDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON I_SupProtSitnNrOfObjByDocItem.SupProtAssignedDocument = _PurchasingDocumentItem.PurchasingDocument AND I_SupProtSitnNrOfObjByDocItem.SupProtAssignedDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SupProtSitnNrOfObjByDocItem
;

Learn More