C_IntOrdSettlementDistrRuleTP

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_IntOrdSettlementDistrRuleTP.
-- 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_IntOrdSettlementDistrRuleTP AS
SELECT
  ControllingObject,
  Ledger,
  LedgerGroup,
  SettlementDistributionRuleGrp,
  SettlmtDistrRuleSequence,
  ControllingObjectForEdit,
  LedgerForEdit,
  LedgerGroupForEdit,
  SettlmtDistrRuleSequenceFoEd,
  _Ledger._Text.LedgerName : localized AS LedgerNamelocalized,
  _LedgerGroup._Text.LedgerGroupName : localized AS LedgerGroupNamelocalized,
  InternalOrder,
  SettlementReceiver,
  SettlementPercentageRate,
  SettlementAmount,
  SettlementAmountCurrency,
  _Currency._Text.CurrencyName : localized AS CurrencyNamelocalized,
  SettlmtTypeLanguageDependent,
  _SettlementType._Text.SettlementTypeDesc : localized AS SettlementTypeDesclocalized,
  SettlementType,
  AcctAsgtTypeLanguageDependent,
  _AccountAssignmentTypeT.AccountAssignmentTypeDesc AS AccountAssignmentTypeDesc,
  AccountAssignmentType,
  SettlementEquivalenceFactor,
  SettlmtTracingFctrDetnMethod,
  _SettlmtTracingFctrDetnMethod._Text.SettlmtTracingFctrDetnMethName : localized AS SettlmtTracingFctrDetnMethNamelocalized,
  SettlementDistrAmountRuleType,
  _SettlmtDistrAmountRuleType._Text.SettlementDistrAmtRuleTypeName : localized AS SettlementDistrAmtRuleTypeNamelocalized,
  SettlmtDistrRuleSrceAssignment,
  _SourceStructureAssignment._Text.CtrlgStructureAssignmentName : localized AS CtrlgStructureAssignmentNamelocalized,
  SettlementSourceStructure,
  SettlmtDistributionRuleNumber,
  SettlmtDistrManipulationRule,
  _JntVntrMnpltnRuleRecoveryInd._Text.SettlmtDistrMnpltnRuleName : localized AS SettlmtDistrMnpltnRuleNamelocalized,
  SettlmtRuleAutomStrategyGnrtn,
  _SettlementAutomGnrtnStrategy._Text.SettlmtRuleAutomStrgyGnrtnDesc : localized AS SettlmtRuleAutomStrgyGnrtnDesclocalized,
  SettlmtWithFreeDefinedCurrency,
  _SettlmtWithFreeDfndCurrency._Text.SettlmtWithFreeDefinedCrcyName : localized AS SettlmtWithFreeDefinedCrcyNamelocalized,
  SettlementDistrRuleRmngAmount,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CostCenter,
  _CostCenter[ 1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text.CostCenterName : localized AS CostCenterNamelocalized,
  ProfitabilitySegment,
  ProfitabilitySegmentIsAssigned,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  ProjectNetwork,
  _ProjectNetworkBasicData.ProjectNetworkDescription AS ProjectNetworkDescription,
  NetworkActivityInternalID,
  ProjectNetworkInternalID,
  NetworkActivity,
  _NetworkActivityByInternalKey.NetworkActivityDescription AS NetworkActivityDescription,
  CostObject,
  BusinessProcess,
  _BusinessProcess._Text[1: Language = $session.system_language].BusinessProcessName AS BusinessProcessName,
  SalesOrder,
  SalesOrderItem,
  _SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  ProfitCenter,
  _ProfitCenter[ 1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text.ProfitCenterName : localized AS ProfitCenterNamelocalized,
  OrderID,
  _OrderID.OrderDescription AS OrderDescription,
  _OrderID.OrderCategory AS OrderCategory,
  OrderType,
  WBSElementInternalID,
  WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  GLAccount,
  _GLAccount._Text.GLAccountName : localized AS GLAccountNamelocalized,
  BusinessArea,
  AssetTransactionType,
  _AssetTransactionType._Text.AssetTransactionTypeName : localized AS AssetTransactionTypeNamelocalized,
  ControllingSettlementProfile,
  InternalOrderCompanyCode,
  OperatingConcern,
  _InternalOrderCompanyCode.CompanyCodeName AS InternalOrderCompanyCodeName,
  SettlmtDistrRuleIsUsedInLedger,
  ServiceDocumentType,
  _AcctgServiceDocumentType.ServiceDocumentTypeName AS ServiceDocumentTypeName,
  ServiceDocument,
  ServiceDocumentItem,
  _AcctgSrvcDocumentItemBasic.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  SettlmtRule1stUsgeFiscalPeriod,
  SettlmtRule1stUsageFiscalYear,
  SettlmtRule1stUsgeFsclYrPeriod,
  SettlmtRuleLastUsgeFsclPeriod,
  SettlmtRuleLastUsageFiscalYear,
  SettlmtRuleLastUsgeFsclYrPerd,
  ValidityStartFiscalPeriod,
  ValidityStartFiscalYear,
  ValidityStartFiscalYearPeriod,
  ValidityEndFiscalPeriod,
  ValidityEndFiscalYear,
  ValidityEndFiscalYearPeriod
FROM R_IntOrdSettlementDistrRuleTP
;