C_MngFrtCostAllocDoc

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_MngFrtCostAllocDoc.
-- 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_MngFrtCostAllocDoc AS
SELECT
  FreightCostAllocationDocument,
  SettlmtDocType,
  _SettlmtDocType._Text.SettlmtDocTypeDesc : localized AS SettlmtDocTypeDesclocalized,
  SettlmtDocCat,
  _SettlmtDocCat._Text.SettlmtDocCatName : localized AS SettlmtDocCatNamelocalized,
  SettlmtProcessType,
  _SettlmtProcessType._Text.SettlmtProcessTypeDesc : localized AS SettlmtProcessTypeDesclocalized,
  SettlmtProcessCat,
  _SettlmtProcessCat._Text.SettlmtProcessCatName : localized AS SettlmtProcessCatNamelocalized,
  PostingDate,
  FrtCostAllocAdjmtCat,
  FrtCostAllocAcctgTransfSts,
  _FrtCostAllocAcctgTransfSts._Text.FrtCostAllocAcctgTransfStsName : localized AS FrtCostAllocAcctgTransfStsNamelocalized,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  _SettlmtApplSts._Text.SettlmtApplStsDesc : localized AS SettlmtApplStsDesclocalized,
  SettlmtApplStsGrp,
  _SettlmtApplStsGrp._Text.SettlmtApplStsGrpDesc : localized AS SettlmtApplStsGrpDesclocalized,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SalesOrganization,
  _SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  DistributionChannel,
  _DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  Division,
  _Division._Text.DivisionName : localized AS DivisionNamelocalized,
  SalesOffice,
  _SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  SalesGroup,
  _SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
  CreatedByUser,
  cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  CreationDate,
  CreationTime,
  LastChangeDate,
  FrtCostAllocDocCurrency,
  ExchangeRate,
  ExchangeRateType,
  _ExchangeRateType._Text.ExchangeRateTypeName : localized AS ExchangeRateTypeNamelocalized,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  FrtCostAllocDocTotGrossAmount,
  FrtCostAllocDocTotalNetAmount,
  FrtCostAllocDocIsReversed,
  RvsdFrtCostAllocDoc,
  FrtCostAllocDocActivityReason,
  _FrtCostAllocDocActivityReason._Text.SettlmtActivityReasonDesc : localized AS SettlmtActivityReasonDesclocalized,
  SettlmtClassificationCat,
  _SettlmtClassificationCat._Text.SettlmtClassificationCatName : localized AS SettlmtClassificationCatNamelocalized,
  FiscalPeriod,
  FrtCostAllocBusProcCat,
  ApplElmntBehaviorGrp,
  FrtCostAllocDocIncmpltnsRsn,
  _FrtCostAllocDocIncmpltnsRsn._Text.SettlmtMgmtDocIncmpltnsRsnDesc : localized AS SettlmtMgmtDocIncmpltnsRsnDesclocalized,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  virtual JournalEntry : farp_belnr_d AS virtualJournalEntryfarp_belnr_d,
  virtual FiscalYear : fis_gjahr_no_conv AS virtualFiscalYearfis_gjahr_no_conv,
  virtual UICT_COLL_Jrnl_Entries : boolean AS virtualUICT_COLL_Jrnl_Entriesboolean,
  virtual UICT_FldGrpJournalEntry : boolean AS virtualUICT_FldGrpJournalEntryboolean,
  virtual UICT_DocHasMltplJrnlEntr : boolean AS virtualUICT_DocHasMltplJrnlEntrboolean,
  virtual UICT_HDR_Status : boolean AS virtualUICT_HDR_Statusboolean,
  virtual UICT_HDR_Acctg : boolean AS virtualUICT_HDR_Acctgboolean,
  virtual UICT_HDR_Amount : boolean AS virtualUICT_HDR_Amountboolean,
  virtual UICT_COLL_Gen_Info : boolean AS virtualUICT_COLL_Gen_Infoboolean,
  virtual UICT_COLL_Basic_Data : boolean AS virtualUICT_COLL_Basic_Databoolean,
  virtual UICT_COLL_Crcy_Postg : boolean AS virtualUICT_COLL_Crcy_Postgboolean,
  virtual UICT_FLDGRP_Admin : boolean AS virtualUICT_FLDGRP_Adminboolean,
  virtual UICT_FLDGRP_Settlmt_Dets : boolean AS virtualUICT_FLDGRP_Settlmt_Detsboolean,
  virtual UICT_FLDGRP_Proc_Dets : boolean AS virtualUICT_FLDGRP_Proc_Detsboolean,
  virtual UICT_FLDGRP_Ref_Info : boolean AS virtualUICT_FLDGRP_Ref_Infoboolean,
  virtual UICT_FLDGRP_Rev_Info : boolean AS virtualUICT_FLDGRP_Rev_Infoboolean,
  virtual UICT_FLDGRP_Crcy_Info : boolean AS virtualUICT_FLDGRP_Crcy_Infoboolean,
  virtual UICT_FLDGRP_Postg_Info : boolean AS virtualUICT_FLDGRP_Postg_Infoboolean,
  virtual UICT_LNITM_Prcg_Elmnt : boolean AS virtualUICT_LNITM_Prcg_Elmntboolean,
  FrtCostAllocDocChangeState
FROM R_FrtCostAllocDocTP
LEFT OUTER JOIN C_FrtCostAlcPrcgElmnt_F5514 AS _FrtCostAllocPrcgElmnt ON FreightCostAllocationDocument = _FrtCostAllocPrcgElmnt.FreightCostAllocationDocument  -- association [0..*]
;