V_Copc_V_T012_Skb1_Ddl

DDL: V_COPC_V_T012_SKB1_DDL SQL: V_COPC_T012_SKB1 Type: view

Redirection View for COPC_V_T012_SKB1_DDL

V_Copc_V_T012_Skb1_Ddl is a CDS View that provides data about "Redirection View for COPC_V_T012_SKB1_DDL" in SAP S/4HANA. It reads from 2 data sources (skb1, v_t012k_bam) and exposes 11 fields.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
skb1 skb1 from
v_t012k_bam t012k_bam inner

Annotations (5)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
mandt skb1 mandt
bukrs skb1 bukrs
saknr skb1 saknr
hbkid v_t012k_bam hbkid
hktid v_t012k_bam hktid
bankn v_t012k_bam bankn
bkont v_t012k_bam bkont
waers v_t012k_bam waers
refzl v_t012k_bam refzl
dtaai v_t012k_bam dtaai
bnkn2 v_t012k_bam bnkn2 
@AbapCatalog.sqlViewName: 'V_COPC_T012_SKB1'
@ObjectModel.usageType.serviceQuality: 'C'
@ObjectModel.usageType.sizeCategory: 'M'
@ObjectModel.usageType.dataClass: 'MASTER'
@EndUserText.label: 'Redirection View for COPC_V_T012_SKB1_DDL'
define view V_Copc_V_T012_Skb1_Ddl
as select from        skb1        as skb1
          inner join  v_t012k_bam as t012k_bam on  t012k_bam.bukrs = skb1.bukrs
                                               and t012k_bam.hbkid = skb1.hbkid
                                               and t012k_bam.hktid = skb1.hktid
{
skb1.mandt,
skb1.bukrs,
skb1.saknr,
t012k_bam.hbkid,
t012k_bam.hktid,
t012k_bam.bankn,
t012k_bam.bkont,
t012k_bam.waers,
t012k_bam.refzl,
t012k_bam.dtaai,
t012k_bam.bnkn2
}
   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SKB1",
"V_T012K_BAM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More