I_BrkrRecnclnTransOnAccPosDate

DDL: I_BRKRRECNCLNTRANSONACCPOSDATE SQL: IBRRTRANSACCPDAT Type: view COMPOSITE
20 Fields 1 Data Sources

Clearing Broker Trans Account Based on Position Date

I_BrkrRecnclnTransOnAccPosDate is a Composite CDS View that provides data about "Clearing Broker Trans Account Based on Position Date" in SAP S/4HANA. It reads from 1 data source (I_BrkrRecnclnDrvtvBusTrans) and exposes 20 fields with key field TreasuryPositionLotUUID.

Data Sources (1)

SourceAliasJoin Type
I_BrkrRecnclnDrvtvBusTrans _BusTrans from

Parameters (1)

NameTypeDefault
P_BrkrRecnclnActivityDate tpm_position_date

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBRRTRANSACCPDAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Clearing Broker Trans Account Based on Position Date view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TreasuryPositionLotUUID _CalcPos TreasuryPositionLotUUID
PriceCurrency _ClassPos PriceCurrency
SecurityClass _ClassData ContrDrvtvContrMaturityCode
FutureAccount _ClassPos FutureAccount
BusinessTransactionUUID I_BrkrRecnclnDrvtvBusTrans BusinessTransactionUUID Lot
TreasuryBusinessTransCategory I_BrkrRecnclnDrvtvBusTrans TreasuryBusinessTransCategory Bus. Trans. Cat
BrkrReconciliationActivityDate I_BrkrRecnclnDrvtvBusTrans BrkrReconciliationActivityDate Posting Date
DistributorBusTransactionUUID I_BrkrRecnclnDrvtvBusTrans DistributorBusTransactionUUID
BusinessTransactionCreateDate I_BrkrRecnclnDrvtvBusTrans BusinessTransactionCreateDate Time Stamp
BusinessTransactionCreateTime I_BrkrRecnclnDrvtvBusTrans BusinessTransactionCreateTime Time
BusinessTransactionStatus _SubTrans BusinessTransactionStatus Workflow Status
CompanyCode _PosAccount CompanyCode Receiver Company Code
DepositoryBank _PosAccount DepositoryBank
TreasuryTransferFlowCategory _TransferFlow TreasuryTransferFlowCategory
FinancialInstrProductCategory _ClassData FinancialInstrProductCategory
OptionStrikeCurrency _ClassData OptionStrikeCurrency
OptionPutCallCode _ClassData OptionPutCallCode
CommodityProductSymbol _ClassData CommodityProductSymbol Product Symbol
KeyDate _ClassData KeyDate Maturity Key Date
ExtListedDerivativeCategory _ClassData ExtListedDerivativeCategory

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_BrkrRecnclnTransOnAccPosDate.
-- 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: IBRRTRANSACCPDAT
-- Parameters: P_BrkrRecnclnActivityDate : tpm_position_date

CREATE VIEW I_BrkrRecnclnTransOnAccPosDate AS
SELECT
  _CalcPos.TreasuryPositionLotUUID AS TreasuryPositionLotUUID,
  _ClassPos.PriceCurrency AS PriceCurrency,
  _ClassData.ContrDrvtvContrMaturityCode AS SecurityClass,
  _ClassPos.FutureAccount AS FutureAccount,
  _BusTrans.BusinessTransactionUUID AS BusinessTransactionUUID,
  _BusTrans.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  _BusTrans.BrkrReconciliationActivityDate AS BrkrReconciliationActivityDate,
  _BusTrans.DistributorBusTransactionUUID AS DistributorBusTransactionUUID,
  _BusTrans.BusinessTransactionCreateDate AS BusinessTransactionCreateDate,
  _BusTrans.BusinessTransactionCreateTime AS BusinessTransactionCreateTime,
  _SubTrans.BusinessTransactionStatus AS BusinessTransactionStatus,
  _PosAccount.CompanyCode AS CompanyCode,
  _PosAccount.DepositoryBank AS DepositoryBank,
  _TransferFlow.TreasuryTransferFlowCategory AS TreasuryTransferFlowCategory,
  _ClassData.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  _ClassData.OptionStrikeCurrency AS OptionStrikeCurrency,
  _ClassData.OptionPutCallCode AS OptionPutCallCode,
  _ClassData.CommodityProductSymbol AS CommodityProductSymbol,
  _ClassData.KeyDate AS KeyDate,
  _ClassData.ExtListedDerivativeCategory AS ExtListedDerivativeCategory
FROM I_BrkrRecnclnDrvtvBusTrans AS _BusTrans
;

Learn More