I_ACMOrderDeliveryAssignment

DDL: I_ACMORDERDELIVERYASSIGNMENT SQL: IACMODRDELVASSGN Type: view COMPOSITE
17 Fields 2 Data Sources

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.

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 Vehicle Model
ACMReferenceType3 I_ACMApplAssignmentItemUoM ACMReferenceType3
ACMReferenceDocument2 I_ACMApplAssignmentItemUoM ACMReferenceDocument2
ACMOverfillQuantity
ACMUnderFillQuantity
ProvisionalOverfillQuantity
ProvisionalUnderfillQuantity
ACMApplicationDataUoM I_ACMApplAssignmentItemUoM ACMApplicationDataUoM
ACMDeliveredAdjustedQuantity I_ACMApplAssignmentItemUoM ACMDeliveredAdjustedQuantity
ACMPrecursorDocumentType I_ACMApplAssignmentItemUoM ACMPrecursorDocumentType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ACMOrderDeliveryAssignment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IACMODRDELVASSGN

CREATE VIEW I_ACMOrderDeliveryAssignment AS
SELECT
  ApplDocData.ApplicationDocument AS ApplicationDocument,
  ApplDocData.ACMPrecursorDocumentNumber AS ACMPrecursorDocumentNumber,
  ApplDocData.PredecessorDocumentItem AS PredecessorDocumentItem,
  ApplDocData.LoadDataCaptureObjId AS LoadDataCaptureObjId,
  ApplDocData.LoadDataCaptureApplInstruction AS LoadDataCaptureApplInstruction,
  sum( ApplDocData.ACMDeliveredQuantity ) AS ACMDeliveredQuantity,
  ApplDocData.ACMDeliveredUoM AS ACMDeliveredUoM,
  ApplDocData.Material AS Material,
  ApplDocData.ACMReferenceType3 AS ACMReferenceType3,
  ApplDocData.ACMReferenceDocument2 AS ACMReferenceDocument2,
  sum( ApplDocData.ACMOverfillQuantity ) AS ACMOverfillQuantity,
  sum( ApplDocData.ACMUnderFillQuantity ) AS ACMUnderFillQuantity,
  sum( ApplDocData.ProvisionalOverfillQuantity ) AS ProvisionalOverfillQuantity,
  sum( ApplDocData.ProvisionalUnderfillQuantity ) AS ProvisionalUnderfillQuantity,
  ApplDocData.ACMApplicationDataUoM AS ACMApplicationDataUoM,
  ApplDocData.ACMDeliveredAdjustedQuantity AS ACMDeliveredAdjustedQuantity,
  ApplDocData.ACMPrecursorDocumentType AS ACMPrecursorDocumentType
FROM I_ACMApplAssignmentItemUoM AS ApplDocData
INNER JOIN I_ACMSystemStatus AS Status ON /* join condition not captured in parsed metadata */
;

Learn More