C_PT_DeliveryNoteItem

DDL: C_PT_DELIVERYNOTEITEM SQL: CPTDELITEM Type: view CONSUMPTION

PT Delivery Note Form Item

C_PT_DeliveryNoteItem is a Consumption CDS View that provides data about "PT Delivery Note Form Item" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 9 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaterialText _mattext $projection.Material = _mattext.Material

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPTDELITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PT Delivery Note Form Item view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
KEY DeliveryDocumentItem DeliveryDocumentItem
Material Material
ActualDeliveryQuantity ActualDeliveryQuantity
BaseUnit BaseUnit
ItemGrossWeight ItemGrossWeight
ItemWeightUnit ItemWeightUnit
MaterialName _mattext MaterialName
InternationalArticleNumber InternationalArticleNumber 
@AbapCatalog.sqlViewName: 'CPTDELITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'PT Delivery Note Form Item'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
define view C_PT_DeliveryNoteItem as select from I_DeliveryDocumentItem
association [1..1] to I_MaterialText as _mattext on $projection.Material = _mattext.Material
{
//I_DeliveryDocumentItem 

key DeliveryDocument, 
key DeliveryDocumentItem, 
Material,
ActualDeliveryQuantity,
BaseUnit,
ItemGrossWeight,
ItemWeightUnit,
_mattext.MaterialName,
InternationalArticleNumber
}
where _mattext.Language = 'E'

Learn More