R_IntOrdSettlmtHistPerLedgerTP

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 R_IntOrdSettlmtHistPerLedgerTP.
-- 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 R_IntOrdSettlmtHistPerLedgerTP AS
SELECT
  ControllingObject,
  Ledger,
  LedgerGroup,
  SettlementDistributionRuleGrp,
  SettlmtDistrRuleSequence,
  Ledger AS LedgerForEdit,
  LedgerGroup AS LedgerGroupForEdit,
  SettlementDistributionRuleGrp AS SettlmtDistributionRuleGrpFoEd,
  SettlmtDistrRuleSequence AS SettlmtDistrRuleSequenceFoEd,
  SettlementType,
  _SettlmtTypeLanguageDependent.SettlmtTypeLanguageDependent AS SettlmtTypeLanguageDependent,
  AccountAssignmentType,
  _AccountAssignmentTypeT.AcctAsgtTypeLanguageDependent AS AcctAsgtTypeLanguageDependent,
  SettlementReceiver,
  SettlementPercentageRate,
  SettlementEquivalenceFactor,
  SettlementAmount,
  SettlementAmountCurrency,
  ControllingArea,
  CostCenter,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  WBSElementInternalID,
  WBSElementExternalID,
  ProjectNetwork,
  CostObject,
  BusinessProcess,
  BusinessArea,
  AssetTransactionType,
  SalesOrder,
  SalesOrderItem,
  OrderID,
  CompanyCode,
  ProfitCenter,
  MasterFixedAsset,
  FixedAsset,
  GLAccount,
  ValidityStartFiscalPeriod,
  ValidityStartFiscalYear,
  cast(concat(ValidityStartFiscalYear, ValidityStartFiscalPeriod) as fco_stlmt_start_fyearperiod) AS ValidityStartFiscalYearPeriod,
  ValidityEndFiscalPeriod,
  ValidityEndFiscalYear,
  cast(concat(ValidityEndFiscalYear, ValidityEndFiscalPeriod) as fco_stlmt_end_fyearperiod) AS ValidityEndFiscalYearPeriod,
  SettlmtRule1stUsgeFiscalPeriod,
  SettlmtRule1stUsageFiscalYear,
  cast( concat( SettlmtRule1stUsageFiscalYear, SettlmtRule1stUsgeFiscalPeriod ) as fco_stlmt_1stusge_fyearperiod ) AS SettlmtRule1stUsgeFsclYrPeriod,
  SettlmtRuleLastUsgeFsclPeriod,
  SettlmtRuleLastUsageFiscalYear,
  cast( concat( SettlmtRuleLastUsageFiscalYear, SettlmtRuleLastUsgeFsclPeriod ) as fco_stlmt_lastusge_fyearperiod ) AS SettlmtRuleLastUsgeFsclYrPerd,
  SettlmtTracingFctrDetnMethod,
  SettlementDistrAmountRuleType,
  SettlmtDistrRuleSrceAssignment,
  SettlementSourceStructure,
  SettlmtDistributionRuleNumber,
  SettlmtDistrManipulationRule,
  SettlmtRuleAutomStrategyGnrtn,
  SettlementDistrRuleRmngAmount,
  NetworkActivityInternalID,
  ProjectNetworkInternalID,
  NetworkActivity,
  SettlmtWithFreeDefinedCurrency,
  InternalOrder,
  OrderType,
  InternalOrderCompanyCode,
  OperatingConcern,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  _IntOrderSettlementRuleTP.ControllingSettlementProfile AS ControllingSettlementProfile
FROM I_IntOrderSettlementDistrRule
LEFT OUTER JOIN R_IntOrdSettlmtHistPerLdgrRETP AS _IntOrdSettlmtHistPerLdgrRETP ON /* condition not available in parsed metadata */  -- association [0..1]
;