I_CoCodeCountryVATRegistration

DDL: I_COCODECOUNTRYVATREGISTRATION Type: view_entity BASIC Package: FOT_COMMON

Company Code Ctry/Reg VAT Registration

I_CoCodeCountryVATRegistration is a Basic CDS View (Dimension) that provides data about "Company Code Ctry/Reg VAT Registration" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, t001n) and exposes 15 fields with key fields CompanyCode, VATRegistrationCountry, VATRegistrationCountry. It has 3 associations to related views. Part of development package FOT_COMMON.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from
t001n t001n union_all

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Country _Country $projection.VATRegistrationCountry = _Country.Country
[0..1] I_OrgAddressDefaultRprstn _Address $projection.AddressID = _Address.AddressID

Annotations (14)

NameValueLevelField
EndUserText.label Company Code Ctry/Reg VAT Registration view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.technicalName ICOCDCTRYVATREGN view
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey VATRegistrationCountry view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY VATRegistrationCountry Country
VATRegistration VATRegistration
CompanyCodeName CompanyCodeName
AddressID AddressID
_CompanyCode _CompanyCode
_Country _Country
bukrsasCompanyCode
KEY VATRegistrationCountry t001n land1
VATRegistration t001n stceg
CompanyCodeName t001n butxt
AddressID t001n adrnr
_CompanyCode _CompanyCode
_Country _Country
_Address _Address 
@EndUserText.label: 'Company Code Ctry/Reg VAT Registration'
@AccessControl.authorizationCheck: #MANDATORY
@VDM: { viewType: #BASIC, lifecycle.contract.type: #PUBLIC_LOCAL_API }
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@Analytics: { technicalName: 'ICOCDCTRYVATREGN', internalName:#LOCAL, dataCategory: #DIMENSION }
@ObjectModel: {
  usageType: { serviceQuality: #B, sizeCategory: #S, dataClass: #MASTER },
  representativeKey: 'VATRegistrationCountry',
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
}
@AccessControl.privilegedAssociations: ['_Address']

define view entity I_CoCodeCountryVATRegistration
  as select from I_CompanyCode
  association [1..1] to I_CompanyCode             as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_Country                 as _Country     on $projection.VATRegistrationCountry = _Country.Country
  association [0..1] to I_OrgAddressDefaultRprstn as _Address     on $projection.AddressID = _Address.AddressID
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      
  key Country as VATRegistrationCountry,
      
      VATRegistration,
      @Semantics.text: true
      CompanyCodeName,
      @ObjectModel.foreignKey.association: '_Address'
      AddressID,
      
      _CompanyCode,
      _Country,
      _Address
}
union all select from t001n
association [1..1] to I_CompanyCode             as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_Country                 as _Country     on $projection.VATRegistrationCountry = _Country.Country
association [0..1] to I_OrgAddressDefaultRprstn as _Address     on $projection.AddressID = _Address.AddressID
{

  key t001n.bukrs as CompanyCode,

  key t001n.land1 as VATRegistrationCountry,

      t001n.stceg as VATRegistration,

      t001n.butxt as CompanyCodeName,

      t001n.adrnr as AddressID,
      
      _CompanyCode,
      _Country,
      _Address
} where ( t001n.land1 <> _CompanyCode.Country )

Learn More