I_TrsyCompleteFinancialObject

DDL: I_TRSYCOMPLETEFINANCIALOBJECT Type: view COMPOSITE
33 Fields 1 Data Sources

Treasury Complete Financial Object

I_TrsyCompleteFinancialObject is a Composite CDS View that provides data about "Treasury Complete Financial Object" in SAP S/4HANA. It reads from 1 data source (I_TrsyFinObjectGeneral) and exposes 33 fields with key field TreasuryFinancialObject.

Data Sources (1)

SourceAliasJoin Type
I_TrsyFinObjectGeneral I_TrsyFinObjectGeneral from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ITRSYCMPFINOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TreasuryFinancialObject view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
EndUserText.label Treasury Complete Financial Object view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY TreasuryFinancialObject TreasuryFinancialObject Val. Obj. No.
CompanyCode CompanyCode Receiver Company Code
TrsyFinObjValidityStartDate TrsyFinObjValidityStartDate Trans. Start
TrsyFinObjValidityEndDate TrsyFinObjValidityEndDate Transaction End
TrsyFinObjMarketRiskActiveCode TrsyFinObjMarketRiskActiveCode Analysis active ind.
TreasuryFinancialObjectStatus TreasuryFinancialObjectStatus Status
TreasuryValuationRule _FinObjectMarketRisk TreasuryValuationRule
TrsyFinObjAssetLiabilityCode _FinObjectMarketRisk TrsyFinObjAssetLiabilityCode
TreasuryContractType _FinObjectMarketRisk TreasuryContractType Treasury Contract Type
FinancialInstrProductCategory _FinObjectMarketRisk FinancialInstrProductCategory
FinancialInstrumentProductType _FinObjectMarketRisk FinancialInstrumentProductType
Portfolio _FinObjectMarketRisk Portfolio Portfolio
FinancialTransaction _FinObjectMarketRisk FinancialTransaction Transaction
SecurityClass _FinObjectMarketRisk SecurityClass
SecurityAccount _FinObjectMarketRisk SecurityAccount
TreasuryPositionAccount _FinObjectMarketRisk TreasuryPositionAccount
FinancialExposurePosition _FinObjectMarketRisk FinancialExposurePosition
LoanContract _FinObjectMarketRisk LoanContract
BusinessPartner _FinObjectMarketRisk BusinessPartner Issuing Authority
MktRiskCharacteristicCurrency _FinObjectMarketRisk MktRiskCharacteristicCurrency
Country _FinObjectMarketRisk Country Venue: Ctry/Reg
FinancialInstrCharacteristic _FinObjectMarketRisk FinancialInstrCharacteristic Characteristics
TrsyFinObjCtptyRiskActiveCode _FinObjectCreditRisk TrsyFinObjCtptyRiskActiveCode
CtptyRiskValidityStartDate _FinObjectCreditRisk CtptyRiskValidityStartDate
CtptyRiskValidityEndDate _FinObjectCreditRisk CtptyRiskValidityEndDate
CtptyDefaultRiskRule _FinObjectCreditRisk CtptyDefaultRiskRule
CtptyRiskNettingGroup _FinObjectCreditRisk CtptyRiskNettingGroup
CtptyRiskCollateral _FinObjectCreditRisk CtptyRiskCollateral
CrdtRskCharcBusinessPartner _FinObjectCreditRisk CrdtRskCharcBusinessPartner
LimitProductGroup _FinObjectCreditRisk LimitProductGroup
BPCreditStandingRating _FinObjectCreditRisk BPCreditStandingRating Rating
CreditRecoveryRateClass _FinObjectCreditRisk CreditRecoveryRateClass
FreeDefinedMonitoringAttribute _FinObjectCreditRisk FreeDefinedMonitoringAttribute

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 I_TrsyCompleteFinancialObject.
-- 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 I_TrsyCompleteFinancialObject AS
SELECT
  TreasuryFinancialObject,
  CompanyCode,
  TrsyFinObjValidityStartDate,
  TrsyFinObjValidityEndDate,
  TrsyFinObjMarketRiskActiveCode,
  TreasuryFinancialObjectStatus,
  _FinObjectMarketRisk.TreasuryValuationRule AS TreasuryValuationRule,
  _FinObjectMarketRisk.TrsyFinObjAssetLiabilityCode AS TrsyFinObjAssetLiabilityCode,
  _FinObjectMarketRisk.TreasuryContractType AS TreasuryContractType,
  _FinObjectMarketRisk.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  _FinObjectMarketRisk.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _FinObjectMarketRisk.Portfolio AS Portfolio,
  _FinObjectMarketRisk.FinancialTransaction AS FinancialTransaction,
  _FinObjectMarketRisk.SecurityClass AS SecurityClass,
  _FinObjectMarketRisk.SecurityAccount AS SecurityAccount,
  _FinObjectMarketRisk.TreasuryPositionAccount AS TreasuryPositionAccount,
  _FinObjectMarketRisk.FinancialExposurePosition AS FinancialExposurePosition,
  _FinObjectMarketRisk.LoanContract AS LoanContract,
  _FinObjectMarketRisk.BusinessPartner AS BusinessPartner,
  _FinObjectMarketRisk.MktRiskCharacteristicCurrency AS MktRiskCharacteristicCurrency,
  _FinObjectMarketRisk.Country AS Country,
  _FinObjectMarketRisk.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  _FinObjectCreditRisk.TrsyFinObjCtptyRiskActiveCode AS TrsyFinObjCtptyRiskActiveCode,
  _FinObjectCreditRisk.CtptyRiskValidityStartDate AS CtptyRiskValidityStartDate,
  _FinObjectCreditRisk.CtptyRiskValidityEndDate AS CtptyRiskValidityEndDate,
  _FinObjectCreditRisk.CtptyDefaultRiskRule AS CtptyDefaultRiskRule,
  _FinObjectCreditRisk.CtptyRiskNettingGroup AS CtptyRiskNettingGroup,
  _FinObjectCreditRisk.CtptyRiskCollateral AS CtptyRiskCollateral,
  _FinObjectCreditRisk.CrdtRskCharcBusinessPartner AS CrdtRskCharcBusinessPartner,
  _FinObjectCreditRisk.LimitProductGroup AS LimitProductGroup,
  _FinObjectCreditRisk.BPCreditStandingRating AS BPCreditStandingRating,
  _FinObjectCreditRisk.CreditRecoveryRateClass AS CreditRecoveryRateClass,
  _FinObjectCreditRisk.FreeDefinedMonitoringAttribute AS FreeDefinedMonitoringAttribute
FROM I_TrsyFinObjectGeneral
;

Learn More