P_ScrtyClPositionFinObjectData

DDL: P_SCRTYCLPOSITIONFINOBJECTDATA Type: view COMPOSITE Package: FTR_ANALYZER_GENERAL_CORE
21 Fields 1 Data Sources

Securities Acct Class Position - Financial Object Data

P_ScrtyClPositionFinObjectData is a Composite CDS View that provides data about "Securities Acct Class Position - Financial Object Data" in SAP S/4HANA. It reads from 1 data source (I_SecuritiesAcctClPosMstrData) and exposes 21 fields with key field SecurityClassPositionUUID. Part of development package FTR_ANALYZER_GENERAL_CORE.

Data Sources (1)

SourceAliasJoin Type
I_SecuritiesAcctClPosMstrData SecurityClassPosMaster from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PTRSECACCPOSMD 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.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SecurityClassPositionUUID SecurityClassPositionUUID Lot
CompanyCode CompanyCode Receiver Company Code
SecurityAccount SecurityAccount Securities Acct
SecurityClass SecurityClass Security Class
Portfolio Portfolio Portfolio
TreasuryFinancialObject TreasuryFinancialObject Val. Obj. No.
SecurityAccountName
SecurityAccountGroup _SecurityAccount SecurityAccountGroup
SecurityAccountType _SecurityAccount SecurityAccountType
DepositoryBank _SecurityAccount DepositoryBank
FinancialInstrProductCategory _SecurityClass FinancialInstrProductCategory
FinancialInstrumentProductType _SecurityClass FinancialInstrumentProductType
SecurityClassName _SecurityClass SecurityClassName
SecurityClassDescription _SecurityClass SecurityClassDescription
Issuer _SecurityClass Issuer User Name
SecurityClassIsListed _SecurityClass SecurityClassIsListed
SecurityClassQuotation _SecurityClass SecurityClassQuotation
IssueCurrency _SecurityClass IssueCurrency
SecurityClassIsPledgeable _SecurityClass SecurityClassIsPledgeable
ScrtyClassGenClassification _SecurityClass ScrtyClassGenClassification
SecurityClassTransferType _SecurityClass SecurityClassTransferType

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_ScrtyClPositionFinObjectData.
-- 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 P_ScrtyClPositionFinObjectData AS
SELECT
  SecurityClassPositionUUID,
  CompanyCode,
  SecurityAccount,
  SecurityClass,
  Portfolio,
  TreasuryFinancialObject,
  _SecurityAccount.SecurityAccountGroup AS SecurityAccountGroup,
  _SecurityAccount.SecurityAccountType AS SecurityAccountType,
  _SecurityAccount.DepositoryBank AS DepositoryBank,
  _SecurityClass.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  _SecurityClass.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _SecurityClass.SecurityClassName AS SecurityClassName,
  _SecurityClass.SecurityClassDescription AS SecurityClassDescription,
  _SecurityClass.Issuer AS Issuer,
  _SecurityClass.SecurityClassIsListed AS SecurityClassIsListed,
  _SecurityClass.SecurityClassQuotation AS SecurityClassQuotation,
  _SecurityClass.IssueCurrency AS IssueCurrency,
  _SecurityClass.SecurityClassIsPledgeable AS SecurityClassIsPledgeable,
  _SecurityClass.ScrtyClassGenClassification AS ScrtyClassGenClassification,
  _SecurityClass.SecurityClassTransferType AS SecurityClassTransferType
FROM I_SecuritiesAcctClPosMstrData AS SecurityClassPosMaster
;

Learn More