R_CustomerMaterialTP

DDL: R_CUSTOMERMATERIALTP Type: view_entity TRANSACTIONAL

Customer Material - TP

R_CustomerMaterialTP is a Transactional CDS View that provides data about "Customer Material - TP" in SAP S/4HANA. It reads from 1 data source (I_CustomerMaterial_2) and exposes 28 fields with key fields SalesOrganization, DistributionChannel, Customer, Product. It has 1 association to related views.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerMaterial_2 CustomerMaterial from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_CustomerMaterialLongTextTP _Text

Annotations (9)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name CustomerMaterial view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Customer Material - TP view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization I_CustomerMaterial_2 SalesOrganization
KEY DistributionChannel I_CustomerMaterial_2 DistributionChannel
KEY Customer I_CustomerMaterial_2 Customer
KEY Product I_CustomerMaterial_2 Product
SalesOrganizationForEdit SalesOrganization
DistributionChannelForEdit DistributionChannel
CustomerForEdit Customer
ProductForEdit Product
MaterialByCustomer I_CustomerMaterial_2 MaterialByCustomer
MaterialDescriptionByCustomer I_CustomerMaterial_2 MaterialDescriptionByCustomer
CustomerMaterialSearchTerm CustomerMaterialSearchTerm
Plant I_CustomerMaterial_2 Plant
DeliveryPriority I_CustomerMaterial_2 DeliveryPriority
MinDeliveryQtyInBaseUnit I_CustomerMaterial_2 MinDeliveryQtyInBaseUnit
BaseUnit I_CustomerMaterial_2 BaseUnit
PartialDeliveryIsAllowed PartialDeliveryIsAllowed
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed
CustomerMaterialItemUsage CustomerMaterialItemUsage
SalesUnit SalesUnit
SalesQtyToBaseQtyDnmntr SalesQtyToBaseQtyDnmntr
SalesQtyToBaseQtyNmrtr SalesQtyToBaseQtyNmrtr
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Customer _Customer
_Text _Text 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@ObjectModel: {
    sapObjectNodeType:{
        name: 'CustomerMaterial'
    },
    usageType: {
        dataClass: #MASTER,
        serviceQuality: #A,
        sizeCategory: #M
    }
}

@AccessControl.authorizationCheck: #MANDATORY

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Customer Material - TP'
define root view entity R_CustomerMaterialTP
  as select from I_CustomerMaterial_2 as CustomerMaterial

  composition [0..*] of R_CustomerMaterialLongTextTP as _Text

{
  key CustomerMaterial.SalesOrganization,
  key CustomerMaterial.DistributionChannel,
  key CustomerMaterial.Customer,
  key CustomerMaterial.Product,

      @ObjectModel.editableFieldFor: 'SalesOrganization'
      SalesOrganization   as SalesOrganizationForEdit,
      @ObjectModel.editableFieldFor: 'DistributionChannel'      
      DistributionChannel as DistributionChannelForEdit,
      @ObjectModel.editableFieldFor: 'Customer'      
      Customer            as CustomerForEdit,
      @ObjectModel.editableFieldFor: 'Product'      
      Product             as ProductForEdit,

      CustomerMaterial.MaterialByCustomer,
      CustomerMaterial.MaterialDescriptionByCustomer,
      CustomerMaterialSearchTerm,

      CustomerMaterial.Plant,
      CustomerMaterial.DeliveryPriority,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      CustomerMaterial.MinDeliveryQtyInBaseUnit,
      CustomerMaterial.BaseUnit,

      PartialDeliveryIsAllowed,
      MaxNmbrOfPartialDelivery,
      UnderdelivTolrtdLmtRatioInPct,
      OverdelivTolrtdLmtRatioInPct,
      UnlimitedOverdeliveryIsAllowed,


      CustomerMaterialItemUsage,

      SalesUnit,
      SalesQtyToBaseQtyDnmntr,
      SalesQtyToBaseQtyNmrtr,

      LastChangedByUser,
      LastChangeDateTime,

      //For DCL

      _Customer,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERMATERIAL_2"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"R_CUSTOMERMATERIALLONGTEXTTP"
],
"BASE":
[
"I_CUSTOMERMATERIAL_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More