I_AdditionalCustomerMaterial

DDL: I_ADDITIONALCUSTOMERMATERIAL SQL: ISDADDCUSTMAT Type: view BASIC

Additional Customer Materials

I_AdditionalCustomerMaterial is a Basic CDS View that provides data about "Additional Customer Materials" in SAP S/4HANA. It reads from 1 data source (knmta) and exposes 8 fields with key fields SalesOrganization, DistributionChannel, Customer, Material, Product. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
knmta knmta from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CustomerMaterial _CustomerMaterial $projection.SalesOrganization = _CustomerMaterial.SalesOrganization and $projection.DistributionChannel = _CustomerMaterial.DistributionChannel and $projection.Customer = _CustomerMaterial.Customer and $projection.Material = _CustomerMaterial.Material and $projection.Product = _CustomerMaterial.Product

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Additional Customer Materials view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDADDCUSTMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization knmt vkorg
KEY DistributionChannel knmt vtweg
KEY Customer knmt kunnr
KEY Material knmt matnr
KEY Product
KEY MaterialByCustomer knmta kdmat
MaterialDescriptionByCustomer addpostx
_CustomerMaterial _CustomerMaterial 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #M 
@EndUserText.label: 'Additional Customer Materials'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDADDCUSTMAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@Metadata.ignorePropagatedAnnotations: true

define view I_AdditionalCustomerMaterial as 

select

from knmta
join knmt on knmta.guid = knmt.guid

association [1..1] to I_CustomerMaterial as _CustomerMaterial 
    on  $projection.SalesOrganization = _CustomerMaterial.SalesOrganization 
    and $projection.DistributionChannel = _CustomerMaterial.DistributionChannel
    and $projection.Customer = _CustomerMaterial.Customer
    and $projection.Material = _CustomerMaterial.Material
    and $projection.Product = _CustomerMaterial.Product

{
    key knmt.vkorg  as SalesOrganization,
    key knmt.vtweg  as DistributionChannel,
    key knmt.kunnr  as Customer,
    @VDM.lifecycle.status: #DEPRECATED
    @VDM.lifecycle.successor: 'Product'
    key knmt.matnr  as Material,
    key cast (knmt.matnr as productnumber preserving type) as Product,
    key knmta.kdmat as MaterialByCustomer,

    @Semantics.text: true
    addpostx        as MaterialDescriptionByCustomer,
    
    _CustomerMaterial
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNMT",
"KNMTA"
],
"ASSOCIATED":
[
"I_CUSTOMERMATERIAL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More