C_PT_DeliveryNote

DDL: C_PT_DELIVERYNOTE SQL: CPTDELIVERYNOTE Type: view CONSUMPTION

PT Delivery Note Form

C_PT_DeliveryNote is a Consumption CDS View that provides data about "PT Delivery Note Form" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 19 fields with key field DeliveryDocument. It has 2 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ShippingConditionText _shipcond $projection.ShippingCondition = _shipcond.ShippingCondition
[1..*] C_PT_DeliveryNoteItem _Delitem $projection.DeliveryDocument = _Delitem.DeliveryDocument

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPTDELIVERYNOTE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label PT Delivery Note Form view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
ShippingCondition ShippingCondition
Language _shipcond Language
SDDocumentCategory SDDocumentCategory
DeliveryDocumentType DeliveryDocumentType
CreationDate CreationDate
CreationTime CreationTime
ShippingPoint ShippingPoint
HeaderGrossWeight HeaderGrossWeight
HeaderNetWeight HeaderNetWeight
DocumentDate DocumentDate
ShipToParty ShipToParty
DeliveryDate DeliveryDate
ActualGoodsMovementDate ActualGoodsMovementDate
ActualGoodsMovementTime ActualGoodsMovementTime
ShippingConditionName _shipcond ShippingConditionName
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
_Delitem _Delitem 
@AbapCatalog.sqlViewName: 'CPTDELIVERYNOTE'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality:#D
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass:#MIXED
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'PT Delivery Note Form'
define view C_PT_DeliveryNote
  as select from I_DeliveryDocument
  association [0..1] to I_ShippingConditionText as _shipcond   on $projection.ShippingCondition = _shipcond.ShippingCondition
  //association [1..*] to I_PT_DigitalSignature   as _Digitalsig on $projection.DeliveryDocument = _Digitalsig.DeliveryDocument

  association [1..*] to C_PT_DeliveryNoteItem   as _Delitem    on $projection.DeliveryDocument = _Delitem.DeliveryDocument
  //and _shipcond.Language = 'E'

{
         //I_DeliveryDocument

  key    DeliveryDocument,
         ShippingCondition,
         _shipcond.Language as Language,
         SDDocumentCategory,
         DeliveryDocumentType,
         CreationDate,
         CreationTime,
         ShippingPoint,
         HeaderGrossWeight,
         HeaderNetWeight,
         DocumentDate,
         ShipToParty,
         DeliveryDate,
         ActualGoodsMovementDate,
         ActualGoodsMovementTime,
         _shipcond.ShippingConditionName,
      //_Digitalsig.CompanyCode,

       //_Digitalsig.Certification,

       //_shipcond.ShippingConditionName as ShippingConditionName

         IncotermsClassification,
         IncotermsTransferLocation,
      _Delitem
}
where
_shipcond.Language = 'E'

Learn More