C_DeliveryNote

DDL: C_DELIVERYNOTE SQL: CDELVNOTE Type: view CONSUMPTION Package: GLO_LOG_GEN

Delivery Note

C_DeliveryNote is a Consumption CDS View that provides data about "Delivery Note" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 33 fields with key field DeliveryDocument. It has 4 associations to related views. Part of development package GLO_LOG_GEN.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument _DeliveryDocument from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_Customer _SoldToParty $projection.SoldToParty = _SoldToParty.Customer
[0..1] I_Customer _ShipToParty $projection.ShipToParty = _ShipToParty.Customer
[1..*] C_DeliveryNoteItem _DeliveryNoteItem $projection.DeliveryDocument = _DeliveryNoteItem.DeliveryDocument

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CDELVNOTE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Delivery Note view
VDM.viewType #CONSUMPTION view
VDM.private false view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.status #DEPRECATED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
CreationDate CreationDate
DeliveryDate DeliveryDate
ReferenceDocumentNumber ReferenceDocumentNumber
Supplier Supplier
GoodsIssueOrReceiptSlipNumber GoodsIssueOrReceiptSlipNumber
SoldToParty SoldToParty
ShipToParty ShipToParty
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
ShippingPoint ShippingPoint
ProposedDeliveryRoute ProposedDeliveryRoute
BillOfLading BillOfLading
ShippingCondition ShippingCondition
HeaderGrossWeight HeaderGrossWeight
HeaderNetWeight HeaderNetWeight
HeaderWeightUnit HeaderWeightUnit
HeaderVolume HeaderVolume
HeaderVolumeUnit HeaderVolumeUnit
ActualGoodsMovementDate ActualGoodsMovementDate
SpecialProcessingCode SpecialProcessingCode
DeliveryPriority DeliveryPriority
IsExportDelivery IsExportDelivery
_Supplier _Supplier
_SoldToParty _SoldToParty
_DeliveryNoteItem _DeliveryNoteItem
_ShippingPoint _ShippingPoint
_ShipToParty _ShipToParty
_ProposedDeliveryRoute _ProposedDeliveryRoute
_ShippingCondition _ShippingCondition
_DeliveryPriority _DeliveryPriority
_SpecialProcessingCode _SpecialProcessingCode
_IncotermsClassification _IncotermsClassification 
@AbapCatalog.sqlViewName: 'CDELVNOTE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Delivery Note'
@VDM:
      {
        viewType: #CONSUMPTION,
        private: false
      }
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking:#REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.status: #DEPRECATED
define view C_DeliveryNote
  as select from I_DeliveryDocument as _DeliveryDocument
  association [0..1] to I_Supplier  as _Supplier on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_Customer  as _SoldToParty  on  $projection.SoldToParty = _SoldToParty.Customer
  association [0..1] to I_Customer as _ShipToParty on $projection.ShipToParty = _ShipToParty.Customer
  association [1..*] to C_DeliveryNoteItem as _DeliveryNoteItem on $projection.DeliveryDocument = _DeliveryNoteItem.DeliveryDocument
   
{

   key DeliveryDocument,
       CreationDate,
       DeliveryDate,
       ReferenceDocumentNumber,
       Supplier,
       GoodsIssueOrReceiptSlipNumber,
       SoldToParty,
       ShipToParty,
       IncotermsClassification,
       IncotermsTransferLocation,
       ShippingPoint,
       ProposedDeliveryRoute,
       BillOfLading,
       ShippingCondition,
       HeaderGrossWeight,
       HeaderNetWeight,
       HeaderWeightUnit,
       HeaderVolume,
       HeaderVolumeUnit,
       ActualGoodsMovementDate,
       SpecialProcessingCode,
       DeliveryPriority,
       IsExportDelivery,
      _Supplier,
      _SoldToParty,
      _DeliveryNoteItem,
      _ShippingPoint,
      _ShipToParty,
      _ProposedDeliveryRoute,
      _ShippingCondition,
      _DeliveryPriority,
      _SpecialProcessingCode,
      _IncotermsClassification    
}

Learn More