C_DeliveryNoteItem

DDL: C_DELIVERYNOTEITEM SQL: CDELVNOTEITM Type: view CONSUMPTION
36 Fields 1 Data Sources 3 Associations

Consumption view for Delivery Note Item

C_DeliveryNoteItem is a Consumption CDS View that provides data about "Consumption view for Delivery Note Item" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 36 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_DeliveryDocument _DeliveryDocument $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
[0..1] I_SalesDocumentItem _ReferenceSalesDocumentItem $projection.ReferenceSDDocument = _ReferenceSalesDocumentItem.SalesDocument and $projection.ReferenceSDDocumentItem = _ReferenceSalesDocumentItem.SalesDocumentItem and $projection.ReferenceSDDocumentCategory = 'C'
[0..1] I_MaterialType _MaterialType $projection.MaterialTypePrimary = _MaterialType.MaterialType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDELVNOTEITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view for Delivery Note Item view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private false view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
TransactionCurrency _ReferenceSalesDocumentItem TransactionCurrency Transaction Currency
NetPriceAmount
NetValueAmount
Material Material Vehicle Model
MaterialByCustomer MaterialByCustomer Customer Mat.
ItemGrossWeight ItemGrossWeight Gross Weight
ItemNetWeight ItemNetWeight Net Weight
ItemWeightUnit ItemWeightUnit Unit of Weight
ItemVolume ItemVolume Volume
ItemVolumeUnit ItemVolumeUnit Volume Unit
ActualDeliveryQuantity ActualDeliveryQuantity Base quantity
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
Batch Batch Lot No.
HigherLvlItmOfBatSpltItm HigherLvlItmOfBatSpltItm HghLevItmBatch
PartnerSalesDocument
PartnerSalesDocumentItem
PurchaseOrderByCustomer _ReferenceSalesDocumentItem PurchaseOrderByCustomer Purchase Order Number
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem ReferenceSDDocumentItem Reference Item
ReferenceSDDocumentCategory ReferenceSDDocumentCategory Prec.Doc.Categ.
MaterialTypePrimary MaterialTypePrimary Product Type
CustEngineeringChgStatus CustEngineeringChgStatus Engin. Change
_DeliveryDocument _DeliveryDocument
_ReferenceSalesDocumentItem _ReferenceSalesDocumentItem
_Plant _Plant
_StorageLocation _StorageLocation
_Material _Material
_SalesDocument
_SalesDocumentItem
_MaterialType _MaterialType
_ItemWeightUnit _ItemWeightUnit
_ItemVolumeUnit _ItemVolumeUnit

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_DeliveryNoteItem.
-- 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.
-- SQL view name: CDELVNOTEITM

CREATE VIEW C_DeliveryNoteItem AS
SELECT
  DeliveryDocument,
  DeliveryDocumentItem,
  _ReferenceSalesDocumentItem.TransactionCurrency AS TransactionCurrency,
  cast ( div ( _ReferenceSalesDocumentItem.NetAmount , _ReferenceSalesDocumentItem.OrderQuantity ) as abap.dec( 11, 2 )) AS NetPriceAmount,
  ActualDeliveryQuantity * div ( _ReferenceSalesDocumentItem.NetAmount , _ReferenceSalesDocumentItem.OrderQuantity ) AS NetValueAmount,
  Material,
  MaterialByCustomer,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ActualDeliveryQuantity,
  DeliveryQuantityUnit,
  Batch,
  HigherLvlItmOfBatSpltItm,
  _ReferenceSalesDocumentItem._Partner.SalesDocument AS PartnerSalesDocument,
  _ReferenceSalesDocumentItem._Partner.SalesDocumentItem AS PartnerSalesDocumentItem,
  _ReferenceSalesDocumentItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  Plant,
  StorageLocation,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  MaterialTypePrimary,
  CustEngineeringChgStatus,
  _ReferenceSalesDocumentItem._Partner._SalesDocument AS _SalesDocument,
  _ReferenceSalesDocumentItem._Partner._SalesDocumentItem AS _SalesDocumentItem
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _ReferenceSalesDocumentItem ON ReferenceSDDocument = _ReferenceSalesDocumentItem.SalesDocument AND ReferenceSDDocumentItem = _ReferenceSalesDocumentItem.SalesDocumentItem AND ReferenceSDDocumentCategory = 'C'  -- association [0..1]
LEFT OUTER JOIN I_MaterialType AS _MaterialType ON MaterialTypePrimary = _MaterialType.MaterialType  -- association [0..1]
;

Learn More