R_FrtCostAllocDoc

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 R_FrtCostAllocDoc.
-- 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 R_FrtCostAllocDoc AS
SELECT
  cast( R_SettlmtMgmtDoc.SettlmtMgmtDoc as wlf_fcadoc_wbeln preserving type ) AS FreightCostAllocationDocument,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtProcessCat,
  LogisticsDataEntryCat,
  SettlmtCat,
  PostingDate,
  SettlmtMgmtAcctgTransfSts AS FrtCostAllocAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  cast( SupplierPricingProcedure as wlf_kalsm preserving type ) AS PricingProcedure,
  cast( SupplierPricingDocument as wlf_knumv preserving type ) AS PricingDocument,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  cast( SettlmtDocCurrency as wlf_fcadoc_waerl preserving type ) AS FrtCostAllocDocCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  cast( SupplierTotalGrossAmount as brtwr_lf preserving type ) AS FrtCostAllocDocTotGrossAmount,
  cast( SupplierTotalNetAmount as netwr_lf preserving type ) AS FrtCostAllocDocTotalNetAmount,
  cast( SettlmtMgmtDocIsCancelled as wlf_fcadoc_fksto preserving type ) AS FrtCostAllocDocIsReversed,
  CancelledSettlmtMgmtDoc AS RvsdFrtCostAllocDoc,
  SettlmtDocActivityReason AS FrtCostAllocDocActivityReason,
  PaymentReference,
  SettlmtClassificationCat,
  FiscalPeriod,
  SettlmtMgmtDocIncmpltnsRsn AS FrtCostAllocDocIncmpltnsRsn,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcCat AS FrtCostAllocBusProcCat,
  ApplElmntBehaviorGrp,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  SettlmtMgmtAdjmtCat AS FrtCostAllocAdjmtCat,
  SettlmtMgmtDocChangeState AS FrtCostAllocDocChangeState
FROM R_SettlmtMgmtDoc
LEFT OUTER JOIN R_FrtCostAllocItm AS _FrtCostAllocItm ON FreightCostAllocationDocument = _FrtCostAllocItm.FreightCostAllocationDocument  -- association [0..*]
LEFT OUTER JOIN I_FrtCostAllocAcctgTransfSts AS _FrtCostAllocAcctgTransfSts ON FrtCostAllocAcctgTransfSts = _FrtCostAllocAcctgTransfSts.FrtCostAllocAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN R_FrtCostAllocPrcgElmnt AS _FrtCostAllocPrcgElmnt ON FreightCostAllocationDocument = _FrtCostAllocPrcgElmnt.FreightCostAllocationDocument  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _FrtCostAllocDocCurrency ON FrtCostAllocDocCurrency = _FrtCostAllocDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN R_FrtCostAllocDoc AS _RvsdFrtCostAllocDoc ON RvsdFrtCostAllocDoc = _RvsdFrtCostAllocDoc.FreightCostAllocationDocument  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _FrtCostAllocDocActivityReason ON FrtCostAllocDocActivityReason = _FrtCostAllocDocActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIncmpltnsRsnCd AS _FrtCostAllocDocIncmpltnsRsn ON FrtCostAllocDocIncmpltnsRsn = _FrtCostAllocDocIncmpltnsRsn.SettlmtMgmtDocIncmpltnsRsn  -- association [0..1]
LEFT OUTER JOIN I_FrtCostAllocBusProcCat AS _FrtCostAllocBusProcCat ON FrtCostAllocBusProcCat = _FrtCostAllocBusProcCat.FrtCostAllocBusProcCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtAdjmtCat AS _FrtCostAllocAdjmtCat ON FrtCostAllocAdjmtCat = _FrtCostAllocAdjmtCat.SettlmtMgmtAdjmtCat  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON FreightCostAllocationDocument = _Extension.SettlmtMgmtDoc  -- association [1..1]
;