I_CntrlInvcMgmtCompanyCodeDEX

DDL: I_CNTRLINVCMGMTCOMPANYCODEDEX SQL: ICIMCOCODEDEX Type: view COMPOSITE Package: CIM_INT_CONFIGURATION

Company Code for Import

I_CntrlInvcMgmtCompanyCodeDEX is a Composite CDS View that provides data about "Company Code for Import" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 13 fields with key field CompanyCode. It has 3 associations to related views. Part of development package CIM_INT_CONFIGURATION.

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_TimeZoneIANACodeMap _IANATimeZone $projection.addresstimezone = _IANATimeZone.TimeZoneID and _IANATimeZone.IANACodeIsSAPDefinedDefault = 'X'
[0..1] I_CntrlInvcMgmtTxJxStructure _TxJxProced $projection.taxcalculationprocedure = _TxJxProced.TaxJurisdictionCalcProcedure
[0..*] I_Address_2 _Address $projection.AddressID = _Address.AddressID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICIMCOCODEDEX view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Company Code for Import view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #NONE view
Analytics.dataExtraction.enabled true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
CompanyCodeName CompanyCodeName
CityName CityName
Country Country
Currency Currency
AddressID AddressID
LanguageISOCode _Language LanguageISOCode
AddressTimeZone _Address AddressTimeZone
TaxCalculationProcedure _Country TaxCalculationProcedure
_TxJxProced _TxJxProced
_IANATimeZone _IANATimeZone
_Country _Country
_Currency _Currency
@AbapCatalog.sqlViewName: 'ICIMCOCODEDEX'
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Company Code for Import'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {
  dataClass: #ORGANIZATIONAL,
  serviceQuality: #C,
  sizeCategory: #L
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE ]
@ObjectModel.modelingPattern:#NONE
@Analytics.dataExtraction.enabled:true
define view I_CntrlInvcMgmtCompanyCodeDEX
  as select from I_CompanyCode
  association [0..*] to I_TimeZoneIANACodeMap        as _IANATimeZone on  $projection.addresstimezone               = _IANATimeZone.TimeZoneID
                                                                      and _IANATimeZone.IANACodeIsSAPDefinedDefault = 'X'
  association [0..1] to I_CntrlInvcMgmtTxJxStructure as _TxJxProced   on  $projection.taxcalculationprocedure = _TxJxProced.TaxJurisdictionCalcProcedure
  association [0..*] to I_Address_2                  as _Address      on  $projection.AddressID = _Address.AddressID
{
  key CompanyCode,
      CompanyCodeName,
      CityName,
      Country,
      Currency,
      AddressID,
      _Language.LanguageISOCode,
      _Address.AddressTimeZone,
      _Country.TaxCalculationProcedure,
      _TxJxProced,
      _IANATimeZone,
      _Country,
      _Currency
}