I_BrkrRecnclnBusTransOnPosDate

DDL: I_BRKRRECNCLNBUSTRANSONPOSDATE SQL: IBRDRVTVPOS Type: view COMPOSITE Package: FIN_CMM_BRR_VDM_BROKER_COMMON
23 Fields 1 Data Sources

Business Transaction on Position Date

I_BrkrRecnclnBusTransOnPosDate is a Composite CDS View that provides data about "Business Transaction on Position Date" in SAP S/4HANA. It reads from 1 data source (I_BrkrRecnclnDrvtvBusTrans) and exposes 23 fields with key field TreasuryPositionLotUUID. Part of development package FIN_CMM_BRR_VDM_BROKER_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_BrkrRecnclnDrvtvBusTrans _BusinessTransaction from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBRDRVTVPOS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Business Transaction on Position Date view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY TreasuryPositionLotUUID _CalculationPosition TreasuryPositionLotUUID
DistributorBusTransactionUUID I_BrkrRecnclnDrvtvBusTrans DistributorBusTransactionUUID
TreasuryBusinessTransCategory I_BrkrRecnclnDrvtvBusTrans TreasuryBusinessTransCategory Bus. Trans. Cat
BusinessTransactionUUID I_BrkrRecnclnDrvtvBusTrans BusinessTransactionUUID Lot
BrkrReconciliationActivityDate I_BrkrRecnclnDrvtvBusTrans BrkrReconciliationActivityDate Posting Date
BusinessTransactionCreateDate I_BrkrRecnclnDrvtvBusTrans BusinessTransactionCreateDate Time Stamp
BusinessTransactionCreateTime I_BrkrRecnclnDrvtvBusTrans BusinessTransactionCreateTime Time
BrkrRecnclnNumberOfContracts _BusSubTransaction BrkrRecnclnNumberOfContracts
SecurityClass _ClassPosition SecurityClass
FutureAccount _ClassPosition FutureAccount
CompanyCode _ClassPosition CompanyCode Receiver Company Code
ExtListedDerivativeCategory _ClassData ExtListedDerivativeCategory
FinancialInstrumentProductType _ClassData FinancialInstrumentProductType
ContrDrvtvContrMaturityCode _ClassData ContrDrvtvContrMaturityCode
BrkrReconciliationStrikePrice _ClassData BrkrReconciliationStrikePrice
OptionStrikeCurrency _ClassData OptionStrikeCurrency
OptionPutCallCode _ClassData OptionPutCallCode
CommodityProductSymbol _ClassData CommodityProductSymbol Product Symbol
KeyDate _ClassData KeyDate Maturity Key Date
DerivativeContrSpecification _ClassData DerivativeContrSpecification DCS ID
DerivativeContrSpecName _ClassData DerivativeContrSpecName
LotSize _ClassData LotSize Quantity
LotSizeUnitOfMeasure _ClassData LotSizeUnitOfMeasure

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_BrkrRecnclnBusTransOnPosDate.
-- 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: IBRDRVTVPOS

CREATE VIEW I_BrkrRecnclnBusTransOnPosDate AS
SELECT
  _CalculationPosition.TreasuryPositionLotUUID AS TreasuryPositionLotUUID,
  _BusinessTransaction.DistributorBusTransactionUUID AS DistributorBusTransactionUUID,
  _BusinessTransaction.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  _BusinessTransaction.BusinessTransactionUUID AS BusinessTransactionUUID,
  _BusinessTransaction.BrkrReconciliationActivityDate AS BrkrReconciliationActivityDate,
  _BusinessTransaction.BusinessTransactionCreateDate AS BusinessTransactionCreateDate,
  _BusinessTransaction.BusinessTransactionCreateTime AS BusinessTransactionCreateTime,
  _BusSubTransaction.BrkrRecnclnNumberOfContracts AS BrkrRecnclnNumberOfContracts,
  _ClassPosition.SecurityClass AS SecurityClass,
  _ClassPosition.FutureAccount AS FutureAccount,
  _ClassPosition.CompanyCode AS CompanyCode,
  _ClassData.ExtListedDerivativeCategory AS ExtListedDerivativeCategory,
  _ClassData.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _ClassData.ContrDrvtvContrMaturityCode AS ContrDrvtvContrMaturityCode,
  _ClassData.BrkrReconciliationStrikePrice AS BrkrReconciliationStrikePrice,
  _ClassData.OptionStrikeCurrency AS OptionStrikeCurrency,
  _ClassData.OptionPutCallCode AS OptionPutCallCode,
  _ClassData.CommodityProductSymbol AS CommodityProductSymbol,
  _ClassData.KeyDate AS KeyDate,
  _ClassData.DerivativeContrSpecification AS DerivativeContrSpecification,
  _ClassData.DerivativeContrSpecName AS DerivativeContrSpecName,
  _ClassData.LotSize AS LotSize,
  _ClassData.LotSizeUnitOfMeasure AS LotSizeUnitOfMeasure
FROM I_BrkrRecnclnDrvtvBusTrans AS _BusinessTransaction
;

Learn More