I_JntVntrProjectType

DDL: I_JNTVNTRPROJECTTYPE SQL: IJVPROJTY Type: view BASIC

Joint Venture Project Type

I_JntVntrProjectType is a Basic CDS View that provides data about "Joint Venture Project Type" in SAP S/4HANA. It reads from 1 data source (t8j7d) and exposes 13 fields with key fields CompanyCode, JntVntrProjectType. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
t8j7d t8j7d from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..*] I_JntVntrProjectTypeText _JntVntrProjectTypeText $projection.CompanyCode = _JntVntrProjectTypeText.CompanyCode and $projection.JntVntrProjectType = _JntVntrProjectTypeText.JntVntrProjectType
[0..1] I_JntVntrOvhdBurdenRateType _JntVntrOvhdBurdenRateType $projection.CompanyCode = _JntVntrOvhdBurdenRateType.CompanyCode and $projection.JointVentureBurdenRateType = _JntVntrOvhdBurdenRateType.JointVentureBurdenRateType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IJVPROJTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Joint Venture Project Type view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
KEY JntVntrProjectType type
JVAProjIsAuthzdForCptlExpndtr ceind
JVAProjIsAuthzdForExpndtr afeind
JointVentureProjIsCatastrophic catind
JointVentureBurdenRateType drilind
JointVentureProjOverheadType ohtype
JVAProjManipulateRuleIsOvrrde mr_overide
JntVntrPenaltyCategory pencat
JointVentureFieldStatus fsver
_CompanyCode _CompanyCode
_JntVntrProjectTypeText _JntVntrProjectTypeText
_JntVntrOvhdBurdenRateType _JntVntrOvhdBurdenRateType 
@AbapCatalog.sqlViewName: 'IJVPROJTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Joint Venture Project Type'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_JntVntrProjectType
  as select from t8j7d
  association [0..1] to I_CompanyCode               as _CompanyCode               on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..*] to I_JntVntrProjectTypeText    as _JntVntrProjectTypeText    on  $projection.CompanyCode        = _JntVntrProjectTypeText.CompanyCode
                                                                                  and $projection.JntVntrProjectType = _JntVntrProjectTypeText.JntVntrProjectType
  association [0..1] to I_JntVntrOvhdBurdenRateType as _JntVntrOvhdBurdenRateType on  $projection.CompanyCode                = _JntVntrOvhdBurdenRateType.CompanyCode
                                                                                  and $projection.JointVentureBurdenRateType = _JntVntrOvhdBurdenRateType.JointVentureBurdenRateType
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key cast( bukrs as fis_bukrs preserving type ) as CompanyCode,
      @ObjectModel.text.association: '_JntVntrProjectTypeText'
  key type                                       as JntVntrProjectType,
      ceind                                      as JVAProjIsAuthzdForCptlExpndtr, //CAFE Indicator

      afeind                                     as JVAProjIsAuthzdForExpndtr,     //AFE Indicator

      catind                                     as JointVentureProjIsCatastrophic,
      @ObjectModel.text.association: '_JntVntrOvhdBurdenRateType'
      drilind                                    as JointVentureBurdenRateType,
      ohtype                                     as JointVentureProjOverheadType,
      mr_overide                                 as JVAProjManipulateRuleIsOvrrde,
      pencat                                     as JntVntrPenaltyCategory,
      fsver                                      as JointVentureFieldStatus,

      _CompanyCode,
      _JntVntrProjectTypeText,
      _JntVntrOvhdBurdenRateType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T8J7D"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_JNTVNTROVHDBURDENRATETYPE",
"I_JNTVNTRPROJECTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More