SADL_V_Ref_Constr_Right

DDL: SADL_V_REF_CONSTR_RIGHT SQL: SADLVRCR Type: view

Test view for referential constraints

SADL_V_Ref_Constr_Right is a CDS View that provides data about "Test view for referential constraints" in SAP S/4HANA. It reads from 1 data source (snwd_bp) and exposes 5 fields with key field /aunit/BusinessPartner. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
snwd_bp snwd_bp from

Associations (2)

CardinalityTargetAliasCondition
[0..*] SADL_V_Ref_Constr_Left _AssociationViaID _AssociationViaID./aunit/businesspartner = $projection./aunit/BusinessPartner
[0..*] SADL_V_Ref_Constr_Left _AssociationViaUUID _AssociationViaUUID.BusinessPartnerUUID = $projection.BusinessPartnerUUID

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SADLVRCR view
EndUserText.label Test view for referential constraints view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY /aunit/BusinessPartner snwd_bp bp_id
BusinessPartnerUUID snwd_bp node_key
FilterCriterium
_AssociationViaID _AssociationViaID
_AssociationViaUUID _AssociationViaUUID 
@AbapCatalog.sqlViewName: 'SADLVRCR'
@EndUserText.label: 'Test view for referential constraints'

define view SADL_V_Ref_Constr_Right
  as select from    snwd_bp
  
  association [0..*] to SADL_V_Ref_Constr_Left as _AssociationViaID on _AssociationViaID./aunit/businesspartner = $projection./aunit/BusinessPartner
  
  association [0..*] to SADL_V_Ref_Constr_Left as _AssociationViaUUID on _AssociationViaUUID.BusinessPartnerUUID = $projection.BusinessPartnerUUID
{
  key snwd_bp.bp_id      as /aunit/BusinessPartner,

      @Consumption.hidden: true
      snwd_bp.node_key as BusinessPartnerUUID,

      'X'                as FilterCriterium,
      
      _AssociationViaID,
      _AssociationViaUUID
} 
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_BP"
],
"ASSOCIATED":
[
"SADL_V_REF_CONSTR_LEFT"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More