C_PE_StRpAstJrnlEntryItemC

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_PE_StRpAstJrnlEntryItemC.
-- 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_ReportingPeriodStartDate : fis_rep_period_start_date, P_ReportingCurrency : glo_reporting_currency, P_FiscalYear : fis_gjahr, P_KeyDate : fagl_keydate, P_CurrencyRole : fins_curtype

CREATE VIEW C_PE_StRpAstJrnlEntryItemC AS
SELECT
  GLAccountLineItem.SourceLedger AS SourceLedger,
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.AssetDepreciationArea AS AssetDepreciationArea,
  GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  GLAccountLineItem.FixedAsset AS FixedAsset,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  GLAccountLineItem.AccountingDocument AS AccountingDocument,
  GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  GLAccountLineItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  GLAccountLineItem.GLAccount AS GLAccount,
  GLAccountLineItem.AlternativeGLAccount AS AlternativeGLAccount,
  GLAccountLineItem.DocumentDate AS DocumentDate,
  GLAccountLineItem.PostingDate AS PostingDate,
  cast( $parameters.P_ReportingCurrency as glo_reporting_currency preserving type ) AS ReportingCurrency,
  cast( substring(AssetBalance.FixedAssetDescription,1,40) as txa50_anlt ) AS FixedAssetDescription,
  AssetBalance.AssetAmountInReportingCurrency AS AssetAmountInReportingCurrency,
  AssetBalance.IntngblAstAmtznAmtInRptgCrcy AS IntngblAstAmtznAmtInRptgCrcy
FROM I_GLAccountLineItemRawData AS GLAccountLineItem
INNER JOIN I_StRpJournalEntryHeaderLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
INNER JOIN P_PE_AssetValuationAggrgd ON /* join condition not captured in parsed metadata */
;