Atpc_Cds_Vbbe

DDL: ATPC_CDS_VBBE SQL: ATPC_VBBE Type: view

CDS View on VBBE Table for ATP

Atpc_Cds_Vbbe is a CDS View that provides data about "CDS View on VBBE Table for ATP" in SAP S/4HANA. It reads from 1 data source (vbbe) and exposes 21 fields.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
vbbe vbbe from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_VBBE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label CDS View on VBBE Table for ATP view

Fields (21)

KeyFieldSource TableSource FieldDescription
mandt vbbe mandt
delnr vbbe vbeln
delps vbbe posnr
delet vbbe etenr
vbtyp vbbe vbtyp
vgtyp lips vgtyp
atpcat
sort1
sort2
matnr vbbe matnr
werks vbbe werks
lgort vbbe lgort
charg vbbe charg
sgt_rcat vbbe sgt_rcat
kdauf vbbe vbele
kdpos vbbe posne
pspel vbbe pspel
kunnr vbbe kunnr
atpdate vbbe mbdat
reqqty vbbe omeng
cnfqty vbbe vmeng 
@AbapCatalog.sqlViewName: 'ATPC_VBBE'
@ObjectModel.usageType: {
    serviceQuality: #X,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'CDS View on VBBE Table for ATP'
define view Atpc_Cds_Vbbe
  as select from vbbe
  association to lips on  vbbe.vbeln = lips.vbeln
                      and vbbe.posnr = lips.posnr
{
  //  key the single select

  vbbe.mandt                                   as mandt,
  vbbe.vbeln                                   as delnr,
  vbbe.posnr                                   as delps,
  vbbe.etenr                                   as delet,
  vbbe.vbtyp                                   as vbtyp,
  lips.vgtyp                                   as vgtyp,
  cast(concat('V',vbbe.vbtyp) as abap.char(2)) as atpcat,
  '2'                                          as sort1,
  '03'                                         as sort2,
  //  key for mass select

  vbbe.matnr                                   as matnr,
  vbbe.werks                                   as werks,
  vbbe.lgort                                   as lgort,
  vbbe.charg                                   as charg,
  vbbe.sgt_rcat                                as sgt_rcat,
  //  sobkz

  case when vbbe.sobkz = 'K' then ''
                        else vbbe.sobkz
  end                                          as sobkz,
  case when vbbe.sobkz = 'E' then vbbe.vbele
       when vbbe.sobkz = 'Q' then vbbe.pspel
       when vbbe.sobkz = 'V' or
            vbbe.sobkz = 'W' or
            vbbe.sobkz = 'B' then vbbe.kunnr
                        else ''
  end                                          as sskey,
  case when vbbe.sobkz = 'E' then vbbe.posne
                        else ''
  end                                          as sskey_ext,
  vbbe.vbele                                   as kdauf,
  vbbe.posne                                   as kdpos,
  vbbe.pspel                                   as pspel,
  vbbe.kunnr                                   as kunnr,
  //  ATP Data

  vbbe.mbdat                                   as atpdate,
  vbbe.omeng                                   as reqqty,
  vbbe.vmeng                                   as cnfqty
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LIPS",
"VBBE"
],
"ASSOCIATED":
[
"LIPS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More