C_CnsldtnPostingRuleLogItem

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_CnsldtnPostingRuleLogItem.
-- 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 C_CnsldtnPostingRuleLogItem AS
SELECT
  CnsldtnPostingRuleLogUUID,
  FiscalYear,
  ConsolidationRunNumber,
  ConsolidationPostingRule,
  CnsldtnPostgRuleSourceLine,
  CnsldtnPostingPackageNumber,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  HierarchyNode,
  _CnsldtnRule._ConsolidationPostingRuleText.ConsolidationPostingRuleText : localized AS ConsolidationPostingRuleTextlocalized,
  NodeType,
  ConsolidationPostingRuleGroup,
  _CnsldtnRuleGroup._CnsldtnPostingRuleGroupText.CnsldtnPostingRuleGroupText : localized AS CnsldtnPostingRuleGroupTextlocalized,
  CnsldtnPostingRuleSequence,
  CnsldtnPostgRuleLogItemType,
  CnsldtnTaskLogItemTypeTxt,
  ConsolidationUnit,
  _CnsldtnUnit._Text.ConsolidationUnitText : localized AS ConsolidationUnitTextlocalized,
  PartnerConsolidationUnit,
  FinancialStatementItem,
  _FinStmntItm._Text.FinancialStatementItemText : localized AS FinancialStatementItemTextlocalized,
  CnsldtnSubitemCategory,
  _SubItemCategory._Text.CnsldtnSubitemCategoryText : localized AS CnsldtnSubitemCategoryTextlocalized,
  CnsldtnSubitem,
  _SubItem._Text.CnsldtnSubitemText : localized AS CnsldtnSubitemTextlocalized,
  ConsolidationDocumentType,
  _DocumentType._Text.ConsolidationDocumentTypeText : localized AS ConsolidationDocumentTypeTextlocalized,
  CnsldtnSrceAmtInTransCrcy,
  CnsldtnSrceAmtInLoclCrcy,
  CnsldtnSrceAmtInGrpCrcy,
  CnsldtnSrceQtyInBaseUnit,
  CnsldtnJrnlEntryAmtInTransCrcy,
  CnsldtnJrnlEntryAmtInLoclCrcy,
  CnsldtnJrnlEntryAmtInGrpCrcy,
  CnsldtnJrnlEntryQtyInBsUnt,
  BaseUnit,
  TransactionCurrency,
  GroupCurrency,
  LocalCurrency,
  GLAccount,
  CnsldtnAdhocItem,
  _AdhocItem._Text.CnsldtnAdhocItemText : localized AS CnsldtnAdhocItemTextlocalized,
  CnsldtnAdhocSet,
  _AdhocSet._Text.CnsldtnAdhocSetText : localized AS CnsldtnAdhocSetTextlocalized,
  CnsldtnAdhocSetItem,
  _AdhocSetItem.CnsldtnAdhocSetItemText AS CnsldtnAdhocSetItemText,
  ConsolidationPostgItemAutoFlag,
  BillingDocumentType,
  FinancialServicesBranch,
  _FinancialServicesBranchT._Text.FinancialServicesBranchName : localized AS FinancialServicesBranchNamelocalized,
  CashLedgerAccount,
  CnsldtnCashLedgerChartOfAccts,
  PartnerFund,
  ControllingArea,
  _ControllingArea._Text.ControllingAreaName : localized AS ControllingAreaNamelocalized,
  CostCenter,
  _CostCenter._Text.CostCenterName : localized AS CostCenterNamelocalized,
  CurrencyConversionsDiffType,
  Customer,
  CustomerGroup,
  FinancialDataSource,
  _FinancialDataSourceT._Text.FinancialDataSourceName : localized AS FinancialDataSourceNamelocalized,
  FinancialManagementArea,
  _FinancialManagementAreaText._Text.FinancialManagementAreaName : localized AS FinancialManagementAreaNamelocalized,
  FunctionalArea,
  _FunctionalArea._Text.FunctionalAreaName : localized AS FunctionalAreaNamelocalized,
  Fund,
  _FundText._Text.FundName : localized AS FundNamelocalized,
  GHGCategory,
  _GHGCategoryText._Text.GHGCategoryName : localized AS GHGCategoryNamelocalized,
  GHGScope2CalculationMethod,
  GHGScope,
  _GHGScopeText._Text.GHGScopeName : localized AS GHGScopeNamelocalized,
  GrantID,
  InvesteeConsolidationUnit,
  Material,
  _Material._Text.MaterialName : localized AS MaterialNamelocalized,
  SustainabilityModeOfTransport,
  _SustainabilityModeOfTransport._Text.SustModeOfTransportName : localized AS SustModeOfTransportNamelocalized,
  PartnerFunctionalArea,
  PartnerProfitCenter,
  PartnerSegment,
  _PartnerSegment._Text.SegmentName as PartnerSegmentName : localized AS SegmentNameasPartnerSegmentNamelocalized,
  FinancialServicesProductGroup,
  SoldMaterial,
  ProductGroup,
  ProfitCenter,
  _ProfitCenter._Text.ProfitCenterName : localized AS ProfitCenterNamelocalized,
  Segment,
  _PartnerSegment._Text.SegmentName : localized AS SegmentNamelocalized,
  PartnerCostCenter,
  FinancialTransactionType,
  ConsolidationAcquisitionYear,
  Supplier,
  BillToParty,
  BusinessArea,
  ConsolidationChartOfAccounts,
  PartnerCompany,
  CustomerSupplierCountry,
  DistributionChannel,
  OrganizationDivision,
  CustomerSupplierCorporateGroup,
  CustomerSupplierIndustry,
  OrderID,
  Plant,
  SalesDistrict,
  SalesOrganization,
  ShipToParty,
  ConsolidationVersion,
  CnsldtnPostgRuleVariable1Value,
  CnsldtnPostingRuleVariable1,
  CnsldtnPostgRuleVariable2Value,
  CnsldtnPostingRuleVariable2,
  CnsldtnPostgRuleVariable3Value,
  CnsldtnPostingRuleVariable3,
  CnsldtnPostgRuleVariable4Value,
  CnsldtnPostingRuleVariable4,
  CnsldtnPostgRuleVariable5Value,
  CnsldtnPostingRuleVariable5,
  CnsldtnPostgRuleVariable6Value,
  CnsldtnPostingRuleVariable6,
  CnsldtnPostgRule1stExchRate,
  CnsldtnPstRl1stExchRateText,
  CnsldtnPostgRule2ndExchRate,
  CnsldtnPstRl2ndExchRateText,
  CnsldtnPostgRule3rdExchRate,
  CnsldtnPstRl3rdExchRateText,
  CnsldtnPostgRule4thExchRate,
  CnsldtnPstRl4thExchRateText,
  CnsldtnPostgRule5thExchRate,
  CnsldtnPstRl5thExchRateText,
  CnsldtnPostgRule6thExchRate,
  CnsldtnPstRl6thExchRateText,
  CnsldtnPstRlSrceCnsldtnVersion,
  CnsldtnPstRlSrceCnsldtnUnt
FROM I_CnsldtnPostingRuleLogItem
;