P_Tbat_Basis_DeliveryPeriods

Provides the per delivery period the most current record | view: PTBATBDLVPER | Extraction: Not supported | Component: Basic Functions
Column Name Description
basis_type FK Basis Type
basis_id FK Basis ID
dcsid FK Derivative Contract Specification ID
mic FK Market Identifier Code
delivery_from Delivery Start Date
delivery_to Delivery End Date
pricetype FK Type of Price Quotation
pricedate Date of Price Quotation
pricetime Time of Price Quotation
validfrom null
Column Name Description
Column Name Description
Column Name Description
delivery_from Delivery Start Date
delivery_to Delivery End Date
pricedate Date of Price Quotation
pricetime Time of Price Quotation
keydate FK Maturity Key Date
Column Name Description
deletion_ind Price Quotation Logically Deleted Show values
Column Name Description Domain name
contract_code Contract Maturity Code TBA_CONTRACT_CODE
price Quotation Price TBAC_PRICE
createdby First Entered By SYCHAR12
Master Data Relations Join Conditions
Basis ID
  • Basis ID
  • Client
  • P_TBAT_BASIS_DELIVERYPERIODS.BASIS_ID == TBACC_BAS_ID.BASIS_ID
  • P_TBAT_BASIS_DELIVERYPERIODS.MANDT == TBACC_BAS_ID.CLIENT
Basis Type
  • Client
  • Basis Type
Quotation Currency
  • Client
  • Quotation Currency
  • P_TBAT_BASIS_DELIVERYPERIODS.MANDT == TCURC.MANDT
  • P_TBAT_BASIS_DELIVERYPERIODS.CURRENCY == TCURC.WAERS
Derivative Contract Specification ID P_TBAT_BASIS_DELIVERYPERIODS.MANDT == TBAC_DCS.CLIENT
Maturity Key Date
  • Client
  • ?
  • Maturity Key Date
  • P_TBAT_BASIS_DELIVERYPERIODS.MANDT == TBAC_DCS_KD.CLIENT
  • P_TBAT_BASIS_DELIVERYPERIODS.[column in domain "TBA_DCSID"] == TBAC_DCS_KD.DCSID
  • P_TBAT_BASIS_DELIVERYPERIODS.KEYDATE == TBAC_DCS_KD.KEYDATE
Market Identifier Code
  • Client
  • Market Identifier Code
  • P_TBAT_BASIS_DELIVERYPERIODS.MANDT == TBAC_MIC.CLIENT
  • P_TBAT_BASIS_DELIVERYPERIODS.MIC == TBAC_MIC.MIC
Type of Price Quotation
  • Client
  • Type of Price Quotation
  • P_TBAT_BASIS_DELIVERYPERIODS.MANDT == TW56.MANDT
  • P_TBAT_BASIS_DELIVERYPERIODS.PRICETYPE == TW56.SKURSART
Quotation Unit of Measure
  • Client
  • Quotation Unit of Measure
  • P_TBAT_BASIS_DELIVERYPERIODS.MANDT == T006.MANDT
  • P_TBAT_BASIS_DELIVERYPERIODS.UOM == T006.MSEHI