C_DeliveryItemOutputDetn

DDL: C_DELIVERYITEMOUTPUTDETN SQL: CDLVRYITEMOUTDET Type: view CONSUMPTION

Delivery Item Output Determination

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

1 data source(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_DeliveryDocumentItem _Extension $projection.DeliveryDocument = _Extension.DeliveryDocument and $projection.DeliveryDocumentItem = _Extension.DeliveryDocumentItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDLVRYITEMOUTDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Delivery Item Output Determination view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
DataAging.noAgingRestriction false view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
KEY DeliveryDocumentItem DeliveryDocumentItem
SalesOrganization _DeliveryDocument SalesOrganization
ShippingPoint _DeliveryDocument ShippingPoint
ShipToParty _DeliveryDocument ShipToParty
SoldToParty _DeliveryDocument SoldToParty
DeliveryDocumentType _DeliveryDocument DeliveryDocumentType
OverallGoodsMovementStatus _DeliveryDocument OverallGoodsMovementStatus
OverallPickingStatus _DeliveryDocument OverallPickingStatus
DistributionChannel DistributionChannel
Division Division
MaterialGroup MaterialGroup
Material Material
MaterialByCustomer MaterialByCustomer
MaterialTypePrimary MaterialTypePrimary
SDDocumentCategory SDDocumentCategory
Plant Plant
DeliveryDocumentItemCategory DeliveryDocumentItemCategory
ActiveDepartureCountry
ProposedDeliveryRoute _DeliveryDocument ProposedDeliveryRoute
ShippingCondition _DeliveryDocument ShippingCondition
BaseUnit BaseUnit
DestinationCountry
SalesOffice SalesOffice
SalesGroup SalesGroup
MaterialFreightGroup MaterialFreightGroup
Warehouse Warehouse
LoadingPointForDelivery LoadingPointForDelivery
TransportationGroup TransportationGroup
_DeliveryDocument _DeliveryDocument
_SalesOrganization _DeliveryDocument _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_Material _Material
_MaterialGroup _MaterialGroup
_ShipToParty _DeliveryDocument _ShipToParty
_SoldToParty _DeliveryDocument _SoldToParty
_DeliveryDocumentType _DeliveryDocument _DeliveryDocumentType
_OverallGoodsMovementStatus _DeliveryDocument _OverallGoodsMovementStatus
_OverallPickingStatus _DeliveryDocument _OverallPickingStatus
_Plant _Plant
_ShippingPoint _DeliveryDocument _ShippingPoint
_SDDocumentCategory _SDDocumentCategory
_ItemCategory _ItemCategory 
@AbapCatalog.sqlViewName: 'CDLVRYITEMOUTDET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Delivery Item Output Determination'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@DataAging.noAgingRestriction: false

define view C_DeliveryItemOutputDetn
  as select from I_DeliveryDocumentItem
  association [0..1] to E_DeliveryDocumentItem as _Extension on  $projection.DeliveryDocument     = _Extension.DeliveryDocument
                                                             and $projection.DeliveryDocumentItem = _Extension.DeliveryDocumentItem
{
  key DeliveryDocument,
  key DeliveryDocumentItem,

      _DeliveryDocument.SalesOrganization,
      _DeliveryDocument.ShippingPoint,
      _DeliveryDocument.ShipToParty,
      _DeliveryDocument.SoldToParty,
      _DeliveryDocument.DeliveryDocumentType,
      _DeliveryDocument.OverallGoodsMovementStatus,
      _DeliveryDocument.OverallPickingStatus,

      DistributionChannel,
      Division,
      MaterialGroup,
      Material,
      MaterialByCustomer,
      MaterialTypePrimary,
      SDDocumentCategory,
      Plant,
      DeliveryDocumentItemCategory,
      _DeliveryDocument._ShippingPoint.ActiveDepartureCountry,
      _DeliveryDocument.ProposedDeliveryRoute,
      _DeliveryDocument.ShippingCondition,
      BaseUnit,
      _DeliveryDocument._ShipToParty.Country as DestinationCountry,
      SalesOffice,
      SalesGroup,
      MaterialFreightGroup,
      Warehouse,
      LoadingPointForDelivery,
      TransportationGroup,

      _DeliveryDocument,
      _DeliveryDocument._SalesOrganization,
      _DistributionChannel,
      _Division,
      _Material,
      _MaterialGroup,
      _DeliveryDocument._ShipToParty,
      _DeliveryDocument._SoldToParty,
      _DeliveryDocument._DeliveryDocumentType,
      _DeliveryDocument._OverallGoodsMovementStatus,
      _DeliveryDocument._OverallPickingStatus,
      _Plant,
      _DeliveryDocument._ShippingPoint,
      _SDDocumentCategory,
      _ItemCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM",
"I_SHIPPINGPOINT"
],
"ASSOCIATED":
[
"E_DELIVERYDOCUMENTITEM",
"I_CUSTOMER",
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_OVERALLGOODSMOVEMENTSTATUS",
"I_OVERALLPICKINGSTATUS",
"I_PLANT",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SHIPPINGPOINT"
],
"BASE":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More