P_VarConfignPlntSpcfcProdVar

DDL: P_VARCONFIGNPLNTSPCFCPRODVAR SQL: PAVCPLSPCFCPVAR Type: view BASIC

P_VarConfignPlntSpcfcProdVar is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (mara, v_marc_md) and exposes 8 fields with key fields ProductVariant, Plant.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
mara Product inner
v_marc_md ProductPlant from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PAVCPLSPCFCPVAR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProductVariant v_marc_md matnr
KEY Plant v_marc_md werks
Product v_marc_md stdpd
ProductConfiguration v_marc_md cuobj
CreatedByUser mara ernam
CreationDate mara ersda
laedaendasLastChangeDate
aenamendasLastChangedByUser 
@AbapCatalog.sqlViewName: 'PAVCPLSPCFCPVAR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #BASIC
define view P_VarConfignPlntSpcfcProdVar
    as select from v_marc_md as ProductPlant
    inner join mara as Product on ProductPlant.matnr = Product.matnr
{
    key ProductPlant.matnr    as ProductVariant,
    key ProductPlant.werks    as Plant,
        ProductPlant.stdpd    as Product,
        ProductPlant.cuobj    as ProductConfiguration,
        Product.ernam         as CreatedByUser,
        Product.ersda         as CreationDate,
        
    case
      when Product.laeda = '00000000' 
           or Product.laeda is null
           then Product.ersda
      else Product.laeda
    end                       as LastChangeDate,
    
    case
      when Product.laeda = '00000000' 
          or Product.laeda is null
          then Product.ernam
      else Product.aenam
    end                       as LastChangedByUser  
} where ProductPlant.cuobj != '000000000000000000' and 
        ProductPlant.lvorm != 'X' and //Deletion marker

        Product.lvorm != 'X' //Deletion marker

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

Learn More