ADRCOUNTY

Transparent Table Customizing Table
4 Fields 3 CDS Views

County codes

ADRCOUNTY is an SAP database table in S/4HANA. County codes. It contains 4 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPCountyValueHelpTmp view from BASIC County Code
I_CountyCode view from BASIC County Code
I_SecondaryRegion view from BASIC Secondary Region

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY country land1 Country/Reg.
KEY region regio Region
KEY county_code cnty_code County code

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.

-- County codes
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRCOUNTY (
    CLIENT,       -- Client [mandt]
    COUNTRY,      -- Country/Reg. [land1]
    REGION,       -- Region [regio]
    COUNTY_CODE,  -- County code [cnty_code]
    PRIMARY KEY (CLIENT, COUNTRY, REGION, COUNTY_CODE)
);

Learn More