I_ACMOrderDeliveryAssignment

DDL: I_ACMORDERDELIVERYASSIGNMENT SQL: IACMODRDELVASSGN Type: view COMPOSITE

ACM Order Delivery Assignment

I_ACMOrderDeliveryAssignment is a Composite CDS View that provides data about "ACM Order Delivery Assignment" in SAP S/4HANA. It reads from 2 data sources (I_ACMApplAssignmentItemUoM, I_ACMSystemStatus) and exposes 17 fields with key fields ApplicationDocument, ACMPrecursorDocumentNumber, PredecessorDocumentItem, LoadDataCaptureObjId.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_ACMApplAssignmentItemUoM ApplDocData from
I_ACMSystemStatus Status inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMODRDELVASSGN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label ACM Order Delivery Assignment view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ApplicationDocument I_ACMApplAssignmentItemUoM ApplicationDocument
KEY ACMPrecursorDocumentNumber I_ACMApplAssignmentItemUoM ACMPrecursorDocumentNumber
KEY PredecessorDocumentItem I_ACMApplAssignmentItemUoM PredecessorDocumentItem
KEY LoadDataCaptureObjId I_ACMApplAssignmentItemUoM LoadDataCaptureObjId
LoadDataCaptureApplInstruction I_ACMApplAssignmentItemUoM LoadDataCaptureApplInstruction
ACMDeliveredQuantity
ACMDeliveredUoM I_ACMApplAssignmentItemUoM ACMDeliveredUoM
Material I_ACMApplAssignmentItemUoM Material
ACMReferenceType3 I_ACMApplAssignmentItemUoM ACMReferenceType3
ACMReferenceDocument2 I_ACMApplAssignmentItemUoM ACMReferenceDocument2
ACMOverfillQuantity
ACMUnderFillQuantity
ProvisionalOverfillQuantity
ProvisionalUnderfillQuantity
ACMApplicationDataUoM I_ACMApplAssignmentItemUoM ACMApplicationDataUoM
ACMDeliveredAdjustedQuantity I_ACMApplAssignmentItemUoM ACMDeliveredAdjustedQuantity
ACMPrecursorDocumentType I_ACMApplAssignmentItemUoM ACMPrecursorDocumentType 
@AbapCatalog.sqlViewName: 'IACMODRDELVASSGN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
               usageType: {
                 dataClass: #TRANSACTIONAL,
                 serviceQuality: #C,
                 sizeCategory: #L
               }
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@EndUserText.label: 'ACM Order Delivery Assignment'
define view I_ACMOrderDeliveryAssignment
  as select from I_ACMApplAssignmentItemUoM as ApplDocData
    inner join   I_ACMSystemStatus          as Status on  Status.ApplicationStatusObject        = ApplDocData.ACMLoadDataCaptureItmStatusObj
                                                      and (
                                                         Status.StatusProfileName               = 'I7A03' //Provisionaly Applied

                                                         or Status.StatusProfileName            = 'I7A04' //Finally Applied

                                                       )
                                                      and Status.ChangeDocumentStatusIsInactive = ''

{
  key ApplDocData.ApplicationDocument,
  key ApplDocData.ACMPrecursorDocumentNumber,
  key ApplDocData.PredecessorDocumentItem,
  key ApplDocData.LoadDataCaptureObjId,
      ApplDocData.LoadDataCaptureApplInstruction,
      @Semantics.quantity.unitOfMeasure: 'ACMDeliveredUoM'
      sum( ApplDocData.ACMDeliveredQuantity )         as ACMDeliveredQuantity,
      @Semantics.unitOfMeasure: true
      ApplDocData.ACMDeliveredUoM,
      ApplDocData.Material,
      ApplDocData.ACMReferenceType3,
      ApplDocData.ACMReferenceDocument2,
      sum( ApplDocData.ACMOverfillQuantity )          as ACMOverfillQuantity,
      sum( ApplDocData.ACMUnderFillQuantity )         as ACMUnderFillQuantity,
      sum( ApplDocData.ProvisionalOverfillQuantity )  as ProvisionalOverfillQuantity,
      sum( ApplDocData.ProvisionalUnderfillQuantity ) as ProvisionalUnderfillQuantity,
      ApplDocData.ACMApplicationDataUoM,
      ApplDocData.ACMDeliveredAdjustedQuantity,
      ApplDocData.ACMPrecursorDocumentType
      
}
group by
  ApplDocData.ApplicationDocument,
  ApplDocData.ACMPrecursorDocumentNumber,
  ApplDocData.PredecessorDocumentItem,
  ApplDocData.LoadDataCaptureObjId,
  ApplDocData.LoadDataCaptureApplInstruction,
  ApplDocData.ACMDeliveredUoM,
  ApplDocData.Material,
  ApplDocData.ACMReferenceType3,
  ApplDocData.ACMReferenceDocument2,
  ApplDocData.ACMApplicationDataUoM,
  ApplDocData.ACMDeliveredAdjustedQuantity,
  ApplDocData.ACMPrecursorDocumentType

Learn More