I_ACMOrderContractCallOff

DDL: I_ACMORDERCONTRACTCALLOFF SQL: IACMORDCNTRTCOFF Type: view COMPOSITE
17 Fields 3 Data Sources

ACM Order Contarct Call Off

I_ACMOrderContractCallOff is a Composite CDS View that provides data about "ACM Order Contarct Call Off" in SAP S/4HANA. It reads from 3 data sources (I_ACMOrderCallOffQuantityRef, I_ACMContractCallOff, P_ACMTrdgContrHdr) and exposes 17 fields with key fields ACMReferenceDocumentNumber, ACMReferenceDocumentItemNumber.

Data Sources (3)

SourceAliasJoin Type
I_ACMOrderCallOffQuantityRef ACMApplicationData inner
I_ACMContractCallOff ACMContractCalloff from
P_ACMTrdgContrHdr ACMTradingContract inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMORDCNTRTCOFF 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 Contarct Call Off view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ACMReferenceDocumentNumber I_ACMContractCallOff ACMReferenceDocumentNumber Reference Doc
KEY ACMReferenceDocumentItemNumber I_ACMContractCallOff ACMReferenceDocumentItemNumber Ref. Doc. Item
DeliveryPeriodStartDate I_ACMContractCallOff DeliveryPeriodStartDate Delivery Period
DeliveryPeriodEndDate I_ACMContractCallOff DeliveryPeriodEndDate Delivery End Date
ACMLoadLocation I_ACMContractCallOff ACMLoadLocation Load Location
ACMDischargeLocation I_ACMContractCallOff ACMDischargeLocation Discharge Location
ModeOfTransport I_ACMContractCallOff ModeOfTransport Mode of Transp.
ACMContrOptionsMnsOfTransport I_ACMContractCallOff ACMContrOptionsMnsOfTransport Means of Transport
TradingContractNumber I_ACMOrderCallOffQuantityRef TradingContractNumber Trading Contract
TradingContractItem I_ACMOrderCallOffQuantityRef TradingContractItem Item Number
ACMReferenceDocumentType I_ACMOrderCallOffQuantityRef ACMReferenceDocumentType Document Type
ACMCallOffRawQuantity I_ACMOrderCallOffQuantityRef ACMCallOffRawQuantity ItemQuan
ACMCallOffQuantityUoM I_ACMOrderCallOffQuantityRef ACMCallOffQuantityUoM ItemUoM
ACMCallOffBaseRawQuantity I_ACMOrderCallOffQuantityRef ACMCallOffBaseRawQuantity CumAssignedQuan
ACMCallOffBaseQuantityUoM I_ACMOrderCallOffQuantityRef ACMCallOffBaseQuantityUoM Assigned UoM
ACMAssignmentStatus I_ACMOrderCallOffQuantityRef ACMAssignmentStatus TRUE
TradingContractExternalID P_ACMTrdgContrHdr TradingContractExternalID Ext. Identifier

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_ACMOrderContractCallOff.
-- 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: IACMORDCNTRTCOFF

CREATE VIEW I_ACMOrderContractCallOff AS
SELECT
  ACMContractCalloff.ACMReferenceDocumentNumber AS ACMReferenceDocumentNumber,
  ACMContractCalloff.ACMReferenceDocumentItemNumber AS ACMReferenceDocumentItemNumber,
  ACMContractCalloff.DeliveryPeriodStartDate AS DeliveryPeriodStartDate,
  ACMContractCalloff.DeliveryPeriodEndDate AS DeliveryPeriodEndDate,
  ACMContractCalloff.ACMLoadLocation AS ACMLoadLocation,
  ACMContractCalloff.ACMDischargeLocation AS ACMDischargeLocation,
  ACMContractCalloff.ModeOfTransport AS ModeOfTransport,
  ACMContractCalloff.ACMContrOptionsMnsOfTransport AS ACMContrOptionsMnsOfTransport,
  ACMApplicationData.TradingContractNumber AS TradingContractNumber,
  ACMApplicationData.TradingContractItem AS TradingContractItem,
  ACMApplicationData.ACMReferenceDocumentType AS ACMReferenceDocumentType,
  ACMApplicationData.ACMCallOffRawQuantity AS ACMCallOffRawQuantity,
  ACMApplicationData.ACMCallOffQuantityUoM AS ACMCallOffQuantityUoM,
  ACMApplicationData.ACMCallOffBaseRawQuantity AS ACMCallOffBaseRawQuantity,
  ACMApplicationData.ACMCallOffBaseQuantityUoM AS ACMCallOffBaseQuantityUoM,
  ACMApplicationData.ACMAssignmentStatus AS ACMAssignmentStatus,
  ACMTradingContract.TradingContractExternalID AS TradingContractExternalID
FROM I_ACMContractCallOff AS ACMContractCalloff
INNER JOIN I_ACMOrderCallOffQuantityRef AS ACMApplicationData ON /* join condition not captured in parsed metadata */
INNER JOIN P_ACMTrdgContrHdr AS ACMTradingContract ON /* join condition not captured in parsed metadata */
;

Learn More