C_IntOrderSettlementRuleTP

DDL: C_INTORDERSETTLEMENTRULETP Type: view_entity CONSUMPTION Package: RAP_FIN_CO_IO_SETTLMTRULE_UI
50 Fields 1 Data Sources 2 Associations 1 OData Services

Internal Order Settlement Rule

C_IntOrderSettlementRuleTP is a Consumption CDS View that provides data about "Internal Order Settlement Rule" in SAP S/4HANA. It reads from 1 data source (R_IntOrderSettlementRuleTP) and exposes 50 fields with key field ControllingObject. It has 2 associations to related views. It is exposed through 1 OData service (UI_INTORDSETTLEMENTRULE_MANAGE). Part of development package RAP_FIN_CO_IO_SETTLMTRULE_UI.

Data Sources (1)

SourceAliasJoin Type
R_IntOrderSettlementRuleTP R_IntOrderSettlementRuleTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_IntOrderActiveUserStatus _IntOrderActiveUserStatus $projection.ControllingObject = _IntOrderActiveUserStatus.StatusObject
[0..*] C_IntOrderActiveSystemStatus _IntOrderActiveSystemStatus $projection.ControllingObject = _IntOrderActiveSystemStatus.StatusObject

Annotations (7)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Internal Order Settlement Rule view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_INTORDSETTLEMENTRULE_MANAGE UI_INTORDSETTLRULE_MANAGE V2 C1 NOT_RELEASED

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject Object number
CtrlgObjectSettlementRuleName CtrlgObjectSettlementRuleName
ControllingSettlementProfile ControllingSettlementProfile Settlement Profile
CtrlgSettlementProfileNamelocalized
InternalOrder InternalOrder Order
InternalOrderDescription InternalOrderDescription Description
OrderType OrderType Order Type
OrderTypeNamelocalized
InternalOrderLastChangedByUser InternalOrderLastChangedByUser
IntOrderLastChangedByUserName _IntOrderLastChangedByUser FullName Name
InternalOrderLastChangeDate InternalOrderLastChangeDate
CreatedByUser CreatedByUser User Name
CreatedByUserName _CreatedByUser FullName Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName _LastChangedByUser FullName Name
LastChangeDate LastChangeDate Time Stamp
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
AllocationStructure AllocationStructure Alloc.Structure
AllocationStructureTextlocalized
ProfitabilityAcctgTransfStruc ProfitabilityAcctgTransfStruc
PrftbltyAcctgTransfStrucNamelocalized
AssetValueDate AssetValueDate Reference date
SettlmtRuleAutoGnrtnStrgySqnc SettlmtRuleAutoGnrtnStrgySqnc
SettlmtRuleGnrtnStrgySqncNamelocalized
SettlmtRuleProcessingSequence SettlmtRuleProcessingSequence
SettlementSourceStructure SettlementSourceStructure
ControllingStructureNamelocalized
SettlmtWithFreeDefinedCurrency SettlmtWithFreeDefinedCurrency
SettlmtWithFreeDefinedCrcyNamelocalized
SettlmtParlLedgersIsInactive SettlmtParlLedgersIsInactive
IntOrdSettlementRuleIsCreated IntOrdSettlementRuleIsCreated Settlement Rule Created
IntOrderSystemStatusShortName IntOrderSystemStatusShortName Status
InternalOrderSystemStatusName InternalOrderSystemStatusName Status
InternalOrderControllingObject InternalOrderControllingObject
IsStatisticalOrder IsStatisticalOrder Statistical Order
InternalOrderIsDeleted InternalOrderIsDeleted Marked for Deletion
InternalOrderDeletionFlagIsSet InternalOrderDeletionFlagIsSet Deletion Flag
InternalOrderIsLocked InternalOrderIsLocked Lock
ControllingObjectStatus ControllingObjectStatus Status
virtualMessageStripIsActivexfeld
virtualMessageStripReasonCodechar20
_CreatedByUser _CreatedByUser
_IntOrderLastChangedByUser _IntOrderLastChangedByUser
_LastChangedByUser _LastChangedByUser
_IntOrderActiveUserStatus _IntOrderActiveUserStatus
_IntOrderActiveSystemStatus _IntOrderActiveSystemStatus

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_IntOrderSettlementRuleTP.
-- 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_IntOrderSettlementRuleTP AS
SELECT
  ControllingObject,
  CtrlgObjectSettlementRuleName,
  ControllingSettlementProfile,
  _ControllingSettlementProfile._Text.CtrlgSettlementProfileName : localized AS CtrlgSettlementProfileNamelocalized,
  InternalOrder,
  InternalOrderDescription,
  OrderType,
  _InternalOrderTypeText.OrderTypeName : localized AS OrderTypeNamelocalized,
  InternalOrderLastChangedByUser,
  _IntOrderLastChangedByUser.FullName AS IntOrderLastChangedByUserName,
  InternalOrderLastChangeDate,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserName,
  CreationDate,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserName,
  LastChangeDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  AllocationStructure,
  _AllocationStructure._Text.AllocationStructureText : localized AS AllocationStructureTextlocalized,
  ProfitabilityAcctgTransfStruc,
  _PrftbltyAcctgTransfStructure._Text.PrftbltyAcctgTransfStrucName : localized AS PrftbltyAcctgTransfStrucNamelocalized,
  AssetValueDate,
  SettlmtRuleAutoGnrtnStrgySqnc,
  _SettlmtAutomGnrtnStrgySqnc._Text.SettlmtRuleGnrtnStrgySqncName : localized AS SettlmtRuleGnrtnStrgySqncNamelocalized,
  SettlmtRuleProcessingSequence,
  SettlementSourceStructure,
  _SourceStructure._Text.ControllingStructureName : localized AS ControllingStructureNamelocalized,
  SettlmtWithFreeDefinedCurrency,
  _SettlmtWithFreeDfndCurrency._Text.SettlmtWithFreeDefinedCrcyName : localized AS SettlmtWithFreeDefinedCrcyNamelocalized,
  SettlmtParlLedgersIsInactive,
  IntOrdSettlementRuleIsCreated,
  IntOrderSystemStatusShortName,
  InternalOrderSystemStatusName,
  InternalOrderControllingObject,
  IsStatisticalOrder,
  InternalOrderIsDeleted,
  InternalOrderDeletionFlagIsSet,
  InternalOrderIsLocked,
  ControllingObjectStatus,
  virtual MessageStripIsActive : xfeld AS virtualMessageStripIsActivexfeld,
  virtual MessageStripReasonCode : char20 AS virtualMessageStripReasonCodechar20
FROM R_IntOrderSettlementRuleTP
LEFT OUTER JOIN C_IntOrderActiveUserStatus AS _IntOrderActiveUserStatus ON ControllingObject = _IntOrderActiveUserStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN C_IntOrderActiveSystemStatus AS _IntOrderActiveSystemStatus ON ControllingObject = _IntOrderActiveSystemStatus.StatusObject  -- association [0..*]
;

Learn More