I_ACMTrdgContrHdrFltrDet

DDL: I_ACMTRDGCONTRHDRFLTRDET SQL: IACMTCHDRFLTDET Type: view BASIC

Trading Contract Header Filter detail

I_ACMTrdgContrHdrFltrDet is a Basic CDS View that provides data about "Trading Contract Header Filter detail" in SAP S/4HANA. It reads from 2 data sources (wbhk, /accgo/t_cak_typ) and exposes 19 fields.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
wbhk ContrHdr from
/accgo/t_cak_typ ContrType inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IACMTCHDRFLTDET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Trading Contract Header Filter detail view

Fields (19)

KeyFieldSource TableSource FieldDescription
TradingContractNumber wbhk tkonn
TradingContractType wbhk tctyp
ContractStatus wbhk btbsta
SalesOrganization wbhk vkorg
DistributionChannel wbhk vtweg
TradingContractExternalID wbhk tkonn_ex
DocumentDate wbhk budat
PersonResponsible wbhk tksachb
TradingContractCreatedBy wbhk ernam
TradingContractChangedBy wbhk aenam
TradingContractChangedOnDate wbhk aedat
TrdgContrGoodsSupplier wbhk kunnr
Division wbhk spart
TradingContractSalesCurrency wbhk sdwrs
CompanyCode wbhk company_code
PricingDocument wbhk knumv_sd
TradingContrCreatedOnDate wbhk erdat
ACMTrdgContrStatusCategory Contrstat category
ACMContractStatusIsPosRelevant Contrstat posrel 
@AbapCatalog.sqlViewName: 'IACMTCHDRFLTDET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Trading Contract Header Filter detail'
define view I_ACMTrdgContrHdrFltrDet
  as select from            wbhk             as ContrHdr
    inner join              /accgo/t_cak_typ as ContrType on ContrHdr.tctyp = ContrType.tctyp
    left outer to many join /accgo/t_cakstat as Contrstat on  ContrHdr.btbsta    = Contrstat.btbsta
                                                          and Contrstat.category = 'C'
                                                          and Contrstat.posrel   = 'X'
{
  ContrHdr.tkonn        as TradingContractNumber,
  ContrHdr.tctyp        as TradingContractType,
  ContrHdr.btbsta       as ContractStatus,
  ContrHdr.vkorg        as SalesOrganization,
  ContrHdr.vtweg        as DistributionChannel,
  ContrHdr.tkonn_ex     as TradingContractExternalID,
  ContrHdr.budat        as DocumentDate,
  ContrHdr.tksachb      as PersonResponsible,
  ContrHdr.ernam        as TradingContractCreatedBy,
  ContrHdr.aenam        as TradingContractChangedBy,
  ContrHdr.aedat        as TradingContractChangedOnDate,
  ContrHdr.kunnr        as TrdgContrGoodsSupplier,
  ContrHdr.spart        as Division,
  ContrHdr.sdwrs        as TradingContractSalesCurrency,
  ContrHdr.company_code as CompanyCode,
  ContrHdr.knumv_sd     as PricingDocument,
  ContrHdr.erdat        as TradingContrCreatedOnDate,
  Contrstat.category    as ACMTrdgContrStatusCategory,
  Contrstat.posrel      as ACMContractStatusIsPosRelevant
}
where
     ContrType.contract_type = 'C'
  or ContrType.contract_type = 'I'
  or ContrType.contract_type = 'R'
  or ContrType.contract_type = 'Q'
  or ContrType.contract_type = 'F'
  or ContrType.contract_type = 'X'
  or ContrType.contract_type = 'S'

Learn More