C_ACMApplicationDocumentTP

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 C_ACMApplicationDocumentTP.
-- 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 C_ACMApplicationDocumentTP AS
SELECT
  ApplicationDocument,
  ApplicationDocumentItem,
  ACMDocumentSide,
  ApplicationDocumentSubItem,
  ACMApplicationDocNumberItem,
  Material,
  DocumentDate,
  PostingDate,
  ToPostingDate,
  ACMAppDocStatus,
  ACMApplicationStatusText,
  ApplicationStatusCriticality,
  StatusProfileName,
  ACMSettlementStatusText,
  ACMApplSettlmtStsCriticality,
  ACMApplPrcgDistrStatus,
  ACMPrcgDistrStatusCriticality,
  LoadDataCaptureObjectID,
  IsApplicationItemInTransit,
  ApplicationHasCallOff,
  NominationKey,
  NominationItem,
  OutboundDelivery,
  InboundDelivery,
  PurchaseOrder,
  SalesOrder,
  ACMDecimalGrossQuantity,
  ACMAppDocBaseUoM,
  ACMAllocatedQuantity,
  ACMAppDocDelivUoM,
  ACMAppliedQuantity,
  ACMAppliedQuantityUoM,
  ApplDocumentCreatedBy,
  ApplicationItemCreatedOnDate,
  ApplItemCreatedOnDateTime,
  ApplDocumentChangedBy,
  ApplicationItemChangedOnDate,
  ApplItemChangedOnDateTime,
  ApplicationDocType,
  LoadDataCaptureApplInstruction,
  LoadingDate,
  UnloadingDate,
  BillOfLadingDate,
  BillOfLading,
  LoadDataCaptureType,
  ACMLoadDataCaptureTypeText,
  VehicleId,
  TruckRailBargeId,
  CmmdtyTransptVesselID,
  ContractApplicationUUID,
  ContractApplicationVersion,
  ACMIsApplicationShowHistory,
  TradingContractNumber,
  TradingContractItem,
  ACMScaleTicketNumber,
  ACMApplOvwSpotFlag,
  ACMApplDocIsBackToBack,
  LDCIsMultipleBuySellRelevant,
  OverfillID,
  ACMSupplierSplitType,
  StorageAgreement,
  Plant,
  StorageLocation,
  ACMContractOptionsCropSeasonID,
  TSWLocationID,
  ACMLoadDataCaptureLeadCarNo,
  WarehouseReceiptType,
  ACMInternalWareHouseReceiptNo,
  WarehouseReceiptNo,
  ACMApplicationDocumentLogID,
  PhysicalCommodity,
  ContrItmProvisionalOverFillQty,
  ACMContrItmPrvsnlUnderFillQty,
  TrdgContrItemOverFillQuantity,
  TrdgContrItemUnderFillQuantity,
  TrdgContractApplUnitOfMeasure,
  ApplicationLogObject,
  ApplicationLogSubobject,
  ACMApplItemHasBatchSplit,
  ACMContrOptionsMnsOfTransport,
  QuantityHistoryParentItem,
  SetNodeIsRoot,
  ACMApplActionType,
  MaterialDocument,
  AppDocItem.Counterparty AS Counterparty,
  AppDocItem.CounterpartyFullName AS CounterpartyFullName,
  AppDocItem.CustomerName AS CustomerName,
  AppDocItem.ACMCounterpartyFirstName AS ACMCounterpartyFirstName,
  AppDocItem.ACMCounterpartyLastName AS ACMCounterpartyLastName,
  AppDocItem.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  AppDocItem.LoadDataObjectUUID AS LoadDataObjectUUID,
  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.Incoterms AS Incoterms,
  AppDocItem.ACMOptnAlternateSupplierFlag AS ACMOptnAlternateSupplierFlag,
  AppDocItem.AdjustedQuantity AS AdjustedQuantity,
  AppDocItem.AdjustedQuantityUoM AS AdjustedQuantityUoM,
  AppDocItem.ACMApplItemQuantity AS ACMApplItemQuantity,
  AppDocItem.ACMApplItemQuantityUoM AS ACMApplItemQuantityUoM,
  _ActionTypeText.DomainText AS DomainText,
  _AppInstrText.LDCApplicationInstructionName AS LDCApplicationInstructionName,
  _ApplDocBusiness.CompanyCode AS ACMTradingPeriodCompanyCode,
  _ApplDocBusiness.SalesOrganization AS SalesOrganization,
  _ApplDocBusiness.DistributionChannel AS DistributionChannel,
  _ApplDocBusiness.Division AS Division,
  _ApplDocBusiness.PurchasingOrganization AS PurchasingOrganization,
  _ApplDocBusiness.PurchasingGroup AS PurchasingGroup,
  _ApplDocBusiness.AssetProfitCenter AS AssetProfitCenter,
  _ChangedByName.UserDescription AS ApplDocumentChangedByName,
  _CommodityText.CommodityName AS CommodityName,
  _CreatedByName.UserDescription AS ApplDocumentCreatedByName,
  _CropYearText.ACMCropSeasonText AS ACMCropSeasonText,
  _DocTypeText.ApplicationDocTypeDescription AS ApplicationDocTypeDescription,
  _MaterialText.ProductDescription AS ProductDescription,
  _ModeText.ModeOfTransportDesc AS ModeOfTransportDesc,
  _NominationHeader.ConfirmedNominationNumber AS NominationNumber,
  _NominationTicketFlow.ACMUniversalTicketKey AS NominationTicketKey,
  _PrcDistStatus.DomainText AS ACMApplPrcgDistrStatusText,
  _SpotIndicator.DomainText AS ACMApplOvwSpotFlagDesc,
  _StorageStatus.ACMStorageStatusText AS ACMStorageStatusText,
  _SupplierSplitType.DomainText AS ACMFeeTypeText,
  _VendSplit.ACMLoadDataCaptureSplitType AS ACMLoadDataCaptureSplitType
FROM R_ACMApplicationDocumentTP
;