Atpc_Cds_Ebkn

DDL: ATPC_CDS_EBKN SQL: ATPC_EBKN Type: view

CDS View on EBKN Table for ATP

Atpc_Cds_Ebkn is a CDS View that provides data about "CDS View on EBKN Table for ATP" in SAP S/4HANA. It reads from 1 data source (ebkn) and exposes 6 fields.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
ebkn ebkn from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_EBKN 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 EBKN Table for ATP view

Fields (6)

KeyFieldSource TableSource FieldDescription
mandt ebkn mandt
banfn ebkn banfn
bnfpo ebkn bnfpo
vbeln
vbelp
ps_psp_pnr 
@AbapCatalog.sqlViewName: 'ATPC_EBKN'
@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 EBKN Table for ATP'
define view Atpc_Cds_Ebkn as
select from ebkn as ebkn
{
    ebkn.mandt, 
    ebkn.banfn,
    ebkn.bnfpo,
    min(ebkn.vbeln) as vbeln,
    min(ebkn.vbelp) as vbelp,  
    min(ebkn.ps_psp_pnr) as ps_psp_pnr 
}
where
    loekz = ''
group by
    banfn,
    bnfpo   
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"EBKN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More