A_BrkrRecnclnLongShortMatch

DDL: A_BRKRRECNCLNLONGSHORTMATCH Type: view_entity CONSUMPTION
19 Fields 1 Data Sources

Matched Trades

A_BrkrRecnclnLongShortMatch is a Consumption CDS View that provides data about "Matched Trades" in SAP S/4HANA. It reads from 1 data source (I_BrkrRecnclnLongShortMatch) and exposes 19 fields with key fields Counterparty, BrokerReconciliationMatchDate, CompanyCode, PositionAccountNumber.

Data Sources (1)

SourceAliasJoin Type
I_BrkrRecnclnLongShortMatch I_BrkrRecnclnLongShortMatch projection

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Matched Trades view
OData.entityType.name LongShortMatching_Type view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Counterparty Counterparty Supplier
KEY BrokerReconciliationMatchDate BrokerReconciliationMatchDate
KEY CompanyCode CompanyCode Receiver Company Code
KEY PositionAccountNumber PositionAccountNumber
TreasuryBusinessMatchingUUID TreasuryBusinessMatchingUUID
BusinessTransactionUUID BusinessTransactionUUID
BrkrReconciliationActivityDate BrkrReconciliationActivityDate
ActivityFinancialTransaction ActivityFinancialTransaction
ContrDrvtvContrMaturityCode ContrDrvtvContrMaturityCode
BrkrRecnclnNumberOfContracts BrkrRecnclnNumberOfContracts
ContractPrice ContractPrice
Currency Currency Valuation Crcy
TreasuryPositionLongShortCode TreasuryPositionLongShortCode
BrkrReconciliationStrikePrice BrkrReconciliationStrikePrice
OptionStrikeCurrency OptionStrikeCurrency
OptionPutCallCode OptionPutCallCode
CommodityProductSymbol CommodityProductSymbol Product Symbol
KeyDate KeyDate Maturity Key Date
ExtListedDerivativeCategory 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 A_BrkrRecnclnLongShortMatch.
-- 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 A_BrkrRecnclnLongShortMatch AS
SELECT
  Counterparty,
  BrokerReconciliationMatchDate,
  CompanyCode,
  PositionAccountNumber,
  TreasuryBusinessMatchingUUID,
  BusinessTransactionUUID,
  BrkrReconciliationActivityDate,
  ActivityFinancialTransaction,
  ContrDrvtvContrMaturityCode,
  BrkrRecnclnNumberOfContracts,
  ContractPrice,
  Currency,
  TreasuryPositionLongShortCode,
  BrkrReconciliationStrikePrice,
  OptionStrikeCurrency,
  OptionPutCallCode,
  CommodityProductSymbol,
  KeyDate,
  ExtListedDerivativeCategory
FROM I_BrkrRecnclnLongShortMatch
;

Learn More