_COMPANYCODE

39 Fields

_COMPANYCODE is an SAP database table in S/4HANA. It contains 39 fields.

Fields (39)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode,CompanyCodeForEdit 15
KEY ControllingArea ControllingArea 75
KEY Currency CompanyCodeCurrency,CompanyCurrency,CountryCurrency,Currency,LocalCurrency,PRAChkInptCalcCurrency,PRAChkInptControlCurrency 144
_Address _Address 1
_ControllingArea _ControllingArea 10
_Country _CompanyCodeCountry,_Country 8
_Currency _Currency 18
_FiscalYearVariant _CompanyCodeFiscalYearVariant 3
AddressID AddressID,CompanyAddressID,CompanyCodeAddressID 11
bukrs CompanyCode 1
bukrs_glob GlobalCoCodeName 1
butxt CompanyCodeDesc 1
ChartOfAccounts ChartOfAccounts 30
CityName CityName 7
Company Company,CompanyCodePartnerCompany 3
CompanyCodeName CAPaymentCompanyCodeName,CmmdtyHdgPlnExpsrCoCodeText,CompanyCode_T,CompanyCodeName,CompanyName,internalCompanyDescr,MAIN_ORG_CC,RequestingCompanyCodeName 715
Country CompanyCodeCountry,Country,CountryCode,CountryKey 77
CountryChartOfAccounts CountryChartOfAccounts 9
CreditControlArea CreditControlArea 2
dtaxr DeferredTaxRule 1
ExtendedWhldgTaxIsActive ExtendedWhldgTaxIsActive 3
FieldStatusVariant FieldStatusVariant 3
FinancialManagementArea FinancialManagementArea 27
FiscalYearVariant FiscalYearVariant 19
impda ForeignTrade,ImportDataCtrlinMMPO 1
Language Language 3
mandt SystemClient 1
mwskv NonTaxableTransactionsTaxCodeI 1
NumberOfCompanyCodes NumberOfCompanyCodes 1
ProcurementHubSourceSystemName ProcurementHubSourceSystemName 1
TaxableEntity TaxableEntity 1
txjcd TaxJurisdiction 1
txkrs ForeignCurrencyTranslation 1
VATRegistration CompanyVATRegistration,VATRegistration 3
xcos CostofSalesAccountingStatus 1
xjvaa IndJVAActive 1
xkkbi IndCreditCtrlAreaOverwritten 1
xnegp IndNegativePostings 1
xprod IndProdcutiveCoCode 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _COMPANYCODE (
    COMPANYCODE,
    CONTROLLINGAREA,
    CURRENCY,
    _ADDRESS,
    _CONTROLLINGAREA,
    _COUNTRY,
    _CURRENCY,
    _FISCALYEARVARIANT,
    ADDRESSID,
    BUKRS,
    BUKRS_GLOB,
    BUTXT,
    CHARTOFACCOUNTS,
    CITYNAME,
    COMPANY,
    COMPANYCODENAME,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREDITCONTROLAREA,
    DTAXR,
    EXTENDEDWHLDGTAXISACTIVE,
    FIELDSTATUSVARIANT,
    FINANCIALMANAGEMENTAREA,
    FISCALYEARVARIANT,
    IMPDA,
    LANGUAGE,
    MANDT,
    MWSKV,
    NUMBEROFCOMPANYCODES,
    PROCUREMENTHUBSOURCESYSTEMNAME,
    TAXABLEENTITY,
    TXJCD,
    TXKRS,
    VATREGISTRATION,
    XCOS,
    XJVAA,
    XKKBI,
    XNEGP,
    XPROD,
    PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, CURRENCY)
);

Learn More