A_CompanyCode

DDL: A_COMPANYCODE SQL: AFICOMPANYCODE Type: view BASIC

API Company Code

A_CompanyCode is a Basic CDS View that provides data about "API Company Code" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 21 fields with key field CompanyCode.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode from

Annotations (12)

NameValueLevelField
EndUserText.label API Company Code view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName AFICOMPANYCODE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
CompanyCodeName CompanyCodeName
CityName CityName
Country Country
Currency Currency
Language Language
ChartOfAccounts ChartOfAccounts
FiscalYearVariant FiscalYearVariant
Company Company
CreditControlArea CreditControlArea
CountryChartOfAccounts CountryChartOfAccounts
FinancialManagementArea FinancialManagementArea
AddressID AddressID
TaxableEntity TaxableEntity
VATRegistration VATRegistration
ExtendedWhldgTaxIsActive ExtendedWhldgTaxIsActive
ControllingArea ControllingArea
FieldStatusVariant FieldStatusVariant
NonTaxableTransactionTaxCode NonTaxableTransactionTaxCode
DocDateIsUsedForTaxDetn DocDateIsUsedForTaxDetn
TaxRptgDateIsActive TaxRptgDateIsActive 
@EndUserText.label: 'API Company Code'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AbapCatalog.sqlViewName: 'AFICOMPANYCODE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

//A-view annotations

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

define view A_CompanyCode
  as select from I_CompanyCode

  //association [0..1] to I_Currency           as _Currency                on $projection.Currency                 = _Currency.Currency

  //association [0..1] to A_Country            as _Country                 on $projection.Country                  = _Country.Country

  //association [0..1] to I_Address            as _Address                 on $projection.AddressID                = _Address.AddressID

  //association [0..1] to I_Language           as _Language                on $projection.Language                 = _Language.Language

  //association [0..1] to A_ChartOfAccounts    as _ChartOfAccounts         on $projection.ChartOfAccounts          = _ChartOfAccounts.ChartOfAccounts

  //association [0..1] to I_FiscalYearVariant  as _FiscalYearVariant       on $projection.FiscalYearVariant        = _FiscalYearVariant.FiscalYearVariant

  //association [0..1] to A_ChartOfAccounts    as _CountryChartOfAccounts  on $projection.CountryChartOfAccounts   = _CountryChartOfAccounts.ChartOfAccounts

  //association [0..1] to A_ControllingArea    as _ControllingArea         on $projection.ControllingArea          = _ControllingArea.ControllingArea

  //association [0..1] to I_CreditControlArea  as _CreditControlArea       on $projection.CreditControlArea        = _CreditControlArea.CreditControlArea

  //association [0..1] to I_FieldStatusVariant as _FieldStatusVariant      on $projection.FieldStatusVariant       = _FieldStatusVariant.FieldStatusVariant

  //association [0..1] to I_Globalcompany      as _GlobalCompany           on $projection.Company                  = _GlobalCompany.Company

{
      //I_CompanyCode

  key CompanyCode,
      CompanyCodeName,
      CityName,
      Country,
      Currency,
      Language,
      ChartOfAccounts,
      FiscalYearVariant,
      Company,
      CreditControlArea,
      CountryChartOfAccounts,
      FinancialManagementArea,
      AddressID,
      TaxableEntity,
      VATRegistration,
      ExtendedWhldgTaxIsActive,
      ControllingArea,
      FieldStatusVariant,
      NonTaxableTransactionTaxCode,
      DocDateIsUsedForTaxDetn,
      TaxRptgDateIsActive
      /* Associations */
      //I_CompanyCode

      //      _Address,

      //      _ChartOfAccounts,

      //      _ControllingArea,

      //      _Country,

      //      _CountryChartOfAccounts

      //      _CreditControlArea,

      //      _Currency,

      //      _FieldStatusVariant,

      //      _FiscalYearVariant,

      //      _GlobalCompany,

      //      _Language

}

Learn More