I_SupAssgmtSitnOrdItemDet

DDL: I_SUPASSGMTSITNORDITEMDET Type: view COMPOSITE
33 Fields 4 Data Sources 2 Associations

View at Order item details for situation

I_SupAssgmtSitnOrdItemDet is a Composite CDS View that provides data about "View at Order item details for situation" in SAP S/4HANA. It reads from 4 data sources (I_PurchasingDocumentShipping, I_SupDmndSalesArea, I_SalesDocumentItem, I_PurchasingDocumentItem) and exposes 33 fields with key fields RequirementDocumentNumber, RequirementDocumentItem, RequirementDocumentItem, RequirementType. It has 2 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_PurchasingDocumentShipping _Shipping left_outer
I_SupDmndSalesArea _SupDmndSalesArea left_outer
I_SalesDocumentItem I_SalesDocumentItem from
I_PurchasingDocumentItem STO union_all

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SDDocumentCompletePartners vbpa_item_WE SDDocument = SalesDocument and SDDocumentItem = SalesDocumentItem and PartnerFunction = 'WE'
[0..*] I_SDDocumentCompletePartners vbpa_item_AG SDDocument = SalesDocument and SDDocumentItem = SalesDocumentItem and PartnerFunction = 'AG'

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISUPASSGMTSITU 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
EndUserText.label View at Order item details for situation view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY RequirementDocumentNumber SalesDocument SD Document
KEY RequirementDocumentItem SalesDocumentItem Sales Document Item
OrderType _SalesDocument SalesDocumentType Sales Doc. Type
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
SalesDistrict SalesDistrict Sales District
SalesOrganization _SalesDocument SalesOrganization Sales Organization
DistributionChannel _SalesDocument DistributionChannel RefDistCh-Cust/Mat.
Division Division Org. Division
CompanyCode _SalesDocument BillingCompanyCode Receiver Company Code
CustomerGroup CustomerGroup Customer Group
FashionCancelDate FashionCancelDate Cancel Date
SoldToPartyendasSoldToParty
ShipToPartyendasShipToParty
DeliveryGroup DeliveryGroup Delivery Group
KEY RequirementDocumentItem Sales Document Item
KEY RequirementType
OrderType Sales Doc. Type
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Valuation Area
SalesDistrict SalesDistrict Sales District
SalesOrganization I_PurchasingDocumentShipping SalesOrganization Sales Organization
DistributionChannel I_PurchasingDocumentShipping DistributionChannel RefDistCh-Cust/Mat.
Division I_PurchasingDocumentShipping OrganizationDivision Org. Division
CompanyCode CompanyCode Receiver Company Code
CustomerGroup CustomerGroup Customer Group
FashionCancelDate Cancel Date
SoldToParty I_PurchasingDocumentShipping SoldToParty Sold-to Party
ShipToParty I_PurchasingDocumentShipping ShipToParty Ship-To Party (obsolete)
DeliveryGroup Delivery Group
PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item

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_SupAssgmtSitnOrdItemDet.
-- 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_SupAssgmtSitnOrdItemDet AS
SELECT
  SalesDocument AS RequirementDocumentNumber,
  SalesDocumentItem AS RequirementDocumentItem,
  _SalesDocument.SalesDocumentType AS OrderType,
  Material,
  MaterialGroup,
  Plant,
  SalesDistrict,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  Division,
  _SalesDocument.BillingCompanyCode AS CompanyCode,
  CustomerGroup,
  FashionCancelDate,
  case when vbpa_item_AG.Customer is not initial then vbpa_item_AG.Customer else _SalesDocument._StandardPartner.SoldToParty end as SoldToParty AS SoldToPartyendasSoldToParty,
  case when vbpa_item_WE.Customer is not initial then vbpa_item_WE.Customer else _SalesDocument._StandardPartner.ShipToParty end as ShipToParty AS ShipToPartyendasShipToParty,
  DeliveryGroup,
  'U1' AS RequirementType,
  _Shipping.SoldToParty AS SoldToParty,
  _Shipping.ShipToParty AS ShipToParty,
  STO.PurchasingDocumentItem AS PurchasingDocumentItem
FROM I_SalesDocumentItem
LEFT OUTER JOIN I_PurchasingDocumentShipping AS _Shipping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupDmndSalesArea AS _SupDmndSalesArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SDDocumentCompletePartners AS vbpa_item_WE ON SDDocument = SalesDocument AND SDDocumentItem = SalesDocumentItem AND PartnerFunction = 'WE'  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCompletePartners AS vbpa_item_AG ON SDDocument = SalesDocument AND SDDocumentItem = SalesDocumentItem AND PartnerFunction = 'AG'  -- association [0..*]
-- UNION ALL with additional select branch(es): I_PurchasingDocumentItem
;

Learn More