TBAC_MIC

Transparent Table Customizing Table
8 Fields 3 CDS Views

Customizing table for Market Identification Code

TBAC_MIC is an SAP database table in S/4HANA. Customizing table for Market Identification Code. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/dmbe/i_Pricingmic view from Market Identification Code
I_ACMMarketIdentification view from BASIC Master Data Market Identification
I_MarketIdentCode view from BASIC Market Identifier Code

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mic TBA_MIC MIC
country LAND1 Country/Reg.
location ORT01 City
mic_url TBA_MIC_URL MIC URL
mic_status TBA_MIC_STATUS Status
calendar SKALID Calendar
in_use TBA_MIC_ACTIVE MIC Can Be Used

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.

-- Customizing table for Market Identification Code
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBAC_MIC (
    CLIENT,      -- Client [MANDT]
    MIC,         -- MIC [TBA_MIC]
    COUNTRY,     -- Country/Reg. [LAND1]
    LOCATION,    -- City [ORT01]
    MIC_URL,     -- MIC URL [TBA_MIC_URL]
    MIC_STATUS,  -- Status [TBA_MIC_STATUS]
    CALENDAR,    -- Calendar [SKALID]
    IN_USE,      -- MIC Can Be Used [TBA_MIC_ACTIVE]
    PRIMARY KEY (CLIENT, MIC)
);

Learn More