P_RO_SAFTCActgJournalItemBase

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 P_RO_SAFTCActgJournalItemBase.
-- 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.
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW P_RO_SAFTCActgJournalItemBase AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.CADocumentNumber AS CADocumentNumber,
  Item.CAItemType AS CAItemType,
  Item.ItemNumber AS ItemNumber,
  Item.SubItemNumber AS SubItemNumber,
  Item.ClearedDocumentNumber AS ClearedDocumentNumber,
  _DocHeader.CASrcDocumentType AS CASrcDocumentType,
  _DocHeader.CASrcDocumentNumber AS CASrcDocumentNumber,
  _DocHeader.CASrcOfficialDocumentNumber AS CASrcOfficialDocumentNumber,
  _DocHeader.CASrcBusinessPartner AS CASrcBusinessPartner,
  _DocHeader.CASrcContractAccount AS CASrcContractAccount,
  _DocHeader.CADocumentTypeForGLTransfer AS CADocumentTypeForGLTransfer,
  _DocHeader.CAInvcgProcess AS CAInvcgProcess,
  _DocHeader.CAInvcgType AS CAInvcgType,
  _DocHeader.CAInvcgCategory AS CAInvcgCategory,
  _DocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _DocHeader.CARecnclnKeyIsTransferredToGL AS CARecnclnKeyIsTransferredToGL,
  Item.BusinessPartner AS BusinessPartner,
  Item.TaxCode AS TaxCode,
  Item.TaxItem AS TaxItem,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.GLAccount AS GLAccount,
  _CompanyCode.CountryChartOfAccounts AS CountryChartOfAccounts,
  _GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccount,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.CADocumentType AS CADocumentType,
  Item.CADocumentOriginCode AS CADocumentOriginCode,
  Item.TaxReportingDate AS TaxReportingDate,
  Item.ValueDate AS ValueDate,
  Item.CreationDate AS CreationDate,
  Item.CreatedByUser AS CreatedByUser,
  Item.CAReconciliationKey AS CAReconciliationKey,
  Item.DocumentItemText AS DocumentItemText,
  Item.CATransactionKeyAccountDetn AS CATransactionKeyAccountDetn,
  _DocHeader.CAReferenceDocument AS CAReferenceDocument,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.ProfitCenter AS ProfitCenter,
  Item.Segment AS Segment,
  Item.BaseUnit AS BaseUnit,
  Item.QuantityInBaseUnit AS QuantityInBaseUnit,
  RO_SAFTCACTGSRCDOCTYPEMAPPG.RO_SAFTSourceDocumentType AS RO_SAFTSourceDocumentType,
  _DocHeader.RO_SAFTJournalTransDescription AS RO_SAFTJournalTransDescription
FROM P_RO_SAFTCActgJournalItemBase0 AS Item
INNER JOIN I_RO_SAFTCActgSrcDocTypeMappg AS RO_SAFTCACTGSRCDOCTYPEMAPPG ON /* join condition not captured in parsed metadata */
INNER JOIN P_RO_SAFTCActgDocumentSrc AS _DocHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
;