C_SettlmtDoc_F3594A

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_SettlmtDoc_F3594A.
-- 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_SettlmtDoc_F3594A AS
SELECT
  SettlmtDoc,
  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,
  SettlmtMgmtAcctgTransfSts,
  _SettlmtMgmtAcctgTransfSts._Text.SettlmtMgmtAcctgTransfStsName : localized AS SettlmtMgmtAcctgTransfStsNamelocalized,
  CreatedByUser,
  cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  SettlmtBusProcCat,
  _SettlmtBusProcCat._Text.SettlmtBusProcCatName : localized AS SettlmtBusProcCatNamelocalized,
  SettlmtDocCurrency,
  _SettlmtDocCurrency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  SettlmtHasDvtgCndnContrData,
  cast( SuplrSettlmtCompanyCode as bukrs preserving type ) AS SuplrSettlmtCompanyCode,
  _SuplrSettlmtCompanyCode.CompanyCodeName AS SuplrSettlmtCompanyCodeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SalesOrganization,
  DistributionChannel,
  Division,
  _Division._Text.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  BillToParty,
  cast( _BillToParty.CustomerName as wlf_kunre_name preserving type ) AS BillToPartyName,
  _BillToParty.OrganizationBPName1 AS BillToPartyName_H,
  PayerParty,
  cast( _PayerParty.CustomerName as wlf_kunrg_name preserving type ) AS PayerPartyName,
  _PayerParty.OrganizationBPName1 AS PayerPartyName_H,
  InvoicingParty,
  cast( _InvoicingParty.SupplierName as wlf_lifre_name preserving type ) AS InvoicingPartyName,
  _InvoicingParty.OrganizationBPName1 AS InvoicingPartyName_H,
  PayeeParty,
  cast( _PayeeParty.SupplierName as wlf_lnrzb_name preserving type ) AS PayeePartyName,
  _PayeeParty.OrganizationBPName1 AS PayeePartyName_H,
  AlternativeInvoicingParty,
  cast( _AlternativeInvoicingParty.SupplierName as wlf_lifnr_fi_name preserving type ) AS AlternativeInvoicingPartyName,
  _AlternativeInvoicingParty.OrganizationBPName1 AS AltvInvoicingPartyName_H,
  SettlmtReltdCndnContr,
  SettlmtDate,
  SettlmtDateCat,
  _SettlmtDateCat._Text.SettlmtDateCatName : localized AS SettlmtDateCatNamelocalized,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtPartnerCat,
  CustomerTotalGrossAmount,
  SupplierTotalGrossAmount,
  SettlmtDocAuthznCat,
  virtual TotalGrossAmount : wbrtw AS virtualTotalGrossAmountwbrtw,
  CustSettlmtCompanyCode
FROM R_SettlmtDocTP
;