V_Copc_V_T035d_Ddl

DDL: V_COPC_V_T035D_DDL SQL: V_COPC_T035D Type: view

Redirection View for COPC_V_T035D

V_Copc_V_T035d_Ddl is a CDS View that provides data about "Redirection View for COPC_V_T035D" in SAP S/4HANA. It reads from 4 data sources (skb1, v_t012k_bam, t035d, t035u) and exposes 10 fields.

Data Sources (4)

SourceAliasJoin Type
skb1 skb1 inner
v_t012k_bam t012k inner
t035d T035D from
t035u T035U inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_COPC_T035D view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.dataClass MASTER view
EndUserText.label Redirection View for COPC_V_T035D view

Fields (10)

KeyFieldSource TableSource FieldDescription
mandt t035d mandt
bukrs t035d bukrs
diskb t035d diskb
bnkko t035d bnkko
bankn v_t012k_bam bankn
xpssk t035d xpssk
xhbza t035d xhbza
textl t035u textl
hbkid v_t012k_bam hbkid
hktid v_t012k_bam hktid
@AbapCatalog.sqlViewName: 'V_COPC_T035D'
@ObjectModel.usageType.serviceQuality: 'C'
@ObjectModel.usageType.sizeCategory: 'M'
@ObjectModel.usageType.dataClass: 'MASTER'
@EndUserText.label: 'Redirection View for COPC_V_T035D'
define view V_Copc_V_T035d_Ddl as select from t035d       as T035D
                                  inner join  t035u       as T035U on T035D.bukrs = T035U.bukrs
                                                                  and T035D.diskb = T035U.diskb
                                  inner join  skb1        as skb1  on skb1.bukrs  = T035D.bukrs
                                                                  and skb1.saknr  = T035D.bnkko
                                  inner join  v_t012k_bam as t012k on t012k.bukrs = skb1.bukrs
                                                                  and t012k.hbkid = skb1.hbkid
                                                                  and t012k.hktid = skb1.hktid
{
T035D.mandt,
T035D.bukrs,
T035D.diskb,
T035D.bnkko,
t012k.bankn,
T035D.xpssk,
T035D.xhbza,
T035U.textl,
t012k.hbkid,
t012k.hktid
}
   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SKB1",
"T035D",
"T035U",
"V_T012K_BAM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/