C_SupAssgmtSitnOrdDet

DDL: C_SUPASSGMTSITNORDDET Type: view CONSUMPTION
21 Fields 1 Data Sources 2 Associations

Order item details for situations

C_SupAssgmtSitnOrdDet is a Consumption CDS View that provides data about "Order item details for situations" in SAP S/4HANA. It reads from 1 data source (I_SupAssgmtSitnOrdItemDet) and exposes 21 fields with key fields RequirementDocumentNumber, RequirementDocumentItem, RequirementType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SupAssgmtSitnOrdItemDet I_SupAssgmtSitnOrdItemDet from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentItem _SalesDocument $projection.RequirementDocumentNumber = _SalesDocument.SalesDocument and $projection.RequirementDocumentItem = _SalesDocument.SalesDocumentItem and ( $projection.RequirementType = 'VC' or $projection.RequirementType = 'VJ' or $projection.RequirementType = 'VI' )
[1..1] I_PurchasingDocumentItem _PurchasingDocument $projection.RequirementDocumentNumber = _PurchasingDocument.PurchasingDocument and $projection.PurchasingDocumentItem = _PurchasingDocument.PurchasingDocumentItem and $projection.RequirementType = 'U1'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSUPASSGMTSITU view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.uniqueIdField ARunDocumentItemUniqueID view
EndUserText.label Order item details for situations view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY RequirementDocumentNumber RequirementDocumentNumber Requirement Document Number
KEY RequirementDocumentItem RequirementDocumentItem Requirement Document Item
KEY RequirementType RequirementType Requirement Type
ARunDocumentItemUniqueID ARunDocumentItemUniqueID ARun Document ID
OrderType OrderType Order Type
Material Material Product
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
SalesDistrict SalesDistrict Sales District
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CompanyCode CompanyCode Company Code
CustomerGroup CustomerGroup Customer Group
FashionCancelDate FashionCancelDate Fashion Cancellation Date
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
DeliveryGroup DeliveryGroup Delivery Group
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
_SalesDocument _SalesDocument
_PurchasingDocument _PurchasingDocument

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_SupAssgmtSitnOrdDet.
-- 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_SupAssgmtSitnOrdDet AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequirementType,
  ARunDocumentItemUniqueID,
  OrderType,
  Material,
  MaterialGroup,
  Plant,
  SalesDistrict,
  SalesOrganization,
  DistributionChannel,
  Division,
  CompanyCode,
  CustomerGroup,
  FashionCancelDate,
  SoldToParty,
  ShipToParty,
  DeliveryGroup,
  PurchasingDocumentItem
FROM I_SupAssgmtSitnOrdItemDet
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocument ON RequirementDocumentNumber = _SalesDocument.SalesDocument AND RequirementDocumentItem = _SalesDocument.SalesDocumentItem AND ( RequirementType = 'VC' OR RequirementType = 'VJ' OR RequirementType = 'VI' )  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocument ON RequirementDocumentNumber = _PurchasingDocument.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocument.PurchasingDocumentItem AND RequirementType = 'U1'  -- association [1..1]
;

Learn More