I_ACMApplicationOverview

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_ACMApplicationOverview.
-- 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: IAPPWRKCNTR

CREATE VIEW I_ACMApplicationOverview AS
SELECT
  AppDocHeader.ApplicationDocument AS ApplicationDocument,
  LatestAppVersion.ReferenceApplicationItem AS ReferenceApplicationItem,
  LatestAppVersion.ContractApplicationUUID AS ContractApplicationUUID,
  LatestAppVersion.ContractApplicationVersion AS ContractApplicationVersion,
  AppDocHeader.ReferenceDocumentType AS ReferenceDocumentType,
  DocTypeText.ApplicationDocTypeDescription AS ApplicationDocTypeDescription,
  LatestAppVersion.ReferenceApplicationSide AS ReferenceApplicationSide,
  LatestAppVersion.ReferenceApplicationSubItem AS ReferenceApplicationSubItem,
  AppDocSideText.DomainText AS ReferenceApplicationSideName,
  AppDocHeader.DocumentDate AS DocumentDate,
  LatestAppVersion.DeliveryDate AS DeliveryDate,
  Business.TradingContractNumber AS TradingContractNumber,
  Business.TradingContractItem AS TradingContractItem,
  AppDocDetails.LoadDataCaptureObjId AS LoadDataCaptureObjId,
  status.StatusProfileName AS ContractApplicationStatus,
  StatusText.TrdgContrApplStsName AS TrdgContrApplStsName,
  AppDocDetails.Counterparty AS Counterparty,
  AppDocDetails.Material AS Material,
  MatDesc.MaterialName AS MaterialName,
  LatestAppVersion.OverfillID AS OverfillID,
  AppDocDetails.ApplicationHasCallOff AS ApplicationHasCallOff,
  AppDocDetails.PredecessorDocumentNumber AS PredecessorDocumentNumber,
  AppDocDetails.ACMPredecessorDocumentNumber AS ACMPredecessorDocumentNumber,
  case when LDCUnload.LoadDataCaptureEventType = '02' then LDCUnload.BillOfLading when LDCLoad.LoadDataCaptureEventType = '01' then LDCLoad.BillOfLading end as BillOfLading AS BillOfLadingendasBillOfLading,
  case when LDCUnload.LoadDataCaptureEventType = '02' then LDCUnload.BillOfLadingDate when LDCLoad.LoadDataCaptureEventType = '01' then LDCLoad.BillOfLadingDate end as BillOfLadingDate AS BillOfLadingDateendasBillOfLadingDate,
  case when LDCUnload.LoadDataCaptureEventType = '02' then LDCUnload.TruckRailBargeId when LDCLoad.LoadDataCaptureEventType = '01' then LDCLoad.TruckRailBargeId end as TruckRailBargeId AS TruckRailBargeIdendasTruckRailBargeId,
  cast( LatestAppVersion.IsApplicationItemInTransit as boole_d ) AS IsApplicationItemInTransit,
  AppDocDetails.LDCIsMultipleBuySellRelevant AS LDCIsMultipleBuySellRelevant,
  AppDocDetails.ACMApplDocIsBackToBack AS ACMApplDocIsBackToBack,
  AppDocDetails.NominationNumber AS NominationNumber,
  LatestAppVersion.ApplDocumentCreatedBy AS ApplDocumentCreatedBy,
  CreatedByName.UserDescription AS ApplDocumentCreatedByName,
  LatestAppVersion.ApplicationItemCreatedOnDate AS ApplicationItemCreatedOnDate,
  LatestAppVersion.ApplDocumentCreatedBy AS ApplDocumentChangedBy,
  ChangedByName.UserDescription AS ApplDocumentChangedByName,
  LatestAppVersion.ApplicationItemChangedOnDate AS ApplicationItemChangedOnDate,
  ContrHeader.tctyp AS TradingContractType,
  ContrHeader.vkorg AS SalesOrganization,
  ContrHeader.vtweg AS DistributionChannel,
  ContrHeader.spart AS Division,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.PurchasingGroup AS PurchasingGroup,
  AppDocDetails.TrdgContrItemApplicationQty AS TrdgContrItemApplicationQty,
  AppDocDetails.UnitOfMeasure AS UnitOfMeasure,
  AppDocDetails.ACMApplOvwSpotFlag AS ACMApplOvwSpotFlag,
  SpotDesc.SpotIndicatorDesc AS ACMApplOvwSpotFlagDesc,
  LDCHdrData.ApplicationIsVehicleContrRlvt AS ApplicationIsVehicleContrRlvt
FROM I_ACMApplDocLtstVers AS LatestAppVersion
INNER JOIN I_ACMApplDocHeader AS AppDocHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMApplDocItem AS AppDocDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMSystemStatus AS status ON /* join condition not captured in parsed metadata */
INNER JOIN I_ApplicationStatusValueHelp AS StatusText ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMApplDocTypeValueHelp AS DocTypeText ON /* join condition not captured in parsed metadata */
INNER JOIN I_LoadDataCaptureHdr AS LDCHdrData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMLoadDataCaptureData AS LDCUnload ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMLoadDataCaptureData AS LDCLoad ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ApplicationDocSide_VH AS AppDocSideText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS MatDesc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContractHead AS ContrHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TradingContractBusinessDets AS Business ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS CreatedByName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS ChangedByName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SpotIndicatoreValueHelp AS SpotDesc ON /* join condition not captured in parsed metadata */
;