I_TreasuryPositionIdentifier

DDL: I_TREASURYPOSITIONIDENTIFIER Type: view_entity BASIC
33 Fields 1 Data Sources 4 Associations

Treasury Position Identifier

I_TreasuryPositionIdentifier (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

TreasuryPositionIdentifier · Financial Operations

I_TreasuryPositionIdentifier is a Basic CDS View that provides data about "Treasury Position Identifier" in SAP S/4HANA. It reads from 1 data source (dift_pos_ident) and exposes 33 fields with key field TrsyPositionIdentificationUUID. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Transactional Data
Purpose
This CDS view retrieves treasury position identifiers available in the system. A treasury position identifier is a collection of attributes of a treasury position, including position UUID and differentiation terms. A position identifier can be linked based on the field context to treasury accounting adaptor, treasury quantity ledger position or treasury ledger. This CDS view provides the data to answer the following business questions: Which treasury position identifier exist in the system? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: ACC_CODE_VAL_AREA_GSART Accounting Code/Treasury Valuation Area/Product Type You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Is Key Data Element Label Comment TrsyPositionIdentificationUUID X FTR_GEN_POSITION_IDENT_UUID Treasury Pos. Ident. UUID Representing Treasury Position Identification TreasuryPosition FTR_GEN_POSITION_UUID Treasury Position Treasury Position UUID TreasuryValuationArea TPM_VAL_AREA Valuation Area Treasury Valuation Area CompanyCode BUKRS Company Code Company Code FinancialInstrumentProductType VVSART Product Type Product Type TreasuryValuationClass FTR_GEN_VALUATION_CLASS Valuation Class Valuation Class FinancialInstrValuationClass FTR_GEN_FIN_INSTR_VAL_CLASS Gen. Valuation Class General Valuation Class SecurityAccount FTR_GEN_SECURITY_ACCOUNT Securities Account Security Account SecurityClass FTR_GEN_SECURITY_CLASS Security Class Security Class DifferentiationPortfolio FTR_GEN_PORTFOLIO_DIFF Portfolio (Position) Portfolio as Differentiation Characteristic SecurityAccountGroup FTR_GEN_SEC_ACCOUNT_GROUP Sec. Account Group Securities Account Group TreasuryPositionLongShortCode FTR_GEN_LONG_SHORT_CODE Long/Short Position Code: Long or Short Position TreasuryPositionLotUUID TPM_LOT_ID Lot Identifier of the Lot FinancialTransaction TB_RFHA Transaction Financial Transaction Fund FM_FUND Fund Fund GrantID GM_GRANT_NBR Grant Grant WBSElementInternalID PS_S4_PSPNR WBS Internal ID WBS Element ProfitCenter PRCTR Profit Center Profit Center CostCenter KOSTL Cost Center Cost Center FunctionalArea FKBER Functional Area Functional Area TreasuryPositionContext DIF_IDENT_CONTEXT Context Context for Identifier FinancialExposureItem TOE_EXPOSURE_ITEM_ID Exposure Item ID Exposure Item ID FinancialExposureSubItem TOE_EXPOSURE_SUBITEM_ID Exposure Subitem ID Exposure Subitem ID TrsyPosCustomDiffntnTerm1 TPM_CUST_DIFF_TERM_1_VALUE Custom Diff. Term 1 Custom Differentiation Term 1 (Value) TrsyPosCustomDiffntnTerm2 TPM_CUST_DIFF_TERM_2_VALUE Custom Diff. Term 2 Custom Differentiation Term 2 (Value) TrsyPosCustomDiffntnTerm3 TPM_CUST_DIFF_TERM_3_VALUE Custom Diff. Term 3 Custom Differentiation Term 3 (Value) TrsyPosCustomDiffntnTerm4 TPM_CUST_DIFF_TERM_4_VALUE Custom Diff. Term 4 Custom Differentiation Term 4 (Value) TrsyPosCustomDiffntnTerm5 TPM_CUST_DIFF_TERM_5_VALUE Custom Diff. Term 5 Custom Differentiation Term 5 (Value)

Data Extraction
This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
dift_pos_ident dift from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FinancialinstrProductType _FinancialInstrProdType $projection.FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType
[0..1] I_TreasuryValuationArea _TreasuryValuationArea $projection.TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Treasury Position Identifier view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name TreasuryPositionIdentifier view
VDM.viewType #BASIC view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY TrsyPositionIdentificationUUID UUID Representing Treasury Position Identification
TreasuryPosition Treasury Position UUID
TreasuryValuationArea dift_pos_ident valuation_area Treasury Valuation Area
CompanyCode dift_pos_ident company_code Company Code
FinancialInstrumentProductType dift_pos_ident product_type Product Type
TreasuryValuationClass Valuation Class
FinancialInstrValuationClass General Valuation Class
SecurityAccount Security Account
SecurityClass Security Class
LoanContract Loan Contract Number
DifferentiationPortfolio Portfolio as Differentiation Characteristic
SecurityAccountGroup Securities Account Group
TreasuryPositionLongShortCode Code: Long or Short Position
TreasuryPositionLotUUID dift_pos_ident lot_id Identifier of the Lot
FinancialTransaction Financial Transaction
Fund dift_pos_ident fund Sender Fund
GrantID dift_pos_ident grant_nbr Receiver Grant
WBSElementInternalID WBS Element
ProfitCenter dift_pos_ident profit_center Profit Center
CostCenter dift_pos_ident cost_center Posted Cost Center
FunctionalArea dift_pos_ident functional_area Functional Area
TreasuryPositionContext dift_pos_ident context Context for Identifier
FinancialExposureItem dift_pos_ident exposure_item_id Exposure Item ID
FinancialExposureSubItem dift_pos_ident exposure_subitem_id Exposure Subitem ID
TrsyPosCustomDiffntnTerm1 Custom Differentiation Term 1 (Value)
TrsyPosCustomDiffntnTerm2 Custom Differentiation Term 2 (Value)
TrsyPosCustomDiffntnTerm3 Custom Differentiation Term 3 (Value)
TrsyPosCustomDiffntnTerm4 Custom Differentiation Term 4 (Value)
TrsyPosCustomDiffntnTerm5 Custom Differentiation Term 5 (Value)
_CompanyCode _CompanyCode
_FinancialInstrProdType _FinancialInstrProdType
_TreasuryValuationArea _TreasuryValuationArea
_WBSElementBasicData _WBSElementBasicData

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_TreasuryPositionIdentifier.
-- 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_TreasuryPositionIdentifier AS
SELECT
  cast(dift.os_guid as ftr_gen_position_ident_uuid preserving type) AS TrsyPositionIdentificationUUID,
  cast (dift.identified_oid as ftr_gen_position_uuid preserving type) AS TreasuryPosition,
  dift.valuation_area AS TreasuryValuationArea,
  dift.company_code AS CompanyCode,
  dift.product_type AS FinancialInstrumentProductType,
  cast(dift.valuation_class as ftr_gen_valuation_class preserving type) AS TreasuryValuationClass,
  cast(dift.com_val_class as ftr_gen_fin_instr_val_class preserving type) AS FinancialInstrValuationClass,
  cast(dift.security_account as ftr_gen_security_account preserving type) AS SecurityAccount,
  cast(dift.security_id as ftr_gen_security_class preserving type) AS SecurityClass,
  cast(dift.loans_contract as ftr_gen_loan_contract preserving type) AS LoanContract,
  cast(dift.portfolio as ftr_gen_portfolio_diff preserving type) AS DifferentiationPortfolio,
  cast(dift.account_group as ftr_gen_sec_account_group preserving type) AS SecurityAccountGroup,
  cast(dift.flag_long_short as ftr_gen_long_short_code preserving type) AS TreasuryPositionLongShortCode,
  dift.lot_id AS TreasuryPositionLotUUID,
  cast(dift.deal_number as tb_rfha preserving type) AS FinancialTransaction,
  dift.fund AS Fund,
  dift.grant_nbr AS GrantID,
  cast(dift.wbs_element as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  dift.profit_center AS ProfitCenter,
  dift.cost_center AS CostCenter,
  dift.functional_area AS FunctionalArea,
  dift.context AS TreasuryPositionContext,
  dift.exposure_item_id AS FinancialExposureItem,
  dift.exposure_subitem_id AS FinancialExposureSubItem,
  cast(dift.custom_diff_term_1 as tpm_cust_diff_term_1_value preserving type ) AS TrsyPosCustomDiffntnTerm1,
  cast(dift.custom_diff_term_2 as tpm_cust_diff_term_2_value preserving type ) AS TrsyPosCustomDiffntnTerm2,
  cast(dift.custom_diff_term_3 as tpm_cust_diff_term_3_value preserving type ) AS TrsyPosCustomDiffntnTerm3,
  cast(dift.custom_diff_term_4 as tpm_cust_diff_term_4_value preserving type ) AS TrsyPosCustomDiffntnTerm4,
  cast(dift.custom_diff_term_5 as tpm_cust_diff_term_5_value preserving type ) AS TrsyPosCustomDiffntnTerm5
FROM dift_pos_ident AS dift
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _FinancialInstrProdType ON FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationArea AS _TreasuryValuationArea ON TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
;

Learn More