_COMPANYCODE

41 Fields

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

Fields (41)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode,CompanyCodeForEdit,TR_ElectronicDocCompanyCode 17
KEY ControllingArea ControllingArea 75
KEY Currency CompanyCodeCurrency,CompanyCurrency,Currency,LocalCurrency 126
KEY DebtCollectionsCompanyCode DebtCollectionsCompanyCode 2
KEY FinancialManagementArea FinancialManagementArea 21
_ControllingArea _ControllingArea 11
_Country _CompanyCodeCountry,_Country 8
_CountryChartOfAccounts _CountryChartOfAccounts 1
_Currency _Currency 17
_Text _CompanyCodeText 2
AddressID AddressID,CompanyAddressID,CompanyCodeAddressID 11
bukrs CompanyCode 1
bukrs_glob GlobalCoCodeName 1
butxt CompanyCodeDesc,CompanyCodeName 2
ChartOfAccounts ChartOfAccounts 35
CityName CityName 7
Company Company 2
CompanyCodeName CAPaymentCompanyCodeName,CmmdtyHdgPlnExpsrCoCodeText,CompanyCode_T,CompanyCodeDescription,CompanyCodeName,CompanyName,MAIN_ORG_CC,RequestingCompanyCodeName 676
ControllingAreaName ControllingAreaName 1
Country CompanyCodeCountry,Country,CountryCode,CountryKey 87
CountryChartOfAccounts CountryChartOfAccounts 10
CreditControlArea CreditControlArea 2
dtaxr DeferredTaxRule 1
ExtendedWhldgTaxIsActive ExtendedWhldgTaxIsActive 3
FieldStatusVariant FieldStatusVariant 2
FiscalYearVariant FiscalYearVariant 20
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,
    DEBTCOLLECTIONSCOMPANYCODE,
    FINANCIALMANAGEMENTAREA,
    _CONTROLLINGAREA,
    _COUNTRY,
    _COUNTRYCHARTOFACCOUNTS,
    _CURRENCY,
    _TEXT,
    ADDRESSID,
    BUKRS,
    BUKRS_GLOB,
    BUTXT,
    CHARTOFACCOUNTS,
    CITYNAME,
    COMPANY,
    COMPANYCODENAME,
    CONTROLLINGAREANAME,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREDITCONTROLAREA,
    DTAXR,
    EXTENDEDWHLDGTAXISACTIVE,
    FIELDSTATUSVARIANT,
    FISCALYEARVARIANT,
    IMPDA,
    LANGUAGE,
    MANDT,
    MWSKV,
    NUMBEROFCOMPANYCODES,
    PROCUREMENTHUBSOURCESYSTEMNAME,
    TAXABLEENTITY,
    TXJCD,
    TXKRS,
    VATREGISTRATION,
    XCOS,
    XJVAA,
    XKKBI,
    XNEGP,
    XPROD,
    PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, CURRENCY, DEBTCOLLECTIONSCOMPANYCODE, FINANCIALMANAGEMENTAREA)
);

Learn More