P_DGR_GEN_PLANTCCODE_MATERIAL

CDS View

P_DGR_GEN_PLANTCCODE_MATERIAL is a CDS View in S/4HANA. It contains 1 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DGR_Gen_Material_Commodity view from COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
Material Material 1
@AbapCatalog.sqlViewName: 'PDGRPLNTCCDEMAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

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

@VDM.viewType: #BASIC
@VDM.private: true

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D -- View will be consumed for Analytical Reporting
@ObjectModel.usageType.sizeCategory: #XXL -- No. of Records > 100,000

//@EndUserText.label: 'Get Plant Company Code Material'


define view P_DGR_Gen_PlantCCode_Material
  as select from t001k as T001K
    inner join   marc  as Material on t001k.bwkey = Material.werks
{
  t001k.bukrs    as CompanyCode,
  t001k.bwkey    as Plant,
  Material.matnr as Material

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARC",
"T001K"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/