I_POSITIONIDENTIFIER

CDS View
48 Fields 15 CDS Views

Position Identifier

I_POSITIONIDENTIFIER is a CDS View in S/4HANA. Position Identifier. It contains 48 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
I_DiftPosIdent view from COMPOSITE CDS view for Treasury table: DIFT_POS_IDENT
I_Ftr_Position_Values view inner COMPOSITE Treasury Ledger Position Values
I_FuncnlAreaTrsySecurities view from COMPOSITE Treasury postion secur for Funcnl Area
I_FundTreasurySecurities view from COMPOSITE Treasury Postion Securities for Fund
I_GrantTreasurySecurities view from COMPOSITE Treasury Position Securities for Grant
I_Treasurypositionlot view from COMPOSITE Treasury Position Lot
I_TrsyAccountingItem view inner COMPOSITE Treasury Accounting Item
I_TrsyLdgrGLAcctAssgmtRef view from BASIC Treasury Ledger Account Assingment Ref
P_CmmdtyHdgHedgingRelationship view from COMPOSITE
P_PosIdfrTrsyLdgrTrsyAcctg view from COMPOSITE
P_PosIdfrTrsyLdgrTrsyAcctg view inner COMPOSITE
P_PositionIdentifierCompCode view from COMPOSITE
P_TrSiGLAcctAssgmtRef view_entity from COMPOSITE Acc. Assign. Ref for TRL Position UUID
P_TrsyPositionSPPIDate view_entity from COMPOSITE Relevant SPPI Date for Each Position
P_TrsyPostgJrnlEntrItm view inner COMPOSITE

Fields (48)

KeyField CDS FieldsUsed in Views
KEY ControllingArea ControllingArea 3
KEY FunctionalArea FunctionalArea 5
KEY Fund Fund 7
KEY GrantID GrantID 6
KEY SecurityAccount SecurityAccount 7
KEY SecurityClass SecurityClass 8
KEY TreasuryPosition TreasuryPosition,TrsyAcctgTreasuryPosition,TrsyLdgrTreasuryPosition 7
KEY TreasuryPositionLot TreasuryPositionLot 3
KEY TrsyPositionIdentificationUUID TrsyPositionIdentificationUUID 2
_CentralClearingAccount _CentralClearingAccount 1
_CompanyCode _CompanyCode 1
_DifferentiationPortfolioText _DifferentiationPortfolioText 1
_FinancialInstrProdType _FinancialInstrProdType 1
_FinancialInstrProdTypeText _FinancialInstrProdTypeText,_ProductTypeTxt 2
_FinancialInstrValClassText _FinancialInstrValClassText 1
_LoanContract _LoanContract 1
_SecurityAccount _SecurityAccount 1
_SecurityAccountGroup _SecurityAccountGroup 1
_SecurityClass _SecurityClass 1
_TreasuryPositionAccount _TreasuryPositionAccount 1
_TreasuryValuationArea _TreasuryValuationArea 1
_TreasuryValuationClassText _TreasuryValuationClassText 1
CentralClearingAccount CentralClearingAccount 4
CentralClearingAccountCurrency CentralClearingAccountCurrency 3
ChartOfAccounts ChartOfAccounts 1
CompanyCode CompanyCode 9
CostCenter CostCenter,DifferentiationCostCenter 4
DifferentiationPortfolio DifferentiationPortfolio 5
FinancialExposureItem FinancialExposureItem 4
FinancialExposureSubItem FinancialExposureSubItem 4
FinancialInstrumentProductType FinancialInstrumentProductType,FinInstrProductGroup,FinTransactionProductType 8
FinancialInstrValuationClass FinancialInstrValuationClass 4
FinancialTransaction FinancialTransaction 9
LoanContract LoanContract 8
ProfitCenter ProfitCenter 4
SecurityAccountGroup SecurityAccountGroup 4
Trader Trader 4
TreasuryAccountingCode TreasuryAccountingCode 3
TreasuryPositionAccount TreasuryPositionAccount 4
TreasuryPositionLongShortCode TreasuryPositionLongShortCode 4
TreasuryValuationArea TreasuryValuationArea 4
TreasuryValuationClass TreasuryValuationClass 5
TrsyPosCustomDiffntnTerm1 TrsyPosCustomDiffntnTerm1 4
TrsyPosCustomDiffntnTerm2 TrsyPosCustomDiffntnTerm2 4
TrsyPosCustomDiffntnTerm3 TrsyPosCustomDiffntnTerm3 4
TrsyPosCustomDiffntnTerm4 TrsyPosCustomDiffntnTerm4 4
TrsyPosCustomDiffntnTerm5 TrsyPosCustomDiffntnTerm5 4
WBSElementInternalID WBSElementInternalID 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Position Identifier
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_POSITIONIDENTIFIER (
    CONTROLLINGAREA,
    FUNCTIONALAREA,
    FUND,
    GRANTID,
    SECURITYACCOUNT,
    SECURITYCLASS,
    TREASURYPOSITION,
    TREASURYPOSITIONLOT,
    TRSYPOSITIONIDENTIFICATIONUUID,
    _CENTRALCLEARINGACCOUNT,
    _COMPANYCODE,
    _DIFFERENTIATIONPORTFOLIOTEXT,
    _FINANCIALINSTRPRODTYPE,
    _FINANCIALINSTRPRODTYPETEXT,
    _FINANCIALINSTRVALCLASSTEXT,
    _LOANCONTRACT,
    _SECURITYACCOUNT,
    _SECURITYACCOUNTGROUP,
    _SECURITYCLASS,
    _TREASURYPOSITIONACCOUNT,
    _TREASURYVALUATIONAREA,
    _TREASURYVALUATIONCLASSTEXT,
    CENTRALCLEARINGACCOUNT,
    CENTRALCLEARINGACCOUNTCURRENCY,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    COSTCENTER,
    DIFFERENTIATIONPORTFOLIO,
    FINANCIALEXPOSUREITEM,
    FINANCIALEXPOSURESUBITEM,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALINSTRVALUATIONCLASS,
    FINANCIALTRANSACTION,
    LOANCONTRACT,
    PROFITCENTER,
    SECURITYACCOUNTGROUP,
    TRADER,
    TREASURYACCOUNTINGCODE,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLONGSHORTCODE,
    TREASURYVALUATIONAREA,
    TREASURYVALUATIONCLASS,
    TRSYPOSCUSTOMDIFFNTNTERM1,
    TRSYPOSCUSTOMDIFFNTNTERM2,
    TRSYPOSCUSTOMDIFFNTNTERM3,
    TRSYPOSCUSTOMDIFFNTNTERM4,
    TRSYPOSCUSTOMDIFFNTNTERM5,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (CONTROLLINGAREA, FUNCTIONALAREA, FUND, GRANTID, SECURITYACCOUNT, SECURITYCLASS, TREASURYPOSITION, TREASURYPOSITIONLOT, TRSYPOSITIONIDENTIFICATIONUUID)
);

Learn More