I_PrepaymentInvalidContracts

DDL: I_PREPAYMENTINVALIDCONTRACTS SQL: IPPMTINV Type: view BASIC

Prepayment Agreement invalid contracts

I_PrepaymentInvalidContracts is a Basic CDS View that provides data about "Prepayment Agreement invalid contracts" in SAP S/4HANA. It reads from 3 data sources (/accgo/t_cakitm, /accgo/t_cak_typ, wbhk) and exposes 3 fields.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
/accgo/t_cakitm ContractItem from
/accgo/t_cak_typ tctype inner
wbhk TradingContract inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPPMTINV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Prepayment Agreement invalid contracts view

Fields (3)

KeyFieldSource TableSource FieldDescription
TradingContract /accgo/t_cakitm tkonn
TradingContractItem /accgo/t_cakitm tposn
IsRejected 
@AbapCatalog.sqlViewName: 'IPPMTINV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType  : #BASIC
@ObjectModel.usageType.sizeCategory         : #L
@ObjectModel.usageType.serviceQuality       : #A
@ObjectModel.usageType.dataClass            : #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations       : true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Prepayment Agreement invalid contracts'

define view I_PrepaymentInvalidContracts as select from /accgo/t_cakitm as ContractItem

inner join wbhk as TradingContract
  on  TradingContract.tkonn  = ContractItem.tkonn

inner join /accgo/t_cak_typ as tctype 
  on  tctype.tctyp = TradingContract.tctyp
  
{
  
  ContractItem.tkonn as TradingContract,
  ContractItem.tposn as TradingContractItem,
  cast( 'X' as boole_d preserving type) as IsRejected   
  
 }   

 where pymnt_type   is not initial 
  or   pymnt_terms  is not initial
  or   pymnt_type   is not initial
  or   pymnt_date   is not initial  
  or   tctype.contract_type = 'I'    
  or   tctype.contract_type = 'R' 
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ACCGO/T_CAKITM",
"/ACCGO/T_CAK_TYP",
"WBHK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More