FAC_DART_Z3_COMPANYCODE

@AbapCatalog.sqlViewName: 'FAC_DZCOCODE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.buffering.status: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Company Code Master Data'

define view FAC_DART_Z3_COMPANYCODE
  as select from           I_CompanyCode
    left outer to one join t001        as _CompanyCode on _CompanyCode.bukrs = I_CompanyCode.CompanyCode
    left outer to one join txw_c_bukrs as _setting     on _setting.bukrs = I_CompanyCode.CompanyCode
{
  key CompanyCode,
      Company,
      _CompanyCode.bukrs_glob       as GlobalCoCodeName,
      CompanyCodeName,
      ChartOfAccounts,
      _CompanyCode.xprod            as IndProdcutiveCoCode,
      Currency,
      AddressID,
//      to deleted

      _Address.BusinessPartnerName1,
      _Address.StreetName,
      _Address.HouseNumber,
      CityName,
      _Address.District,
      _Address.Region,
      Country,
      _Address.PostalCode,
      _Address.POBox,
      _Address.POBoxPostalCode,
      _CompanyCode.txjcd            as TaxJurisdiction,
      FiscalYearVariant,
      VATRegistration,
      TaxableEntity,
      CountryChartOfAccounts,
      _Address.BusinessPartnerName2,
      _CompanyCode.xjvaa            as IndJVAActive,
      _CompanyCode.txkrs            as ForeignCurrencyTranslation,
      DocDateIsUsedForTaxDetn,
      _CompanyCode.mwskv            as NonTaxableTransactionsTaxCodeI,
      NonTaxableTransactionTaxCode  as NonTaxableTransactionTaxCodeO,
      _CompanyCode.impda            as ImportDataCtrlinMMPO,
      _CompanyCode.xnegp            as IndNegativePostings,
      _CompanyCode.xkkbi            as IndCreditCtrlAreaOverwritten,
      ExtendedWhldgTaxIsActive,
      _CompanyCode.xcos             as CostofSalesAccountingStatus,
      _CompanyCode.dtaxr            as DeferredTaxRule,
      TaxRptgDateIsActive,
      _Address.HouseNumberSupplementText,
      case
      when _setting.data_volume is null
        then case Country
          when 'DE' then 'DE'
          when 'US' then 'US'
          else 'US' end
      else _setting.data_volume end as data_volume,
      
      @EndUserText.label: 'System Client'
      _CompanyCode.mandt as SystemClient,
      _CompanyCode.impda as ForeignTrade
     
      

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_COMPANYCODE",
"T001",
"TXW_C_BUKRS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/