P_VARCONFIGNPLNTSPCFCPRODVAR

CDS View

Simulation: Plant Specific Product Variant

P_VARCONFIGNPLNTSPCFCPRODVAR is a CDS View in S/4HANA. Simulation: Plant Specific Product Variant. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SimulationObjectUnion view union_all CONSUMPTION Simulation - Simulation Objects Union

Fields (7)

KeyField CDS FieldsUsed in Views
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Plant Plant 1
Product Product 1
ProductVariant ProductVariant 1 
@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

Learn More