P_PositionIdentifierCompCode

DDL: P_POSITIONIDENTIFIERCOMPCODE SQL: PPOSIDENTCOCODE Type: view COMPOSITE
53 Fields 1 Data Sources

P_PositionIdentifierCompCode is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PositionIdentifier) and exposes 53 fields with key field TrsyPositionIdentificationUUID.

Data Sources (1)

SourceAliasJoin Type
I_PositionIdentifier dift from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName PPOSIDENTCOCODE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY TrsyPositionIdentificationUUID TrsyPositionIdentificationUUID
TreasuryPosition TreasuryPosition
TreasuryValuationArea TreasuryValuationArea Valuation Area
FinancialInstrValuationClass FinancialInstrValuationClass
TreasuryValuationClass TreasuryValuationClass
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ChartOfAccounts _CompanyCode ChartOfAccounts Node Class
ControllingArea _CompanyCode ControllingArea Controlling Area
FinancialManagementArea _CompanyCode FinancialManagementArea FM Area
FinancialInstrumentProductType FinancialInstrumentProductType Product Type
SecurityAccount SecurityAccount
SecurityClass SecurityClass
DifferentiationPortfolio DifferentiationPortfolio
Trader Trader Trader
SecurityAccountGroup SecurityAccountGroup
LoanContract LoanContract
TreasuryPositionAccount TreasuryPositionAccount
TreasuryPositionLongShortCode TreasuryPositionLongShortCode
TreasuryPositionLot TreasuryPositionLot Lot
FinancialTransaction FinancialTransaction Transaction
Fund Fund Sender Fund
GrantID GrantID Sender Grant
WBSElementExternalID _WBSElementBasicData WBSElementExternalID WBS Element External ID
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
FunctionalArea FunctionalArea Sendr Fctl Area
TrsyPosCustomDiffntnTerm1 TrsyPosCustomDiffntnTerm1
TrsyPosCustomDiffntnTerm2 TrsyPosCustomDiffntnTerm2
TrsyPosCustomDiffntnTerm3 TrsyPosCustomDiffntnTerm3
TrsyPosCustomDiffntnTerm4 TrsyPosCustomDiffntnTerm4
TrsyPosCustomDiffntnTerm5 TrsyPosCustomDiffntnTerm5
CentralClearingAccount CentralClearingAccount
CentralClearingAccountCurrency CentralClearingAccountCurrency
TreasuryPositionContext TreasuryPositionContext Rev Context
TreasuryAccountingCode TreasuryAccountingCode Accounting Code
FinancialExposureItem FinancialExposureItem Exposure Item ID
FinancialExposureSubItem FinancialExposureSubItem Exposure Subitem ID
_CompanyCode _CompanyCode
_ControllingArea _CompanyCode _ControllingArea
_LoanContract _LoanContract
_TreasuryPositionAccount _TreasuryPositionAccount
_TreasuryValuationArea _TreasuryValuationArea
_CentralClearingAccount _CentralClearingAccount
_SecurityAccountGroup _SecurityAccountGroup
_DifferentiationPortfolioText _DifferentiationPortfolioText
_SecurityAccount _SecurityAccount
_FinancialInstrProdTypeText _FinancialInstrProdTypeText
_FinancialInstrProdType _FinancialInstrProdType
_SecurityClass _SecurityClass
_TreasuryValuationClassText _TreasuryValuationClassText
_FinancialInstrValuationClass _FinancialInstrValuationClass
_FinancialInstrValClassText _FinancialInstrValClassText

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 P_PositionIdentifierCompCode.
-- 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.
-- SQL view name: PPOSIDENTCOCODE

CREATE VIEW P_PositionIdentifierCompCode AS
SELECT
  TrsyPositionIdentificationUUID,
  TreasuryPosition,
  TreasuryValuationArea,
  FinancialInstrValuationClass,
  TreasuryValuationClass,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  FinancialInstrumentProductType,
  SecurityAccount,
  SecurityClass,
  DifferentiationPortfolio,
  Trader,
  SecurityAccountGroup,
  LoanContract,
  TreasuryPositionAccount,
  TreasuryPositionLongShortCode,
  TreasuryPositionLot,
  FinancialTransaction,
  Fund,
  GrantID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  ProfitCenter,
  CostCenter,
  FunctionalArea,
  TrsyPosCustomDiffntnTerm1,
  TrsyPosCustomDiffntnTerm2,
  TrsyPosCustomDiffntnTerm3,
  TrsyPosCustomDiffntnTerm4,
  TrsyPosCustomDiffntnTerm5,
  CentralClearingAccount,
  CentralClearingAccountCurrency,
  TreasuryPositionContext,
  TreasuryAccountingCode,
  FinancialExposureItem,
  FinancialExposureSubItem,
  _CompanyCode._ControllingArea AS _ControllingArea
FROM I_PositionIdentifier AS dift
;

Learn More