I_ContractAccountHeader

DDL: I_CONTRACTACCOUNTHEADER SQL: ICTRACCHEADER Type: view BASIC

Contract Account

I_ContractAccountHeader is a Basic CDS View (Dimension) that provides data about "Contract Account" in SAP S/4HANA. It reads from 1 data source (fkkvk) and exposes 14 fields with key field ContractAccount. It has 3 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
fkkvk fkkvk from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CAApplicationArea _ApplArea $projection.CAApplicationArea = _ApplArea.CAApplicationArea
[1..1] I_ContractAccountCategory _Category $projection.ContractAccountCategory = _Category.ContractAccountCategory and $projection.CAApplicationArea = _Category.CAApplicationArea
[1..1] E_ContractAccountHeader _Extension $projection.ContractAccount = _Extension.ContractAccount

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ICTRACCHEADER view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Contract Account view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey ContractAccount view
ObjectModel.sapObjectNodeType.name ContractAccount view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount vkont
CreationDate erdat
CreationTime ertim
CreatedByUser ernam
IsMarkedForDeletion
LastChangeDate aedat
LastChangeTime aetim
LastChangedByUser aenam
CAApplicationArea applk
ContractAccountCategory vktyp
ContractAccountExtReference vkona
ContractAccountName vkbez
_ApplArea _ApplArea
_Category _Category 
@AbapCatalog.sqlViewName: 'ICTRACCHEADER'

@AccessControl.authorizationCheck: #MANDATORY

@Analytics: { dataCategory: #DIMENSION,
              internalName: #LOCAL,
              dataExtraction: { enabled: true,
                                delta.changeDataCapture.automatic: true } }

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Contract Account'

@Metadata: { ignorePropagatedAnnotations: true,
             allowExtensions:true }

@ObjectModel: { modelingPattern: #NONE,
                representativeKey: 'ContractAccount',
                sapObjectNodeType.name: 'ContractAccount',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #CDS_MODELING_DATA_SOURCE,
                                         #SQL_DATA_SOURCE,
                                         #EXTRACTION_DATA_SOURCE,
                                         #ANALYTICAL_DIMENSION  ],
                usageType: { dataClass: #MASTER,
                             serviceQuality: #A,
                             sizeCategory: #XL } }

@VDM.viewType: #BASIC

define view I_ContractAccountHeader
  as select from fkkvk

  association [1..1] to I_CAApplicationArea       as _ApplArea  on  $projection.CAApplicationArea = _ApplArea.CAApplicationArea
  association [1..1] to I_ContractAccountCategory as _Category  on  $projection.ContractAccountCategory = _Category.ContractAccountCategory
                                                                and $projection.CAApplicationArea       = _Category.CAApplicationArea
  
  association [1..1] to E_ContractAccountHeader   as _Extension on  $projection.ContractAccount = _Extension.ContractAccount

{
      @ObjectModel.text.element: [ 'ContractAccountName' ]
  key vkont                                as ContractAccount,
      @Semantics.systemDate.createdAt: true
      erdat                                as CreationDate,
      @Semantics.systemTime.createdAt: true
      ertim                                as CreationTime,
      @Semantics.user.createdBy: true
      ernam                                as CreatedByUser,
      cast(loevm as loevm preserving type) as IsMarkedForDeletion,
      @Semantics.systemDate.lastChangedAt: true
      aedat                                as LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      aetim                                as LastChangeTime,
      @Semantics.user.lastChangedBy: true
      aenam                                as LastChangedByUser,
      @ObjectModel.foreignKey.association: '_ApplArea'
      applk                                as CAApplicationArea,
      @ObjectModel.foreignKey.association: '_Category'
      vktyp                                as ContractAccountCategory,
      vkona                                as ContractAccountExtReference,
      @Semantics.text: true
      vkbez                                as ContractAccountName,

      _ApplArea,
      _Category
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FKKVK"
],
"ASSOCIATED":
[
"E_CONTRACTACCOUNTHEADER",
"I_CAAPPLICATIONAREA",
"I_CONTRACTACCOUNTCATEGORY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More