A_OutbDeliveryDocFlow_1

DDL: A_OUTBDELIVERYDOCFLOW_1 SQL: AOUTBDELIVERYDF1 Type: view BASIC Package: VDM_LE_SHP_OBD_API_V2

CDS view for API exposure

A_OutbDeliveryDocFlow_1 is a Basic CDS View that provides data about "CDS view for API exposure" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentProcessFlow) and exposes 13 fields with key fields PrecedingDocument, PrecedingDocumentItem, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentItem. It has 2 associations to related views. Part of development package VDM_LE_SHP_OBD_API_V2.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentProcessFlow I_SDDocumentProcessFlow from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_OutbDeliveryItem_1 _Item _Item.DeliveryDocument = $projection.PrecedingDocument and _Item.DeliveryDocumentItem = $projection.PrecedingDocumentItem
[1..1] A_OutbDeliveryHeader_1 _DeliveryDocumentHeader $projection.PrecedingDocument = _DeliveryDocumentHeader.DeliveryDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName AOUTBDELIVERYDF1 view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label CDS view for API exposure view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument I_SDDocumentProcessFlow PrecedingDocument
KEY PrecedingDocumentItem I_SDDocumentProcessFlow PrecedingDocumentItem
KEY PrecedingDocumentCategory I_SDDocumentProcessFlow PrecedingDocumentCategory
KEY SubsequentDocument I_SDDocumentProcessFlow SubsequentDocument
KEY SubsequentDocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY SubsequentDocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SDFulfillmentCalculationRule I_SDDocumentProcessFlow SDFulfillmentCalculationRule
BaseUnit I_SDDocumentProcessFlow BaseUnit
QuantityInBaseUnit I_SDDocumentProcessFlow QuantityInBaseUnit
TransferOrderInWrhsMgmtIsConfd I_SDDocumentProcessFlow TransferOrderInWrhsMgmtIsConfd
DeliveryVersion _DeliveryDocumentHeader DeliveryVersion
_Item _Item
_DeliveryDocumentHeader _DeliveryDocumentHeader
@AbapCatalog.sqlViewName: 'AOUTBDELIVERYDF1'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@EndUserText.label: 'CDS view for API exposure'
@VDM.viewType: #BASIC
@ObjectModel: {
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #B,
  usageType.sizeCategory: #XL
}

/* !! Direct Exposure to Odata is not allowed with this view !! */

define view A_OutbDeliveryDocFlow_1
  as select from I_SDDocumentProcessFlow

  association [1..1] to A_OutbDeliveryItem_1   as _Item                   on  _Item.DeliveryDocument     = $projection.PrecedingDocument
                                                                          and _Item.DeliveryDocumentItem = $projection.PrecedingDocumentItem
  association [1..1] to A_OutbDeliveryHeader_1 as _DeliveryDocumentHeader on  $projection.PrecedingDocument = _DeliveryDocumentHeader.DeliveryDocument
{
  key I_SDDocumentProcessFlow.PrecedingDocument,
  key I_SDDocumentProcessFlow.PrecedingDocumentItem,
  @ObjectModel.sapObjectNodeTypeReference: 'SDDocumentCategory' 
  key I_SDDocumentProcessFlow.PrecedingDocumentCategory,
  key I_SDDocumentProcessFlow.SubsequentDocument,
  key I_SDDocumentProcessFlow.SubsequentDocumentItem,
  @ObjectModel.sapObjectNodeTypeReference: 'SDDocumentCategory' 
  key I_SDDocumentProcessFlow.SubsequentDocumentCategory,
      I_SDDocumentProcessFlow.SDFulfillmentCalculationRule,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      @Semantics.unitOfMeasure: true
      I_SDDocumentProcessFlow.BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      I_SDDocumentProcessFlow.QuantityInBaseUnit,
      I_SDDocumentProcessFlow.TransferOrderInWrhsMgmtIsConfd,

      //  Delivery Version

      _DeliveryDocumentHeader.DeliveryVersion,

      /* Associations */
      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT]
      _Item,
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _DeliveryDocumentHeader

}
where
  PrecedingDocumentCategory = 'J';