R_ChemicalCustomerMaterialTP

DDL: R_CHEMICALCUSTOMERMATERIALTP Type: view_entity TRANSACTIONAL

Chemical Customer Material - TP

R_ChemicalCustomerMaterialTP is a Transactional CDS View that provides data about "Chemical Customer Material - TP" in SAP S/4HANA. It reads from 1 data source (I_ChemicalCustomerMaterial) and exposes 13 fields with key field ChemicalCustomerMaterialUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChemicalCustomerMaterial I_ChemicalCustomerMaterial from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_ChmlCmplncPrimMatl _PrimeMatPackaged $projection.ChmlCmplncInfoUUID = _PrimeMatPackaged.ChmlCmplncInfoUUID
[1..*] I_ChmlCustMatlLifeCycleStsText _ChmlCustMatlLifeCycleStsText $projection.ChmlCustMatlLifeCycleStatus = _ChmlCustMatlLifeCycleStsText.ChmlCustMatlLifeCycleStatus

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Chemical Customer Material - TP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey ChemicalCustomerMaterialUUID view
ObjectModel.sapObjectNodeType.name ChemicalCustomerMaterial view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
Customer Customer
ChmCstMtRtntnPerdStrtDteTme ChmCstMtRtntnPerdStrtDteTme
ChmlCustMatlLifeCycleStatus ChmlCustMatlLifeCycleStatus
_ChmlCmplncInfo _ChmlCmplncInfo
_ShipToParty _ShipToParty
_PrimeMatPackaged _PrimeMatPackaged
_ChmlCustMatlLifeCycleStsText _ChmlCustMatlLifeCycleStsText
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Chemical Customer Material - TP'
@ObjectModel: {
  usageType: {
    serviceQuality: #A,   
    sizeCategory:  #L,     // 100.000 - 9.999.999

    dataClass: #TRANSACTIONAL },
  representativeKey: 'ChemicalCustomerMaterialUUID', 
  sapObjectNodeType.name: 'ChemicalCustomerMaterial' }

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL }
  
@AccessControl.personalData.blocking: #REQUIRED

@Metadata.allowExtensions: true
define root view entity R_ChemicalCustomerMaterialTP       
   as select from I_ChemicalCustomerMaterial 
   
  association [0..1] to C_ChmlCmplncPrimMatl           as _PrimeMatPackaged           on $projection.ChmlCmplncInfoUUID = _PrimeMatPackaged.ChmlCmplncInfoUUID
  //add a text association in the projected view to be used in the projection view for Lifecycle Status

  association [1..*] to I_ChmlCustMatlLifeCycleStsText as _ChmlCustMatlLifeCycleStsText on $projection.ChmlCustMatlLifeCycleStatus = _ChmlCustMatlLifeCycleStsText.ChmlCustMatlLifeCycleStatus
{

  // this do not work for RAP

  //@ObjectModel.readOnly: true

  key ChemicalCustomerMaterialUUID,
      
      // Active UUID of CCM @TODO global field name

      // @ObjectModel.readOnly: true

      // TODO: used for Attachment Service, currently not for v4 available

      // cast( ChemicalCustomerMaterialUUID as  ehfnd_crr_active_uuid preserving type ) as ActiveChmlCustomerMaterialUUID,

  
      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangedByUser,
      ChmlCmplncInfoUUID,
      Customer,
      
      //_ChmlCmplncInfo._PrimaryMaterial.Material as ChmlCustomerMaterial,

      
      // DPP relevant fields

      ChmCstMtRtntnPerdStrtDteTme, 
      
      ChmlCustMatlLifeCycleStatus,
      
      //associations

      _ChmlCmplncInfo,
      _ShipToParty,
      _PrimeMatPackaged,
      _ChmlCustMatlLifeCycleStsText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHEMICALCUSTOMERMATERIAL"
],
"ASSOCIATED":
[
"C_CHMLCMPLNCPRIMMATL",
"I_CHMLCMPLNCINFO",
"I_CHMLCUSTMATLLIFECYCLESTSTEXT",
"I_CUSTOMER"
],
"BASE":
[
"I_CHEMICALCUSTOMERMATERIAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/