FAC_CDS_UH_FSV_CONTRAITEM

DDL: FAC_CDS_UH_FSV_CONTRAITEM SQL: FACV_UH_FSVCV Type: view

Universal Hierarchy FSV Contra Items

FAC_CDS_UH_FSV_CONTRAITEM is a CDS View that provides data about "Universal Hierarchy FSV Contra Items" in SAP S/4HANA. It reads from 2 data sources (uhdt_node, uhdt_vrsn) and exposes 13 fields with key field NodeId.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
uhdt_node node from
uhdt_vrsn version inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UH_FSVCV view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Universal Hierarchy FSV Contra Items view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY NodeId uhdt_node node_id
NodeType uhdt_node node_type
NodeValue uhdt_node node_lval
ContraItem
Credit
Debit
VersionId uhdt_node ver_id
HierarchyId uhdt_vrsn hier_hid
VersionNumber uhdt_vrsn ver_nbr
VersionMessage uhdt_vrsn ver_msg
ValidFrom uhdt_vrsn ver_vldfm
ValidTo uhdt_vrsn ver_vldto
Status uhdt_vrsn ver_status 
@AbapCatalog.sqlViewName: 'FACV_UH_FSVCV'
@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Universal Hierarchy FSV Contra Items'
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
define view FAC_CDS_UH_FSV_CONTRAITEM as select from uhdt_node as node
inner join uhdt_vrsn as version on node.ver_id = version.ver_id
association[0..*] to uhdt_nattrvals as to_attr on node.node_id = to_attr.node_id
{
  key node.node_id as NodeId,
  node.node_type as NodeType,
  node.node_lval as NodeValue,
  to_attr[1: attr_name = 'CONTRA_ITEM'].attr_lval as ContraItem,
  to_attr[1: attr_name = 'CREDIT'].attr_lval as Credit,
  to_attr[1: attr_name = 'DEBIT'].attr_lval as Debit,
  node.ver_id as VersionId,
  version.hier_hid as HierarchyId,
  version.ver_nbr as VersionNumber,
  version.ver_msg as VersionMessage,
  version.ver_vldfm as ValidFrom,
  version.ver_vldto as ValidTo,
  version.ver_status as Status
}
where version.hier_catg = 'FSVN'
and to_attr[1: attr_name = 'CONTRA_ITEM'].attr_lval <> ''
and node.node_type = 'N'
and version.ver_status <> 'T'
and version.ver_status <> 'B' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UHDT_NATTRVALS",
"UHDT_NODE",
"UHDT_VRSN"
],
"ASSOCIATED":
[
"UHDT_NATTRVALS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More