P_JEAPI_LOG_DETAIL_POST_LL

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_POST_LL.
-- 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: PJEAPILOGPOS

CREATE VIEW P_JEAPI_LOG_DETAIL_POST_LL AS
SELECT
  item.CnsldtnTaskLogUUID AS CnsldtnTaskLogUUID,
  item.CnsldtnTaskLogItemUUID AS CnsldtnTaskLogItemUUID,
  msg.CnsldtnTskLgMsgNmbr AS CnsldtnTskLgMsgNmbr,
  item.ConsolidationDocumentNumber AS ConsolidationDocumentNumber,
  item.CnsldtnTaskLogItemType AS CnsldtnTaskLogItemType,
  _DocIndi.cnsldtnlineitemtypet AS CnsldtnTaskLogItemTypeTxt,
  item.BillingDocumentTypeText AS BillingDocumentTypeText,
  item.CnsldtnCustomerText AS CnsldtnCustomerText,
  item.SupplierName AS SupplierName,
  item.WBSElement AS WBSElement,
  item.WBSElementInternalID AS WBSElementInternalID,
  item.AssignmentReference AS AssignmentReference,
  item.SoldProduct AS SoldProduct,
  item.SoldProductGroup AS SoldProductGroup,
  item.BillToParty AS BillToParty,
  item.ShipToParty AS ShipToParty,
  item.CnsldtnTskLgItmRowNmbr AS CnsldtnTskLgItmRowNmbr,
  item.CnsldtnTskLgNode AS CnsldtnTskLgNode,
  item.CnsldtnTskLgParNode AS CnsldtnTskLgParNode,
  item.ConsolidationLedger AS ConsolidationLedger,
  'Y1' AS ConsolidationDimension,
  item.ConsolidationVersion AS ConsolidationVersion,
  item.CnsldtnTriggeringAmtLoclCrcy AS CnsldtnTriggeringAmtLoclCrcy,
  item.CnsldtnJrnlEntryAmtLoclCrcy AS CnsldtnJrnlEntryAmtLoclCrcy,
  item.CnsldtnTriggeringAmtGrpCrcy AS CnsldtnTriggeringAmtGrpCrcy,
  item.CnsldtnJrnlEntryAmtGrpCrcy AS CnsldtnJrnlEntryAmtGrpCrcy,
  item.CnsldtnTriggeringAmtTransCrcy AS CnsldtnTriggeringAmtTransCrcy,
  item.CnsldtnJrnlEntryAmtTransCrcy AS CnsldtnJrnlEntryAmtTransCrcy,
  item.CnsldtnTriggeringQtyBaseUnit AS CnsldtnTriggeringQtyBaseUnit,
  item.CnsldtnJrnlEntryQtyBaseUnit AS CnsldtnJrnlEntryQtyBaseUnit,
  item.ConsolidationUnit AS ConsolidationUnit,
  item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  item.FinancialStatementItem AS FinancialStatementItem,
  item.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  item.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  item.ConsolidationGroup AS ConsolidationGroup,
  item.CompanyCode AS CompanyCode,
  item.SubItemCategory AS SubItemCategory,
  item.SubItem AS SubItem,
  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.CnsldtnTriggeringAmtInGrpCrcy AS AMOUNT_GC_TRI,
  item.CnsldtnJrnlEntryAmtInGrpCrcy AS AMOUNT_GC_DOC,
  item.CnsldtnTriggeringAmtInLoclCrcy AS AMOUNT_LC_TRI,
  item.CnsldtnJrnlEntryAmtInLoclCrcy AS AMOUNT_LC_DOC,
  item.CnsldtnTriggeringAmtInTC AS AMOUNT_TC_TRI,
  item.CnsldtnJrnlEntryAmtInTransCrcy AS AMOUNT_TC_DOC,
  item.CnsldtnTriggeringQtyInBsUnt AS QUANTITY_TRI,
  item.CnsldtnJrnlEntryQtyInBsUnt AS QUANTITY_DOC,
  item.PostingDate AS PostingDate,
  item.CnsldtnLogHeaderDateTime AS CnsldtnLogHeaderDateTime,
  item.CurrencyTranslationDate AS CurrencyTranslationDate,
  item.InvestmentActivityType AS InvestmentActivityType,
  item.InvestmentActivity AS InvestmentActivity,
  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 PartnerWBSElementDescription,
  item.CnsldtnProjectText AS CnsldtnProjectText,
  item.SalesOrganizationText AS SalesOrganizationText,
  item.DistributionChannelText AS DistributionChannelText,
  item.OrganizationDivisionText AS OrganizationDivisionText,
  item.SoldMaterial AS SoldMaterial,
  item.ProductGroupText AS ProductGroupText,
  item.CustomerGroup AS CustomerGroup,
  item.CustomerSupplierCountry AS CustomerSupplierCountry,
  item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  item.SalesDistrictText AS SalesDistrictText,
  item.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  item.CnsldtnTaskLogItemIsLatest AS CnsldtnTaskLogItemIsLatest,
  msg.SystemMessageIdentification AS SystemMessageIdentification,
  'S' AS SystemMessageType,
  msg.SystemMessageNumber AS SystemMessageNumber,
  msg.SystemMessageVariable1 AS SystemMessageVariable1,
  msg.SystemMessageVariable2 AS SystemMessageVariable2,
  msg.SystemMessageVariable3 AS SystemMessageVariable3,
  msg.SystemMessageVariable4 AS SystemMessageVariable4,
  cast( '3' as abap.char( 1 ) ) AS SortField,
  concat_with_space(msg.SystemMessageIdentification , msg.SystemMessageNumber, 2) AS CnsldtnTskLgMsgID,
  item.PostingFiscalYear AS PostingFiscalYear,
  item.PostingFiscalPeriod AS PostingFiscalPeriod,
  cast(concat(item.PostingFiscalYear,item.PostingFiscalPeriod) as fincs_fiscalyearper ) AS FiscalYearPeriod
FROM I_CnsldtnTaskLogItem01 AS item
INNER JOIN P_CNSLDTN_DOCINDI AS _DocIndi ON /* join condition not captured in parsed metadata */
;