A_InbDeliveryDocFlow_1

DDL: A_INBDELIVERYDOCFLOW_1 SQL: AINBDELIVERYDF1 Type: view BASIC Package: VDM_LE_SHP_IBD_API_V2

CDS View for Inbound Delivery Document Flow

A_InbDeliveryDocFlow_1 is a Basic CDS View that provides data about "CDS View for Inbound Delivery Document Flow" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentProcessFlow) and exposes 12 fields with key fields PrecedingDocument, PrecedingDocumentItem, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentItem. It has 2 associations to related views. Part of development package VDM_LE_SHP_IBD_API_V2.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentProcessFlow I_SDDocumentProcessFlow from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_InbDeliveryItem_1 _Item _Item.DeliveryDocument = $projection.PrecedingDocument and _Item.DeliveryDocumentItem = $projection.PrecedingDocumentItem
[1..1] A_InbDeliveryHeader_1 _DeliveryDocumentHeader $projection.PrecedingDocument = _DeliveryDocumentHeader.DeliveryDocument

Annotations (11)

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

Fields (12)

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
_Item _Item
_DeliveryDocumentHeader _DeliveryDocumentHeader
@AbapCatalog.sqlViewName: 'AINBDELIVERYDF1'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#CHECK

@EndUserText.label: 'CDS View for Inbound Delivery Document Flow'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel: {
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #B,
  usageType.sizeCategory: #XL
}

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

define view A_InbDeliveryDocFlow_1 
    as select from I_SDDocumentProcessFlow
association [1..1] to A_InbDeliveryItem_1 as _Item on _Item.DeliveryDocument = $projection.PrecedingDocument and _Item.DeliveryDocumentItem = $projection.PrecedingDocumentItem
association [1..1] to A_InbDeliveryHeader_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,
    
    
    /* Associations */
    @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT]
    _Item,
    @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
    _DeliveryDocumentHeader
    
} where PrecedingDocumentCategory = '7'