I_PREAGRMTTRADINGCONTRACT

CDS View

Trading Contract Header

I_PREAGRMTTRADINGCONTRACT is a CDS View in S/4HANA. Trading Contract Header. It contains 6 fields. 12 CDS views read from this table.

Used by 12 CDS view(s) 6 fields

CDS Views using this table (12)

ViewTypeJoinVDMDescription
I_PrepayBarterProposedLinks view from COMPOSITE PPMT Proposed Linkages Barter
I_PrepaymentContractHeader view from BASIC Prepayment Contract Header Information
I_PrepaymentProposedLinkages view from COMPOSITE Prepayment Agreement Proposed Linkages
P_PpaytPrpsdLnkgCMMContrAmt view from COMPOSITE Prepayment Proposed CMM Contract Amount
P_PpaytPrpsdLnkgContrAmt view from COMPOSITE Prepayment Proposed Contract Amount
P_PpaytPrpsdLnkgCPEContrAmt view from COMPOSITE Prepayment Proposed CPE Contract Amount
P_PpaytPrpsdLnkgDocContrAmt view from COMPOSITE Prepayment Proposed Document Contract Amount
P_PrepaymentCMMContractAmount view inner COMPOSITE Prepayment Contract CMM Amount
P_PrepaymentCPEContractAmount view inner COMPOSITE Prepayment Contract CPE Amount
P_PrepaymentDocContractAmount view inner COMPOSITE Prepayment Contract Document Amount
P_PrepaymentDocumentFixedVal view from COMPOSITE Document Fixed Pricing
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount

Fields (6)

KeyField CDS FieldsUsed in Views
KEY PrepaymentRefDocCondition PrepaymentRefDocCondition 1
KEY TradingContract DocNumber,TradingContract 10
CompanyCode CompanyCode 9
Counterparty Counterparty 6
TradingContractType DocumentType 9
TrdgContrApplicationStatus TrdgContrApplicationStatus 5 
@AbapCatalog.sqlViewName              : 'IPPMGCONTR'
@AbapCatalog.compiler.compareFilter   : true
@AbapCatalog.preserveKey              : true
@ClientHandling.algorithm             : #SESSION_VARIABLE
@AccessControl.authorizationCheck     : #CHECK
@Metadata.ignorePropagatedAnnotations : true
@AccessControl.personalData.blocking  : #REQUIRED
@VDM.viewType                         : #BASIC
@ObjectModel.representativeKey        : 'TradingContract'
@ObjectModel.usageType.serviceQuality : #A
@ObjectModel.usageType.sizeCategory   : #L
@ObjectModel.usageType.dataClass      : #TRANSACTIONAL
@EndUserText.label                    : 'Trading Contract Header'

define view I_PreAgrmtTradingContract 
as select from wbhk inner join wbhd
on wbhk.tkonn = wbhd.tkonn and wbhd.tposn is initial and wbhd.tposn_sub is initial

  association [0..*] to I_PreAgrmtTradingContractItem     as _TradingContractItem     on  $projection.TradingContract = _TradingContractItem.TradingContract
  
  association [0..1] to I_PreAgrmtTrdgContrTypeDesc       as _TradingContractTypeDesc on  $projection.TradingContractType = _TradingContractTypeDesc.TradingContractType
  
  association [0..1] to I_CompanyCode                     as _CompanyCode             on  $projection.CompanyCode = _CompanyCode.CompanyCode
  
// Exntension view

  association [0..1] to E_TradingContract                 as _Extension               on  $projection.TradingContract = _Extension.TradingContract
  
{
    key wbhk.tkonn                                as TradingContract,
    
        @ObjectModel.foreignKey.association: '_TradingContractTypeDesc'
        wbhk.tctyp                                as TradingContractType,
        
        case
        when wbhk.kunnr is not initial then wbhk.kunnr
        else wbhd.elifn  end                      as Counterparty, 
        
        @ObjectModel.foreignKey.association: '_CompanyCode'
        wbhk.company_code                         as CompanyCode,
        
        wbhk.btbsta                               as TrdgContrApplicationStatus,
        
        wbhk.tkwaers                              as TradingContractCurrency,
        
        case when wbhk.knumv_sd is not initial then wbhk.knumv_sd
        else wbhd.knumv_mm end                    as PrepaymentRefDocCondition,
        
//      Associations

        _TradingContractItem,
        _TradingContractTypeDesc,
        _CompanyCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WBHD",
"WBHK"
],
"ASSOCIATED":
[
"E_TRADINGCONTRACT",
"I_COMPANYCODE",
"I_PREAGRMTTRADINGCONTRACTITEM",
"I_PREAGRMTTRDGCONTRTYPEDESC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More