V_Copc_V_T035d_Ddl
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)
| Source | Alias | Join Type |
|---|---|---|
| skb1 | skb1 | inner |
| v_t012k_bam | t012k | inner |
| t035d | T035D | from |
| t035u | T035U | inner |
Annotations (5)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA