I_RAPostingWithoutAcctAssgmt

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_RAPostingWithoutAcctAssgmt.
-- 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 I_RAPostingWithoutAcctAssgmt AS
SELECT
  company_code AS CompanyCode,
  acct_principle AS AccountingPrinciple,
  recon_key AS RevnAcctgReconciliationKey,
  cast(pob_id as farr_cds_pob_id preserving type) AS PerformanceObligation,
  condition_type AS ConditionType,
  post_cat AS RevnAcctgPostingCategory,
  shkzg AS DebitCreditCode,
  guid AS RevnAcctgPostingItemUUID,
  cast(contract_id as farr_cds_contract_id preserving type) AS RevenueAccountingContract,
  betrw AS RevnAcctgPostgAmtInSlsDocCrcy,
  waers AS SalesDocumentCurrency,
  cast(betrh as farr_cds_postg_revn_company preserving type) AS RevnAcctgPostgAmtInCoCodeCrcy,
  hwaer AS CompanyCodeCurrency,
  betr2 AS RevnAcctgPostgAmtInAddlCrcy1,
  hwae2 AS AdditionalCurrency1,
  betr3 AS RevnAcctgPostgAmtInAddlCrcy2,
  hwae3 AS AdditionalCurrency2,
  timestamp AS RAPostingItemLastChgDateTime,
  statistic AS ConditionIsForStatistics,
  cast(gjahr as fis_gjahr preserving type) AS FiscalYear,
  cast(substring(recon_key, 1, 7) as fis_jahrper_conv) AS FiscalYearPeriod,
  invoice_guid AS RevnAcctgInvoiceUUID,
  srcdoc_comp AS RevnAcctgSenderComponent,
  srcdoc_logsys AS RASndgCompLogicalSystem,
  srcdoc_type AS RASndgCompDocumentItemType,
  srcdoc_id AS RASndgCompDocumentItem,
  poper AS FiscalPeriod,
  _RevnAcctgReconciliationKey.RAContrLiabilityAssetIsCalcd AS RAContrLiabilityAssetIsCalcd
FROM farr_d_posting AS post
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_RevnAcctgReconciliationKey AS _RevnAcctgReconciliationKey ON CompanyCode = _RevnAcctgReconciliationKey.CompanyCode AND AccountingPrinciple = _RevnAcctgReconciliationKey.AccountingPrinciple AND RevenueAccountingContract = _RevnAcctgReconciliationKey.RevenueAccountingContract AND RevnAcctgReconciliationKey = _RevnAcctgReconciliationKey.RevnAcctgReconciliationKey  -- association [1..1]
LEFT OUTER JOIN I_RAPerformanceObligation AS _RAPerformanceObligation ON PerformanceObligation = _RAPerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN I_RAPostingCategory AS _RAPostingCategory ON RevnAcctgPostingCategory = _RAPostingCategory.RevnAcctgPostingCategory  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON RevenueAccountingContract = _RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_RevenueAccountingInvoice AS _Invoice ON RevnAcctgInvoiceUUID = _Invoice.RevnAcctgInvoiceUUID  -- association [0..1]
;