P_CMMDTYTRANSTRADEORDERCOCKPIT

DDL: P_CMMDTYTRANSTRADEORDERCOCKPIT SQL: PTRANSTRDORDCKPT Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_SPEC
18 Fields 1 Data Sources

Commodity Hedge Transactional Details

P_CMMDTYTRANSTRADEORDERCOCKPIT is a Composite CDS View that provides data about "Commodity Hedge Transactional Details" in SAP S/4HANA. It reads from 1 data source (I_CommodityHedgeTransaction) and exposes 18 fields. Part of development package FIN_CMM_CMDTY_HEDGE_SPEC.

Data Sources (1)

SourceAliasJoin Type
I_CommodityHedgeTransaction _Transaction inner

Parameters (1)

NameTypeDefault
P_CompanyCode bukrs

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PTRANSTRDORDCKPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Commodity Hedge Transactional Details view

Fields (18)

KeyFieldSource TableSource FieldDescription
CmmdtyHdgCnstltnExpsrVersion _Extdeal CmmdtyHdgCnstltnExpsrVersion
CmmdtyHdgConstellationExposure _Extdeal CmmdtyHdgConstellationExposure
CmmdtyHedgeConstellationUUID _Extdeal CmmdtyHedgeConstellationUUID
CmmdtyHedgeCnstltnRecordType _Extdeal CmmdtyHedgeCnstltnRecordType
FinancialInstrumentActivity I_CommodityHedgeTransaction FinancialInstrumentActivity Active activity
CmmdtyHdgTrdOrdTransHdgSpecID I_CommodityHedgeTransaction CmmdtyHdgSpecificationID Hedge Spec. ID
CmmdtyHdgTrdOrdTransSpecOrdID I_CommodityHedgeTransaction CmmdtyHdgSpecQuotaOrderID Order ID
FinTransactionProductType I_CommodityHedgeTransaction FinTransactionProductType Product Type
HedgeRequestIdentifier I_CommodityHedgeTransaction HedgeRequestIdentifier Hedge Request ID
FinancialInstrTransactionType I_CommodityHedgeTransaction FinancialInstrTransactionType Transactn Type
FinTransactionProductCategory I_CommodityHedgeTransaction FinTransactionProductCategory Prod. Category
ContractStartDate I_CommodityHedgeTransaction ContractStartDate Contract Start Date
ContractEndDate I_CommodityHedgeTransaction ContractEndDate Contract End Date
FinTransOnBehalfOfCompany I_CommodityHedgeTransaction FinTransOnBehalfOfCompany On Behalf of CoCode
CompanyCode _Extdeal CompanyCode Receiver Company Code
CmmdtyHdgCnstltnIntCompanyCode _Extdeal CmmdtyHdgCnstltnIntCompanyCode
FinTransactionDealIdentifier _Extdeal CmmdtyHedgeConstellationDeal
CmmdtyHdgCnstltnIntDealNumber _Extdeal CmmdtyHdgCnstltnIntDealNumber

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_CMMDTYTRANSTRADEORDERCOCKPIT.
-- 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: PTRANSTRDORDCKPT
-- Parameters: P_CompanyCode : bukrs

CREATE VIEW P_CMMDTYTRANSTRADEORDERCOCKPIT AS
SELECT
  _Extdeal.CmmdtyHdgCnstltnExpsrVersion AS CmmdtyHdgCnstltnExpsrVersion,
  _Extdeal.CmmdtyHdgConstellationExposure AS CmmdtyHdgConstellationExposure,
  _Extdeal.CmmdtyHedgeConstellationUUID AS CmmdtyHedgeConstellationUUID,
  _Extdeal.CmmdtyHedgeCnstltnRecordType AS CmmdtyHedgeCnstltnRecordType,
  _Transaction.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  _Transaction.CmmdtyHdgSpecificationID AS CmmdtyHdgTrdOrdTransHdgSpecID,
  _Transaction.CmmdtyHdgSpecQuotaOrderID AS CmmdtyHdgTrdOrdTransSpecOrdID,
  _Transaction.FinTransactionProductType AS FinTransactionProductType,
  _Transaction.HedgeRequestIdentifier AS HedgeRequestIdentifier,
  _Transaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _Transaction.FinTransactionProductCategory AS FinTransactionProductCategory,
  _Transaction.ContractStartDate AS ContractStartDate,
  _Transaction.ContractEndDate AS ContractEndDate,
  _Transaction.FinTransOnBehalfOfCompany AS FinTransOnBehalfOfCompany,
  _Extdeal.CompanyCode AS CompanyCode,
  _Extdeal.CmmdtyHdgCnstltnIntCompanyCode AS CmmdtyHdgCnstltnIntCompanyCode,
  _Extdeal.CmmdtyHedgeConstellationDeal AS FinTransactionDealIdentifier,
  _Extdeal.CmmdtyHdgCnstltnIntDealNumber AS CmmdtyHdgCnstltnIntDealNumber
INNER JOIN I_CommodityHedgeTransaction AS _Transaction ON /* join condition not captured in parsed metadata */
;

Learn More