Which tables does SADL_V_Ref_Constr_Left use?

SADL_V_Ref_Constr_Left reads from 2 data source(s): snwd_bp, snwd_so.

How many fields does SADL_V_Ref_Constr_Left have?

SADL_V_Ref_Constr_Left has 14 fields. Key fields: SalesOrder.

SADL_V_Ref_Constr_Left

DDL: SADL_V_REF_CONSTR_LEFT SQL: SADLVRCL Type: view

Test view for referential constraints

SADL_V_Ref_Constr_Left is a CDS View that provides data about "Test view for referential constraints" in SAP S/4HANA. It reads from 2 data sources (snwd_bp, snwd_so) and exposes 14 fields with key field SalesOrder. It has 5 associations to related views.

Data Sources (2)

Source	Alias	Join Type
snwd_bp	snwd_bp	left_outer
snwd_so	snwd_so	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	SADL_V_Ref_Constr_Right	_AssociationViaID	`_AssociationViaID./aunit/BusinessPartner = $projection./aunit/BusinessPartner`
[0..1]	SADL_V_Ref_Constr_Right	_AssociationViaUUID	`_AssociationViaUUID.BusinessPartnerUUID = $projection.BusinessPartnerUUID`
[0..1]	SADL_V_Ref_Constr_Right	_AssociationWithFilter	`_AssociationWithFilter./aunit/BusinessPartner = $projection.BusinessPartner1 and _AssociationWithFilter.FilterCriterium = $projection.FilterCriterium`
[0..1]	SADL_V_Ref_Constr_Right	_AssociationWithConstant	`_AssociationWithConstant./aunit/BusinessPartner = $projection.BusinessPartner2 and _AssociationWithConstant.FilterCriterium = 'X'`
[0..1]	SADL_V_Ref_Constr_Right	_InvalidAssociation	`_InvalidAssociation./aunit/BusinessPartner = $projection.BusinessPartner3 and _InvalidAssociation.FilterCriterium = _InvalidAssociation.FilterCriterium`

Annotations (2)

Name	Value	Level	Field
AbapCatalog.sqlViewName	SADLVRCL	view
EndUserText.label	Test view for referential constraints	view

Fields (14)

Key	Field	Source Table	Source Field
KEY	SalesOrder	snwd_so	so_id
	SalesOrderUUID	snwd_so	node_key
	/aunit/BusinessPartner	snwd_bp	bp_id
	BusinessPartner1	snwd_bp	bp_id
	BusinessPartner2	snwd_bp	bp_id
	BusinessPartner3	snwd_bp	bp_id
	BusinessPartnerUUID	snwd_so	buyer_guid
	BusinessPartner0	snwd_bp	bp_id
	FilterCriterium
	_AssociationViaID		_AssociationViaID
	_AssociationViaUUID		_AssociationViaUUID
	_AssociationWithFilter		_AssociationWithFilter
	_AssociationWithConstant		_AssociationWithConstant
	_InvalidAssociation		_InvalidAssociation

@AbapCatalog.sqlViewName: 'SADLVRCL'
@EndUserText.label: 'Test view for referential constraints'

define view SADL_V_Ref_Constr_Left
  as select from    snwd_so
    left outer join snwd_bp on snwd_bp.node_key = snwd_so.buyer_guid

  association [0..1] to SADL_V_Ref_Constr_Right as _AssociationViaID        on  _AssociationViaID./aunit/BusinessPartner = $projection./aunit/BusinessPartner
  
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to SADL_V_Ref_Constr_Right as _AssociationViaUUID      on  _AssociationViaUUID.BusinessPartnerUUID = $projection.BusinessPartnerUUID

  association [0..1] to SADL_V_Ref_Constr_Right as _AssociationWithFilter   on  _AssociationWithFilter./aunit/BusinessPartner = $projection.BusinessPartner1
                                                                            and _AssociationWithFilter.FilterCriterium = $projection.FilterCriterium

  association [0..1] to SADL_V_Ref_Constr_Right as _AssociationWithConstant on  _AssociationWithConstant./aunit/BusinessPartner = $projection.BusinessPartner2
                                                                            and _AssociationWithConstant.FilterCriterium = 'X'

  association [0..1] to SADL_V_Ref_Constr_Right as _InvalidAssociation      on  _InvalidAssociation./aunit/BusinessPartner = $projection.BusinessPartner3
                                                                            and _InvalidAssociation.FilterCriterium = _InvalidAssociation.FilterCriterium
{
  key snwd_so.so_id      as SalesOrder,

      @Consumption.hidden: true
      snwd_so.node_key   as SalesOrderUUID,

      @ObjectModel.foreignKey.association: '_AssociationViaID'
      snwd_bp.bp_id      as /aunit/BusinessPartner,
      
      @ObjectModel.foreignKey.association: '_AssociationWithFilter'
      snwd_bp.bp_id      as BusinessPartner1,

      @ObjectModel.foreignKey.association: '_AssociationWithConstant'
      snwd_bp.bp_id      as BusinessPartner2,

      @ObjectModel.foreignKey.association: '_InvalidAssociation'
      snwd_bp.bp_id      as BusinessPartner3,

      @ObjectModel.foreignKey.association: '_AssociationViaUUID'
      snwd_so.buyer_guid as BusinessPartnerUUID,

      @ObjectModel.foreignKey.association: '_AssociationViaUUID'
      snwd_bp.bp_id as BusinessPartner0,

      'X'                as FilterCriterium,

      _AssociationViaID,
      _AssociationViaUUID,
      _AssociationWithFilter,
      _AssociationWithConstant,
      _InvalidAssociation
} 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_BP",
"SNWD_SO"
],
"ASSOCIATED":
[
"SADL_V_REF_CONSTR_RIGHT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Depth:

SADL_V_Ref_Constr_Left view