I_NetworkActivityUserFields

DDL: I_NETWORKACTIVITYUSERFIELDS SQL: INWACTUSFIELD Type: view BASIC

Network Activity User Fields

I_NetworkActivityUserFields is a Basic CDS View that provides data about "Network Activity User Fields" in SAP S/4HANA. It reads from 1 data source (afvu) and exposes 27 fields with key fields ProjectNetworkInternalID, NetworkActivityInternalID. It has 1 association to related views.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
afvu afvu from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FreeDfndTblFieldSemanticText _UserFieldLabel $projection.FreeDefinedTableFieldSemantic = _UserFieldLabel.FreeDefinedTableFieldSemantic and _UserFieldLabel.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName INWACTUSFIELD view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Network Activity User Fields view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetworkInternalID afvu aufpl
KEY NetworkActivityInternalID afvu aplzl
JointVenture afvu vname
JointVentureSubClass afvu jv_jibsa
JointVentureClass afvu jv_jibcl
JointVentureObjectType afvu jv_otype
JntVentureOriglCostObjectType afvu jv_oco
FreeDefinedIndicator2 afvu usr11
FreeDefinedIndicator1 afvu usr10
FreeDefinedDate2 afvu usr09
FreeDefinedDate1 afvu usr08
FreeDefinedAmount2
FreeDefinedAmount1
FreeDefinedQuantity2 afvu usr05
FreeDefinedQuantity1 afvu usr04
FreeDefinedAttribute04 afvu usr03
FreeDefinedAttribute03 afvu usr02
FreeDefinedAttribute02 afvu usr01
FreeDefinedAttribute01 afvu usr00
FreeDefinedAmount1Currency afvu use06
FreeDefinedAmount2Currency afvu use07
FreeDefinedQuantity2Unit afvu use05
FreeDefinedQuantity1Unit afvu use04
FreeDefinedTableFieldSemantic afvu slwid
JointVentureRecoveryCode afvu recid
JointVentureEquityType afvu etype
_UserFieldLabel _UserFieldLabel 
@AbapCatalog.sqlViewName: 'INWACTUSFIELD'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Network Activity User Fields'
define view I_NetworkActivityUserFields
  as select from afvu
  association [0..1] to I_FreeDfndTblFieldSemanticText as _UserFieldLabel on  $projection.FreeDefinedTableFieldSemantic = _UserFieldLabel.FreeDefinedTableFieldSemantic
                                                                          and _UserFieldLabel.Language                  = $session.system_language
{
  key afvu.aufpl                                as ProjectNetworkInternalID,
  key afvu.aplzl                                as NetworkActivityInternalID,
      afvu.vname                                as JointVenture,
      afvu.jv_jibsa                             as JointVentureSubClass,
      afvu.jv_jibcl                             as JointVentureClass,
      afvu.jv_otype                             as JointVentureObjectType,
      afvu.jv_oco                               as JntVentureOriglCostObjectType,
      afvu.usr11                                as FreeDefinedIndicator2,
      afvu.usr10                                as FreeDefinedIndicator1,
      afvu.usr09                                as FreeDefinedDate2,
      afvu.usr08                                as FreeDefinedDate1,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount2Currency'
      cast ( afvu.usr07 as abap.curr( 13, 2 ) ) as FreeDefinedAmount2,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount1Currency'
      cast ( afvu.usr06 as abap.curr( 13, 2 ) ) as FreeDefinedAmount1,
      @Semantics.quantity.unitOfMeasure: 'FreeDefinedQuantity2Unit'
      afvu.usr05                                as FreeDefinedQuantity2,
      @Semantics.quantity.unitOfMeasure: 'FreeDefinedQuantity1Unit'
      afvu.usr04                                as FreeDefinedQuantity1,
      afvu.usr03                                as FreeDefinedAttribute04,
      afvu.usr02                                as FreeDefinedAttribute03,
      afvu.usr01                                as FreeDefinedAttribute02,
      afvu.usr00                                as FreeDefinedAttribute01,
      @Semantics.currencyCode: true
      afvu.use06                                as FreeDefinedAmount1Currency,
      @Semantics.currencyCode: true
      afvu.use07                                as FreeDefinedAmount2Currency,
      @Semantics.unitOfMeasure: true
      afvu.use05                                as FreeDefinedQuantity2Unit,
      @Semantics.unitOfMeasure: true
      afvu.use04                                as FreeDefinedQuantity1Unit,
      afvu.slwid                                as FreeDefinedTableFieldSemantic,
      //new

      afvu.recid                                as JointVentureRecoveryCode,
      afvu.etype                                as JointVentureEquityType,

      _UserFieldLabel
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFVU"
],
"ASSOCIATED":
[
"I_FREEDFNDTBLFIELDSEMANTICTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More