I_ACMContrItmData

DDL: I_ACMCONTRITMDATA SQL: IACMCONTITEMDATA Type: view BASIC

Contract Item data

I_ACMContrItmData is a Basic CDS View that provides data about "Contract Item data" in SAP S/4HANA. It reads from 1 data source (wbhi) and exposes 7 fields with key fields ContractNum, ContractItem, ContractSubItem.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
wbhi wbhi from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMCONTITEMDATA view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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 #D view
EndUserText.label Contract Item data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ContractNum tkonn
KEY ContractItem tposn
KEY ContractSubItem tposn_sub
ContractPlant werks
ContractStorageLocation lgort
ContractMaterial matnr
MaterialBaseUnit basis_meins 
@AbapCatalog.sqlViewName: 'IACMCONTITEMDATA'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

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

@VDM.viewType: #BASIC

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@EndUserText.label: 'Contract Item data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities:#CDS_MODELING_DATA_SOURCE
define view I_ACMContrItmData
  as select from wbhi
{
      //  key tkonn     as ContractNumber,

  key tkonn       as ContractNum,
  key tposn       as ContractItem,
  key tposn_sub   as ContractSubItem,
      werks       as ContractPlant,
      lgort       as ContractStorageLocation,
      matnr       as ContractMaterial,
      basis_meins as MaterialBaseUnit,
      case 
      when meins is not initial
      then meins      
      when vrkme is not initial
      then vrkme       
      end as TrdgContractItemUnitOfMeasure  
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WBHI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More