C_SupProtSitnDocItemDet

DDL: C_SUPPROTSITNDOCITEMDET Type: view_entity CONSUMPTION
19 Fields 1 Data Sources

Document Item Details for Situations

C_SupProtSitnDocItemDet is a Consumption CDS View that provides data about "Document Item Details for Situations" in SAP S/4HANA. It reads from 1 data source (I_SupProtSitnDocItemDet) and exposes 19 fields with key field SupProtPermConsumptionUUID.

Data Sources (1)

SourceAliasJoin Type
I_SupProtSitnDocItemDet I_SupProtSitnDocItemDet from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.uniqueIdField SupProtPermConsumptionUUID view
EndUserText.label Document Item Details for Situations view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SupProtPermConsumptionUUID SupProtPermConsumptionUUID
SupplyProtectionUUID SupplyProtectionUUID UUID
SupProtAssignedDocument SupProtAssignedDocument
SupProtAssignedDocumentItem SupProtAssignedDocumentItem
SupplyProtectionDocumentType SupplyProtectionDocumentType
SupProtNumberOfObjects SupProtNumberOfObjects
SupplyProtectionName
Material Material Vehicle Model
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 Receiver Company Code
CustomerGroup CustomerGroup Customer Group
DeliveryGroup DeliveryGroup Delivery Group
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)

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_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 C_SupProtSitnDocItemDet AS
SELECT
  SupProtPermConsumptionUUID,
  SupplyProtectionUUID,
  SupProtAssignedDocument,
  SupProtAssignedDocumentItem,
  SupplyProtectionDocumentType,
  SupProtNumberOfObjects,
  cast( SupplyProtectionName as sup_object_short_name ) AS SupplyProtectionName,
  Material,
  MaterialGroup,
  Plant,
  SalesDistrict,
  SalesOrganization,
  DistributionChannel,
  Division,
  CompanyCode,
  CustomerGroup,
  DeliveryGroup,
  SoldToParty,
  ShipToParty
FROM I_SupProtSitnDocItemDet
;

Learn More