P_CmmdtyFinTransactionHeader

DDL: P_CMMDTYFINTRANSACTIONHEADER Type: view COMPOSITE Package: FIN_CMM_CMDTY_VDM
21 Fields 1 Data Sources 4 Associations

Commodity Financial Transaction Header

P_CmmdtyFinTransactionHeader is a Composite CDS View that provides data about "Commodity Financial Transaction Header" in SAP S/4HANA. It reads from 1 data source (vtbfha) and exposes 21 fields with key fields CompanyCode, FinancialTransaction. It has 4 associations to related views. Part of development package FIN_CMM_CMDTY_VDM.

Data Sources (1)

SourceAliasJoin Type
vtbfha FinTran_Header from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_FinancialTransaction _FinTran $projection.CompanyCode = _FinTran.CompanyCode and $projection.FinancialTransaction = _FinTran.FinancialTransaction
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_FinancialinstrProductType _ProductType $projection.FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType
[1..1] I_BusinessPartner _Counterparty $projection.Counterparty = _Counterparty.BusinessPartner

Annotations (10)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfha bukrs Value
KEY FinancialTransaction vtbfha rfha Transaction
FinInstrLastActiveActivity
CreatedByUser vtbfha cruser User Name
FinTransCreationDate vtbfha dcrdat Entry Date
FinTransCreationTime vtbfha tcrtim Entry Time
LastChangedByUser vtbfha upuser Changed by
LastChangeDate vtbfha dupdat Changed On
FinInstrumentLastChangedTime vtbfha tuptim Time Changed
TermStartDate vtbfha dblfz Term Start
TermEndDate vtbfha delfz Term End
FinancialInstrProductCategory
FinInstrTransactionCategory vtbfha sfgtyp Transaction Cat
FinancialInstrumentProductType vtbfha sgsart Product Type
FinancialInstrTransactionType vtbfha sfhaart Transactn Type
Counterparty
FinancialTransactionHedgeBook vtbfha hedge_book Hedge Book
_FinTran _FinTran
_CompanyCode _CompanyCode
_ProductType _ProductType
_Counterparty _Counterparty

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_CmmdtyFinTransactionHeader.
-- 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_CmmdtyFinTransactionHeader AS
SELECT
  FinTran_Header.bukrs AS CompanyCode,
  FinTran_Header.rfha AS FinancialTransaction,
  cast(FinTran_Header.rfhazul as ftr_gen_fin_instr_last_act_act preserving type) AS FinInstrLastActiveActivity,
  FinTran_Header.cruser AS CreatedByUser,
  FinTran_Header.dcrdat AS FinTransCreationDate,
  FinTran_Header.tcrtim AS FinTransCreationTime,
  FinTran_Header.upuser AS LastChangedByUser,
  FinTran_Header.dupdat AS LastChangeDate,
  FinTran_Header.tuptim AS FinInstrumentLastChangedTime,
  FinTran_Header.dblfz AS TermStartDate,
  FinTran_Header.delfz AS TermEndDate,
  cast(FinTran_Header.sanlf as ftr_gen_fin_instr_prod_categ preserving type) AS FinancialInstrProductCategory,
  FinTran_Header.sfgtyp AS FinInstrTransactionCategory,
  FinTran_Header.sgsart AS FinancialInstrumentProductType,
  FinTran_Header.sfhaart AS FinancialInstrTransactionType,
  cast(FinTran_Header.kontrh as rkontrah_new preserving type) AS Counterparty,
  FinTran_Header.hedge_book AS FinancialTransactionHedgeBook
FROM vtbfha AS FinTran_Header
LEFT OUTER JOIN I_FinancialTransaction AS _FinTran ON CompanyCode = _FinTran.CompanyCode AND FinancialTransaction = _FinTran.FinancialTransaction  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductType ON FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _Counterparty ON Counterparty = _Counterparty.BusinessPartner  -- association [1..1]
;

Learn More