T005T

Transparent Table Customizing Table
8 Fields 30 CDS Views

Country Names

T005T is an SAP database table in S/4HANA. Country Names. It contains 8 fields. 30 CDS views read from this table.

CDS Views using this table (30)

ViewTypeJoinVDMDescription
ESH_N_LAND1_3_LAND1 view from Country/Region key
ESH_N_LAND1_LAND1 view from Country/Region key
fac_ad_cds_t005 view left_outer Search Help CDS View for T005
FAC_AD_CDS_T007a view left_outer Search Help CDS View for T007A
FCCX_V_TASKMODEL_CA view_entity left_outer Task Model Country Assignment
Fclm_Bm_Related_Branches view left_outer Bank data for related branches
Fdt_Test_Country_Text view from Country/Region Text
fisvd_glacct_cnty view left_outer Master Data GLAccount Countries/Regions
I_CountryText view from BASIC Country/Region - Text
I_ExciseTaxCountryText view from BASIC Excise Tax Country/Region - Text
I_FrcElmntOrgCntryText view from BASIC Interface View for Ctry/Reg Text FE Org
I_HCMNationalityText view_entity from BASIC Nationality - Text
I_HK_HCMIssueCountryText view_entity from BASIC Issue Country Text
I_InsurClmLtgtnItmCntryText view_entity from BASIC InsurClm Litigation Item Country - Txt
I_JP_CentralBankRptCountryName view from BASIC SCBR - Country/Region Names
I_PaymentSystemValueHelp view_entity inner BASIC Value help for Payment systems
I_PaytSystToAliasTypeValueHelp view_entity inner BASIC VH for the Alias types in Payment system
I_TravelExpenseCountryText view from BASIC Travel Expn Country IATALocation - Text
P_HCMNationalityTextDuplicate view_entity from
PiqCds_StudentData view left_outer Student Data CDS VIew
SADL_GwVAunitCountryCodeText view from Texts for Country Code
SADL_V_EXP_Country_Text view from Country Text
SEPM_I_CountryText view from EPM Demo: Country Texts
VFCLM_BAM_DDL_ACCOUNTINAPPROC2 view left_outer Second view for Account in Request
VFCLM_BAM_DDL_AMD_WTTHDESP view left_outer
VFCLM_BAM_DDL_AMD_WTTHDESP2 view left_outer Bank Account Master Data with Description (no parameter)
VFCLM_BAM_DDL_BANK_WITHDESP view left_outer
VFCLM_BAM_DDL_BPHIERCORE view left_outer BAM BP based Hierarchy Core
VFCLM_BAM_DDL_HIERNODEATTR view left_outer Attribute Set for BAM Hierarchy Node
VFCLM_BKANT_SYNC_STATUS view left_outer CDS View for bank account with status and date

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY land1 LAND1 Country/Reg.
landx LANDX Country/Region
natio NATIO Nationality
landx50 LANDX50 Country/Region
natio50 NATIO50 Nationality
prq_spregt PRQ_SPREGT Super Region

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.

-- Country Names
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T005T (
    MANDT,       -- Client [MANDT]
    SPRAS,       -- Language [SPRAS]
    LAND1,       -- Country/Reg. [LAND1]
    LANDX,       -- Country/Region [LANDX]
    NATIO,       -- Nationality [NATIO]
    LANDX50,     -- Country/Region [LANDX50]
    NATIO50,     -- Nationality [NATIO50]
    PRQ_SPREGT,  -- Super Region [PRQ_SPREGT]
    PRIMARY KEY (MANDT, SPRAS, LAND1)
);

Learn More