P_VARCONFIGNXPLANTPRODVARIANT

CDS View

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

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SimulationObjectUnion view union_all CONSUMPTION

Fields (6)

KeyField CDS FieldsUsed in Views
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Product Product 1
ProductVariant ProductVariant 1 
@AbapCatalog.sqlViewName: 'PAVCXPLANTPVAR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #BASIC
define view P_VarConfignXPlantProdVariant as
  select from mara
{
    key mara.matnr            as ProductVariant,
    satnr                     as Product,
    ernam                     as CreatedByUser,
    ersda                     as CreationDate,
        
    case
      when laeda = '00000000' 
           or laeda is null
           then ersda
      else laeda
    end                       as LastChangeDate,
    
    case
      when laeda = '00000000' 
          or laeda is null
          then ernam
      else aenam
    end                       as LastChangedByUser,
    
    cuobf                     as ProductConfiguration   
} where 
  satnr is not null  and //Filter for Cross-Plant Product Variants

  cuobf != '000000000000000000' and 
  lvorm != 'X' //Deletion marker

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

Learn More