CDS Parameters

define view /BSH4/P__AC_DLVRYBLLNGQRY3 
//
with parameters
   P_Material : matnr      

as select from /BSH4/P__AI_DlvryBllngCUB   
{
 Material, 
 cast(:P_Material as matnr)                                                             as  Material2,  
} 
 where   Material = $parameters.P_Material ;






Comments

Post a Comment

Popular posts from this blog

Logistic Extractor Enhancements

2LIS_02_SCL Communication structures MCEKKO MCEKPO  MCEKET In LBWE there are additional fields in communication structures such as MCEKKO-KUNNR MCEKKO-BUKRS   , we can select them and add it to datasource  , unhide field and activate datasource. Fields automatically filled no need to write additional user exit. If the field (for example EKKO-INCO1) exist in core tables EKKO EKPO but doesn`t exist in communication structures , we can append  additional fields  to the communication structures MCEKKO (only inside to specific includes  MCEKKOUSR (data for the purchasing document header), MCEKPOUSR (purchasing document item), MCEKETUSR (purchasing document schedule lines), MCEKPVUSR (shipping data))... Fields automatically filled no need to write additional user exit. If the fields doesn`t exist in core procurment tables , then we can still append this field to communication structures and then fill them via user exit  ZXM06U16 (LEINS001)...
Read more