I_ACMApplicationDocument

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_ACMApplicationDocument.
-- 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.

CREATE VIEW I_ACMApplicationDocument AS
SELECT
  AppDocItem.ApplicationDocument AS ApplicationDocument,
  AppDocItem.ApplicationDocumentItem AS ApplicationDocumentItem,
  AppDocItem.ACMDocumentSide AS ACMDocumentSide,
  AppDocItem.ApplicationDocumentSubItem AS ApplicationDocumentSubItem,
  AppDocItem.ApplicationItemCategory AS ApplicationItemCategory,
  AppDocItem.ApplicationStatusObject AS ApplicationStatusObject,
  AppDocItem.SettlementStatusObject AS SettlementStatusObject,
  AppDocItem.PostingDate AS PostingDate,
  AppDocItem.Material AS Material,
  AppDocItem.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
  AppDocItem.LoadDataObjectUUID AS LoadDataObjectUUID,
  AppDocItem.IsApplicationItemInTransit AS IsApplicationItemInTransit,
  AppDocItem.IntercompanyIndicator AS IntercompanyIndicator,
  AppDocItem.ACMIntcoIndTxt AS ACMIntcoIndTxt,
  AppDocItem.ApplicationHasCallOff AS ApplicationHasCallOff,
  AppDocItem.NominationKey AS NominationKey,
  AppDocItem.NominationItem AS NominationItem,
  AppDocItem.ACMReferenceType2 AS ACMReferenceType2,
  AppDocItem.ACMReferenceDocument2 AS ACMReferenceDocument2,
  AppDocItem.ACMReferenceType3 AS ACMReferenceType3,
  AppDocItem.ACMReferenceDocument3 AS ACMReferenceDocument3,
  AppDocItem.CustomerNum AS CustomerNum,
  AppDocItem.ReferenceVendor AS ReferenceVendor,
  round(AppDocItem.ACMDecimalGrossQuantity , 3) AS ACMDecimalGrossQuantity,
  AppDocItem.ACMAppDocBaseUoM AS ACMAppDocBaseUoM,
  round(AppDocItem.ACMAllocatedQuantity , 3) AS ACMAllocatedQuantity,
  AppDocItem.ACMAppDocDelivUoM AS ACMAppDocDelivUoM,
  round(AppDocItem.ToBeAppliedQuantity , 3) AS ToBeAppliedQuantity,
  AppDocItem.ToBeAppliedQuantityUnit AS ToBeAppliedQuantityUnit,
  round(AppDocItem.AdjustedQuantity , 3) AS AdjustedQuantity,
  AppDocItem.AdjustedQuantityUoM AS AdjustedQuantityUoM,
  round(AppDocItem.ACMAppliedQuantity , 3) AS ACMAppliedQuantity,
  AppDocItem.ACMAppliedQuantityUoM AS ACMAppliedQuantityUoM,
  round(AppDocItem.ACMApplItemQuantity, 3) AS ACMApplItemQuantity,
  AppDocItem.ACMApplItemQuantityUoM AS ACMApplItemQuantityUoM,
  AppDocItem.ApplDocumentCreatedBy AS ApplDocumentCreatedBy,
  AppDocItem.ApplicationItemCreatedOnDate AS ApplicationItemCreatedOnDate,
  AppDocItem.ApplItemCreatedOnDateTime AS ApplItemCreatedOnDateTime,
  AppDocItem.ApplDocumentChangedBy AS ApplDocumentChangedBy,
  AppDocItem.ApplicationItemChangedOnDate AS ApplicationItemChangedOnDate,
  AppDocItem.ApplItemChangedOnDateTime AS ApplItemChangedOnDateTime,
  AppDocItem.ACMApplOvwSpotFlag AS ACMApplOvwSpotFlag,
  AppDocItem.ACMApplDocIsBackToBack AS ACMApplDocIsBackToBack,
  AppDocItem.LDCIsMultipleBuySellRelevant AS LDCIsMultipleBuySellRelevant,
  AppDocItem.ACMSupplierSplitType AS ACMSupplierSplitType,
  AppDocItem.ACMLoadDataCaptureSplitSource AS ACMLoadDataCaptureSplitSource,
  AppDocItem.Plant AS Plant,
  AppDocItem.StorageLocation AS StorageLocation,
  AppDocItem.ACMContractOptionsCropSeasonID AS ACMContractOptionsCropSeasonID,
  AppDocItem.TSWLocationID AS TSWLocationID,
  AppDocItem.ACMApplItemHasBatchSplit AS ACMApplItemHasBatchSplit,
  AppDocItem.WarehouseReceiptType AS WarehouseReceiptType,
  AppDocItem.ACMInternalWareHouseReceiptNo AS ACMInternalWareHouseReceiptNo,
  AppDocItem.WarehouseReceiptNo AS WarehouseReceiptNo,
  AppDocItem.ACMApplPrcgDistrStatus AS ACMApplPrcgDistrStatus,
  AppDocItem.ACMApplicationDocumentLogID AS ACMApplicationDocumentLogID,
  AppDocItem.ACMStorageStatusObject AS ACMStorageStatusObject,
  AppDocItem.ACMOptionsLoadRate AS ACMOptionsLoadRate,
  AppDocItem.ACMOptionsDischargeRate AS ACMOptionsDischargeRate,
  AppDocItem.DeliveryStartDate AS DeliveryStartDate,
  AppDocItem.ACMContrOptionsSourceLocation AS ACMContrOptionsSourceLocation,
  AppDocItem.ACMOptionsLoadRateUnit AS ACMOptionsLoadRateUnit,
  AppDocItem.ACMOptionsLoadRateTimeUnit AS ACMOptionsLoadRateTimeUnit,
  AppDocItem.ACMOptnDelivPeriodTimeUnit AS ACMOptnDelivPeriodTimeUnit,
  AppDocItem.ACMOptionsDischargeRateUnit AS ACMOptionsDischargeRateUnit,
  AppDocItem.ACMOptnDschrgRateTimeUnit AS ACMOptnDschrgRateTimeUnit,
  AppDocItem.ACMApplDocContrOptnLoadLoc AS ACMApplDocContrOptnLoadLoc,
  AppDocItem.ACMApplDocContrOptnDschrgdLoc AS ACMApplDocContrOptnDschrgdLoc,
  AppDocItem.ModeOfTransport AS ModeOfTransport,
  AppDocItem.ACMContrOptionsMnsOfTransport AS ACMContrOptionsMnsOfTransport,
  AppDocItem.MeansOfTransport AS MeansOfTransport,
  AppDocItem.Incoterms AS Incoterms,
  AppDocItem.ACMOptionsDeletionFlag AS ACMOptionsDeletionFlag,
  AppDocItem.ACMOptnAlternateSupplierFlag AS ACMOptnAlternateSupplierFlag,
  AppDocItem.ACMIsApplicationShowHistory AS ACMIsApplicationShowHistory,
  AppDocHdr.ApplicationDocType AS ApplicationDocType,
  AppDocHdr.DocumentDate AS DocumentDate,
  AppDocHdr.MaterialDocument AS MaterialDocument,
  case AppDocItem.ACMDocumentSide when 'M' then AppDocItem.ReferenceVendor when 'V' then AppDocItem.CustomerNum else ' ' end as Counterparty AS CustomerNumelseendasCounterparty,
  AppDocItem.ACMApplTransCtpty AS ACMApplTransCtpty,
  AppData.ContractApplicationUUID AS ContractApplicationUUID,
  AppData.ContractApplicationVersion AS ContractApplicationVersion,
  AppData.TradingContractNumber AS TradingContractNumber,
  AppData.TradingContractItem AS TradingContractItem,
  AppData.OverfillID AS OverfillID,
  AppData.ContrItmProvisionalOverFillQty AS ContrItmProvisionalOverFillQty,
  AppData.ACMContrItmPrvsnlUnderFillQty AS ACMContrItmPrvsnlUnderFillQty,
  AppData.TrdgContrItemOverFillQuantity AS TrdgContrItemOverFillQuantity,
  AppData.TrdgContrItemUnderFillQuantity AS TrdgContrItemUnderFillQuantity,
  AppData.TrdgContractApplUnitOfMeasure AS TrdgContractApplUnitOfMeasure,
  AppData.ACMApplDocIsActiveVersion AS ACMApplDocIsActiveVersion,
  _VendSplit.ACMLoadDataCaptureEventKeyUUID AS ACMLoadDataCaptureEventKeyUUID,
  AppDocItem.QuantityHistoryParentItem AS QuantityHistoryParentItem,
  AppDocItem.RootItem AS RootItem,
  AppDocItem.ACMAppDocStatus AS ACMAppDocStatus,
  AppDocItem.ACMApplicationStatusText AS ACMApplicationStatusText,
  AppDocItem.ACMApplActionType AS ACMApplActionType,
  AppDocItem.StorageStartDate AS StorageStartDate
FROM I_ACMApplicationDocumentDet AS AppDocItem
INNER JOIN I_ACMApplDocHeaderData AS AppDocHdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMSupplierSplit AS _VendSplit ON LoadDataObjectUUID = _VendSplit.ACMLoadDataCaptureEventKeyUUID  -- association [1..1]
LEFT OUTER JOIN I_ACMTicketDocumentFlowBasic AS _NominationTicketFlow ON ApplicationDocument = _NominationTicketFlow.ACMUniversalTicketDocNumber  -- association [1..1]
;