What is C_ProjSettlmtRuleDistrRuleTP in SAP S/4HANA?

C_ProjSettlmtRuleDistrRuleTP is a consumption CDS view in SAP S/4HANA. Settlement Distribution Rule for Project It contains 81 fields.

Which tables does C_ProjSettlmtRuleDistrRuleTP read from?

C_ProjSettlmtRuleDistrRuleTP reads data from: R_ProjSettlmtRuleDistrRuleTP.

What VDM layer is C_ProjSettlmtRuleDistrRuleTP?

C_ProjSettlmtRuleDistrRuleTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ProjSettlmtRuleDistrRuleTP

DDL: C_PROJSETTLMTRULEDISTRRULETP Type: view_entity CONSUMPTION

81 Fields 1 Data Sources

Settlement Distribution Rule for Project

C_ProjSettlmtRuleDistrRuleTP is a Consumption CDS View that provides data about "Settlement Distribution Rule for Project" in SAP S/4HANA. It reads from 1 data source (R_ProjSettlmtRuleDistrRuleTP) and exposes 81 fields with key fields ControllingObject, Ledger, LedgerGroup, SettlementDistributionRuleGrp, SettlmtDistrRuleSequence.

Data Sources (1)

Source	Alias	Join Type
R_ProjSettlmtRuleDistrRuleTP	R_ProjSettlmtRuleDistrRuleTP	projection

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Settlement Distribution Rule for Project	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view

Fields (81)

Key	Field	Source Table	Source Field	Description
KEY	ControllingObject		ControllingObject	Object number
KEY	Ledger		Ledger	Ledger
KEY	LedgerGroup		LedgerGroup	Ledger Group
KEY	SettlementDistributionRuleGrp		SettlementDistributionRuleGrp
KEY	SettlmtDistrRuleSequence		SettlmtDistrRuleSequence
	SettlementType		SettlementType	Settlement Type
	ValidityStartFiscalYear		ValidityStartFiscalYear
	ValidityStartFiscalPeriod		ValidityStartFiscalPeriod
	ValidityStartFiscalYearPeriod		ValidityStartFiscalYearPeriod
	ValidityEndFiscalYear		ValidityEndFiscalYear
	ValidityEndFiscalPeriod		ValidityEndFiscalPeriod
	ValidityEndFiscalYearPeriod		ValidityEndFiscalYearPeriod
	SettlmtRule1stUsageFiscalYear		SettlmtRule1stUsageFiscalYear
	SettlmtRule1stUsgeFiscalPeriod		SettlmtRule1stUsgeFiscalPeriod
	SettlmtRule1stUsgeFsclYrPeriod		SettlmtRule1stUsgeFsclYrPeriod
	SettlmtRuleLastUsageFiscalYear		SettlmtRuleLastUsageFiscalYear
	SettlmtRuleLastUsgeFsclPeriod		SettlmtRuleLastUsgeFsclPeriod
	SettlmtRuleLastUsgeFsclYrPerd		SettlmtRuleLastUsgeFsclYrPerd
	SettlementPercentageRate		SettlementPercentageRate
	SettlementEquivalenceFactor		SettlementEquivalenceFactor
	SettlementAmount		SettlementAmount
	SettlementAmountCurrency		SettlementAmountCurrency
	SettlementDistrAmountRuleType		SettlementDistrAmountRuleType
	SettlementDistrAmtRuleTypeNamelocalized
	SettlmtRuleAutomStrategyGnrtn		SettlmtRuleAutomStrategyGnrtn
	SettlmtRuleAutomStrgyGnrtnDesclocalized
	SettlmtDistrManipulationRule		SettlmtDistrManipulationRule
	SettlmtDistrMnpltnRuleNamelocalized
	SettlmtDistrRuleSrceAssignment		SettlmtDistrRuleSrceAssignment
	CtrlgStructureAssignmentNamelocalized
	SettlmtDistributionRuleNumber		SettlmtDistributionRuleNumber
	AccountAssignmentType		AccountAssignmentType	Sndr AcctAssgmt Type
	AccountAssignmentTypeName
	SettlementReceiver		SettlementReceiver
	SettlementDefaultRule		SettlementDefaultRule
	Material		Material	Vehicle Model
	GLAccount		GLAccount	General Ledger
	GLAccountNamelocalized
	ProfitCenter		ProfitCenter	Profit Center
	ProfitCenterNamelocalized
	BusinessArea		BusinessArea	Business Area
	BusinessAreaNamelocalized
	CostCenter		CostCenter	Cost Center
	CostCenterNamelocalized
	OrderID		OrderID	Order ID
	OrderDescription	_OrderID	OrderDescription
	OrderCategory		OrderCategory	Order Category
	OrderItem		OrderItem
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	WBSElementExternalID		WBSElementExternalID	WBS Element External ID
	LanguageBasedShortText
	MasterFixedAsset		MasterFixedAsset	Fixed Asset
	MasterFixedAssetDescription	_MasterFixedAsset	MasterFixedAssetDescription
	FixedAsset		FixedAsset	Sub-number
	FixedAssetDescription	_FixedAsset	FixedAssetDescription	Description
	AssetTransactionType		AssetTransactionType	Trans.Type
	AssetTransactionTypeNamelocalized
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	ProfitabilitySegment		ProfitabilitySegment	Profitability Segment
	ProfitabilitySegment_2		ProfitabilitySegment_2	Profit. segment
	SalesOrder		SalesOrder	SD Document
	SalesOrderItem		SalesOrderItem	Sales Order Item
	SalesOrderItemText	_SalesOrderItem	SalesOrderItemText
	BusinessProcess		BusinessProcess	Business Process
	BusinessProcessName
	SettlementDistrRuleRmngAmount		SettlementDistrRuleRmngAmount
	ControllingArea		ControllingArea	Controlling Area
	SettlmtTracingFctrDetnMethod		SettlmtTracingFctrDetnMethod
	SettlementSourceStructure		SettlementSourceStructure
	DistributionRuleGroupIsHidden		DistributionRuleGroupIsHidden
	virtualDistrRuleREAssgmtObjectTexttext60
	LedgerGroupNamelocalized
	ServiceDocumentType		ServiceDocumentType	Transaction Type
	ServiceDocumentTypeNamelocalized
	ServiceDocument		ServiceDocument	Transaction ID
	ServiceDocumentItem		ServiceDocumentItem	Service Document
	ServiceDocumentItemDescription	_ServiceDocumentItem	ServiceDocumentItemDescription
	SettlmtTypeLanguageDependent	_SettlmtTypeLanguageDependent	SettlmtTypeLanguageDependent
	SettlementTypeDesclocalized
	SettlmtWithFreeDefinedCurrency		SettlmtWithFreeDefinedCurrency

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_ProjSettlmtRuleDistrRuleTP.
-- 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_ProjSettlmtRuleDistrRuleTP AS
SELECT
  ControllingObject,
  Ledger,
  LedgerGroup,
  SettlementDistributionRuleGrp,
  SettlmtDistrRuleSequence,
  SettlementType,
  ValidityStartFiscalYear,
  ValidityStartFiscalPeriod,
  ValidityStartFiscalYearPeriod,
  ValidityEndFiscalYear,
  ValidityEndFiscalPeriod,
  ValidityEndFiscalYearPeriod,
  SettlmtRule1stUsageFiscalYear,
  SettlmtRule1stUsgeFiscalPeriod,
  SettlmtRule1stUsgeFsclYrPeriod,
  SettlmtRuleLastUsageFiscalYear,
  SettlmtRuleLastUsgeFsclPeriod,
  SettlmtRuleLastUsgeFsclYrPerd,
  SettlementPercentageRate,
  SettlementEquivalenceFactor,
  SettlementAmount,
  SettlementAmountCurrency,
  SettlementDistrAmountRuleType,
  _SettlmtDistrAmountRuleType._Text.SettlementDistrAmtRuleTypeName: localized AS SettlementDistrAmtRuleTypeNamelocalized,
  SettlmtRuleAutomStrategyGnrtn,
  _SettlementAutomGnrtnStrategy._Text.SettlmtRuleAutomStrgyGnrtnDesc: localized AS SettlmtRuleAutomStrgyGnrtnDesclocalized,
  SettlmtDistrManipulationRule,
  _JntVntrMnpltnRuleRecoveryInd._Text.SettlmtDistrMnpltnRuleName: localized AS SettlmtDistrMnpltnRuleNamelocalized,
  SettlmtDistrRuleSrceAssignment,
  _SourceStructureAssignment._Text.CtrlgStructureAssignmentName: localized AS CtrlgStructureAssignmentNamelocalized,
  SettlmtDistributionRuleNumber,
  AccountAssignmentType,
  _AccountAssignmentTypeT[ Language = $session.system_language ].AccountAssignmentTypeName AS AccountAssignmentTypeName,
  SettlementReceiver,
  SettlementDefaultRule,
  Material,
  GLAccount,
  _GLAccount._Text.GLAccountName : localized AS GLAccountNamelocalized,
  ProfitCenter,
  _ProfitCenter[ 1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text.ProfitCenterName : localized AS ProfitCenterNamelocalized,
  BusinessArea,
  _BusinessArea._Text.BusinessAreaName : localized AS BusinessAreaNamelocalized,
  CostCenter,
  _CostCenter[ 1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text.CostCenterName : localized AS CostCenterNamelocalized,
  OrderID,
  _OrderID.OrderDescription AS OrderDescription,
  OrderCategory,
  OrderItem,
  WBSElementInternalID,
  WBSElementExternalID,
  _WBSElementBasicData._WBSElementShortText.LanguageBasedShortText AS LanguageBasedShortText,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  AssetTransactionType,
  _AssetTransactionType._Text.AssetTransactionTypeName : localized AS AssetTransactionTypeNamelocalized,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  SalesOrder,
  SalesOrderItem,
  _SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  BusinessProcess,
  _BusinessProcess._Text[1: Language = $session.system_language].BusinessProcessName AS BusinessProcessName,
  SettlementDistrRuleRmngAmount,
  ControllingArea,
  SettlmtTracingFctrDetnMethod,
  SettlementSourceStructure,
  DistributionRuleGroupIsHidden,
  virtual DistrRuleREAssgmtObjectText : text60 AS virtualDistrRuleREAssgmtObjectTexttext60,
  _LedgerGroup._Text.LedgerGroupName: localized AS LedgerGroupNamelocalized,
  ServiceDocumentType,
  _ServiceDocumentType._ServiceDocumentTypeText.ServiceDocumentTypeName: localized AS ServiceDocumentTypeNamelocalized,
  ServiceDocument,
  ServiceDocumentItem,
  _ServiceDocumentItem.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  _SettlmtTypeLanguageDependent.SettlmtTypeLanguageDependent AS SettlmtTypeLanguageDependent,
  _SettlmtTypeLanguageDependent._SettlementType._Text.SettlementTypeDesc: localized AS SettlementTypeDesclocalized,
  SettlmtWithFreeDefinedCurrency
FROM R_ProjSettlmtRuleDistrRuleTP
;

Depth:

C_ProjSettlmtRuleDistrRuleTP view_entity

R_ProjSettlmtRuleDistrRuleTP view_entity