I_ACMContractItemBasicData

DDL: I_ACMCONTRACTITEMBASICDATA SQL: IACMCNTRITMDATA Type: view BASIC

Contract Item Basic Data

I_ACMContractItemBasicData is a Basic CDS View that provides data about "Contract Item Basic Data" in SAP S/4HANA. It reads from 3 data sources (wbhk, P_TradingContractType, wbhi) and exposes 6 fields with key fields ContractNum, TradingContractItem, ContractSubItem.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
wbhk ContractHeader inner
P_TradingContractType ContractType inner
wbhi ContrItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMCNTRITMDATA view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
EndUserText.label Contract Item Basic Data view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ContractNum wbhi tkonn
KEY TradingContractItem wbhi tposn
KEY ContractSubItem wbhi tposn_sub
ContractMaterial wbhi matnr
vrkmeendasTrdgContractItemUnitOfMeasure
SAPClient 
@AbapCatalog.sqlViewName: 'IACMCNTRITMDATA'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true

@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #B
@EndUserText.label: 'Contract Item Basic Data'
@Metadata.ignorePropagatedAnnotations: true
define view I_ACMContractItemBasicData as select from wbhi as ContrItem
  inner join wbhk                  as ContractHeader on ContrItem.tkonn   = ContractHeader.tkonn
  inner join P_TradingContractType as ContractType   on ContractHeader.tctyp = ContractType.tctyp
  {

  key ContrItem.tkonn     as ContractNum,
  key ContrItem.tposn     as TradingContractItem,
  key ContrItem.tposn_sub as ContractSubItem,
      ContrItem.matnr     as ContractMaterial,
      case ContractType.Side
      when 'P' then ContrItem.meins
      when 'S' then ContrItem.vrkme
      end as TrdgContractItemUnitOfMeasure,
      $session.client as SAPClient
}

Learn More