I_ContractAccountHeader

DDL: I_CONTRACTACCOUNTHEADER Type: view_entity BASIC Package: FKKV

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 15 fields with key field ContractAccount. It has 3 associations to related views. Part of development package FKKV.

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 (20)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.technicalName ICTRACCHEADER 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
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix VKK view
AbapCatalog.extensibility.quota.maximumFields 170 view
AbapCatalog.extensibility.quota.maximumBytes 3400 view

Fields (15)

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
ContractAccountUUID vkuuid
_ApplArea _ApplArea
_Category _Category
@AccessControl.authorizationCheck: #MANDATORY

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

@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

@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'VKK',
  dataSources: [ '_Extension' ],
  quota: {
    maximumFields: 170,
    maximumBytes: 3400
  }
}


define view entity 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,
      @Semantics.uuid: true
      vkuuid                               as ContractAccountUUID,

      _ApplArea,
      _Category
}