P_JEAPI_LOG_DETAIL

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_JEAPI_LOG_DETAIL.
-- 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.
-- SQL view name: PJEAPILOG

CREATE VIEW P_JEAPI_LOG_DETAIL AS
SELECT
  item.CnsldtnTaskLogUUID AS CnsldtnTaskLogUUID,
  item.CnsldtnTaskLogItemUUID AS CnsldtnTaskLogItemUUID,
  item.ConsolidationDocumentNumber AS ConsolidationDocumentNumber,
  item.CnsldtnTaskLogItemType AS CnsldtnTaskLogItemType,
  item.CnsldtnTaskLogItemTypeTxt AS CnsldtnTaskLogItemTypeTxt,
  item.BillingDocumentTypeText AS BillingDocumentTypeText,
  item.CnsldtnCustomerText AS CnsldtnCustomerText,
  item.SupplierName AS SupplierName,
  item.WBSElementInternalID AS WBSElementInternalID,
  item.AssignmentReference AS AssignmentReference,
  item.SoldProduct AS SoldProduct,
  item.SoldProductGroup AS SoldProductGroup,
  item.BillToParty AS BillToParty,
  item.ShipToParty AS ShipToParty,
  _DocIndi[1: Language = $session.system_language].cnsldtnlineitemtypet AS DOCINDICATOR,
  _CnsldtnUnitText[1: Language = $session.system_language].ConsolidationUnitMdmText AS CNSLDTNUNITMDMTEXT,
  _CnsldtnPUnitText[1:Language = $session.system_language].ConsolidationUnitMdmText AS CNSLDTNPUNITMDMTEXT,
  _CnsldtnSubItemCategoryText[1: Language = $session.system_language].SubItemCategoryText AS CNSLDTNSUBITEMCATTEXT,
  _CnsldtnSubItemText[1: Language = $session.system_language].SubItemMediumText AS CNSLDTNSUBITEMTEXT,
  _CnsldtnFinStmntItemText[1: Language = $session.system_language].FinancialStatementItemMdmText AS CNSLDTNFSITMMT,
  item.CnsldtnTskLgItmRowNmbr AS CnsldtnTskLgItmRowNmbr,
  item.CnsldtnTskLgNode AS CnsldtnTskLgNode,
  item.CnsldtnTskLgParNode AS CnsldtnTskLgParNode,
  item.ConsolidationLedger AS ConsolidationLedger,
  item.ConsolidationDimension AS ConsolidationDimension,
  item.ConsolidationVersion AS ConsolidationVersion,
  item.CnsldtnTriggeringAmtLoclCrcy AS LC_TRI_CURRENCY,
  item.CnsldtnJrnlEntryAmtLoclCrcy AS LC_DOC_CURRENCY,
  item.CnsldtnTriggeringAmtGrpCrcy AS GC_TRI_CURRENCY,
  item.CnsldtnJrnlEntryAmtGrpCrcy AS GC_DOC_CURRENCY,
  item.CnsldtnTriggeringAmtTransCrcy AS TC_TRI_CURRENCY,
  item.CnsldtnJrnlEntryAmtTransCrcy AS TC_DOC_CURRENCY,
  item.CnsldtnTriggeringQtyBaseUnit AS TRI_BASEUNIT,
  item.CnsldtnJrnlEntryQtyBaseUnit AS DOC_BASEUNIT,
  item.ConsolidationUnit AS ConsolidationUnit,
  concat(concat(item.ConsolidationUnit,'('),concat(_CnsldtnUnitText[1: Language = $session.system_language].ConsolidationUnitMdmText,')')) AS cnsldtnunitEH,
  item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  item.FinancialStatementItem AS FinancialStatementItem,
  item.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  concat(concat(item.FinancialStatementItem,'('),concat(_CnsldtnFinStmntItemText[1: Language = $session.system_language].FinancialStatementItemMdmText,')')) AS cnsldtnfinstmntitmEH,
  item.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  concat(concat(item.PartnerConsolidationUnit,'('),concat(_CnsldtnUnitText[1: Language = $session.system_language].ConsolidationUnitMdmText,')')) AS cnsldtnpartnerunitEH,
  item.ConsolidationGroup AS ConsolidationGroup,
  item.CompanyCode AS CompanyCode,
  item.SubItemCategory AS SubItemCategory,
  concat(concat(item.SubItemCategory,'('),concat(_CnsldtnSubItemCategoryText[1: Language = $session.system_language].SubItemCategoryText,')')) AS cnsldtnfstmntsubitmcatEH,
  item.SubItem AS SubItem,
  concat(concat(item.SubItem,'('),concat(_CnsldtnSubItemText[1: Language = $session.system_language].SubItemMediumText,')')) AS cnsldtnfstmntsubitmEH,
  item.PostingLevel AS PostingLevel,
  item.ConsolidationApportionment AS ConsolidationApportionment,
  item.CurrencyConversionsDiffType AS CurrencyConversionsDiffType,
  item.ConsolidationDocumentType AS ConsolidationDocumentType,
  item.ConsolidationAcquisitionYear AS ConsolidationAcquisitionYear,
  item.ConsolidationAcquisitionPeriod AS ConsolidationAcquisitionPeriod,
  item.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  item.ChartOfAccountsText AS ChartOfAccountsText,
  item.GLAccountText AS GLAccountText,
  item.CostCenterText AS CostCenterText,
  item.ProfitCenterText AS ProfitCenterText,
  item.FunctionalAreaText AS FunctionalAreaText,
  item.BusinessAreaText AS BusinessAreaText,
  item.ControllingAreaText AS ControllingAreaText,
  item.CnsldtnSegmentText AS CnsldtnSegmentText,
  item.PartnerCostCenter AS PartnerCostCenter,
  item.PartnerProfitCenterText AS PartnerProfitCenterText,
  item.PartnerFunctionalAreaText AS PartnerFunctionalAreaText,
  item.PartnerBusinessAreaText AS PartnerBusinessAreaText,
  item.PartnerCompanyText AS PartnerCompanyText,
  item.PartnerSegmentText AS PartnerSegmentText,
  item.OrderID AS OrderID,
  item.CnsldtnMaterialText AS CnsldtnMaterialText,
  item.MaterialGroupName AS MaterialGroupName,
  item.CnsldtnPlantText AS CnsldtnPlantText,
  item.FinancialTransactionType AS FinancialTransactionType,
  item.PartnerWBSElementDescription AS wbsElement,
  item.CnsldtnProjectText AS CnsldtnProjectText,
  item.SalesOrganizationText AS SalesOrganizationText,
  item.DistributionChannelText AS DistributionChannelText,
  item.OrganizationDivisionText AS OrganizationDivisionText,
  item.CustomerGroup AS CustomerGroup,
  item.CustomerSupplierCountry AS CustomerSupplierCountry,
  item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  item.SalesDistrictText AS SalesDistrictText,
  item.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  item.CnsldtnTaskLogItemIsLatest AS CnsldtnTaskLogItemIsLatest,
  cast( 0 as fincs_logmessageno ) AS CnsldtnTskLgMsgNmbr,
  msgtyp[1: Language = $session.system_language].MessageTypet AS MessageType,
  ' ' AS MessageText,
  cast(' ' as syst_msgid ) AS SystemMessageIdentification,
  msg.SystemMessageType AS SystemMessageType,
  cast (' ' as syst_msgno) AS SystemMessageNumber,
  ' ' AS SystemMessageVariable1,
  ' ' AS SystemMessageVariable2,
  ' ' AS SystemMessageVariable3,
  ' ' AS SystemMessageVariable4,
  ' ' AS CnsldtnTskLgMsgID,
  item.PostingFiscalYear AS PostingFiscalYear,
  item.PostingFiscalPeriod AS PostingFiscalPeriod,
  item.AMOUNT_GC_TRI AS AMOUNT_GC_TRI,
  item.AMOUNT_GC_DOC AS AMOUNT_GC_DOC,
  item.AMOUNT_LC_TRI AS AMOUNT_LC_TRI,
  item.AMOUNT_LC_DOC AS AMOUNT_LC_DOC,
  item.AMOUNT_TC_TRI AS AMOUNT_TC_TRI,
  item.AMOUNT_TC_DOC AS AMOUNT_TC_DOC,
  item.QUANTITY_TRI AS QUANTITY_TRI,
  item.QUANTITY_DOC AS QUANTITY_DOC,
  item.SortField AS SortField,
  item.SystemMessageTypeSortOrder AS SystemMessageTypeSortOrder,
  item.FiscalYearPeriod AS FiscalYearPeriod
FROM I_CnsldtnTaskLogItem01 AS item
LEFT OUTER JOIN P_JEAPI_LOG_DETAIL_PRE AS msg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CNSLDTN_DOCINDI AS _DocIndi ON item.CnsldtnTaskLogItemType = _DocIndi.cnsldtnlineitemtype  -- association [0..1]
LEFT OUTER JOIN P_CNSLDTN_MSGTYPE AS msgtyp ON msg.SystemMessageType = msgtyp.MessageType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitT AS _CnsldtnUnitText ON ConsolidationUnit = _CnsldtnUnitText.ConsolidationUnit AND ConsolidationDimension = _CnsldtnUnitText.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitT AS _CnsldtnPUnitText ON PartnerConsolidationUnit = _CnsldtnPUnitText.ConsolidationUnit AND ConsolidationDimension = _CnsldtnPUnitText.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _CnsldtnFinStmntItemText ON FinancialStatementItem = _CnsldtnFinStmntItemText.FinancialStatementItem AND ConsolidationChartOfAccounts = _CnsldtnFinStmntItemText.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategoryText AS _CnsldtnSubItemCategoryText ON SubItemCategory = _CnsldtnSubItemCategoryText.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemText AS _CnsldtnSubItemText ON SubItem = _CnsldtnSubItemText.SubItem AND SubItemCategory = _CnsldtnSubItemText.SubItemCategory  -- association [0..1]
-- UNION with additional select branch(es): P_JEAPI_LOG_DETAIL_PRE
;