T005

Transparent Table Customizing Table
20 Fields 36 CDS Views

Länder

T005 is an SAP database table in S/4HANA. Länder. It contains 20 fields. 36 CDS views read from this table.

CDS Views using this table (36)

ViewTypeJoinVDMDescription
/PF1/P_T005 view from Countries/Regions
Aps_Om_Form_Tmpl_Ctry view from Output Management: Form Template Countries
Fac_Ad_Cds_Cj_Tran view inner cds view for cash journal transaction
Fac_Ad_Cds_FOT_TXA_T030k view left_outer CDS View for FOT_TXA_T030K
fac_ad_cds_t005 view from Search Help CDS View for T005
FAC_AD_CDS_T007a view left_outer Search Help CDS View for T007A
Fac_Ad_Cds_T030k view left_outer CDS View for T030K
FAC_AUDIT_Z3_COUNTRY view from Country/Region for text
fac_audit_z3_country_master view from Country/Region Master Data
fac_cds_bseg_bkpf view left_outer Entry View BSEG/BSEG_ADD with Header
FAC_CDS_HD_FLD_DEF view union GLO field value help field definition
FCCX_V_TASKMODEL_CA view_entity inner Task Model Country Assignment
Fclm_Bm_Bank view left_outer Bank master data for management
Fdt_Test_Country view from Country/Region
Finsv_Drf_Glaccount view left_outer General Ledger Account for Data Replication
fiscds_bukcurr view left_outer Currencies of Company Code
fiscds_ldcmpcurr view left_outer Currencies of Company Code and Ledger
FISVD_USCCWITHEXTTAX view left_outer US Company Code
GCOD_LICENSECOUNTRY view cross DRC License Countries
I_Country view from BASIC Country/Region
I_ES_CountryPricingProcedure view_entity from BASIC Spain Country Pricing Procedure
I_ExciseTaxCountry view from BASIC Excise Tax Country/Region Code
I_PT_SAFTTaxNotConfigured view inner BASIC SAF-T PT get tax NS
I_RELocalTaxMap view inner BASIC Local Tax Group
I_RO_SAFTPurInvoiceTaxAmount view inner BASIC RO SAFT Purchase Invoice Tax Amount
I_RO_SAFTTaxReturnCountry view_entity from BASIC Tax Country
I_TravelExpenseCountry view from BASIC Travel Expense Country for IATALocation
P_GB_TaxCodeCustomizing view_entity inner BASIC Great Britain Tax customizing
P_Ldcmpcurr view left_outer BASIC
P_TaxCategory_All view inner BASIC
P_Taxcategoryt_All view inner BASIC
SADL_GwVAunitCountryCode view from Country Code
SADL_V_EXP_Country view from Country
SEPM_I_Country view from EPM Demo: Country
SHSM_MMIV_TAX_CODE_NO_BUK view from Selection method for VH ODATA_MMIV_TAX_CODE_NO_BUK
TDDL_API_CLI_DEP_VIEW view from

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY land1 land1 Country/Reg.
landk landk Vehicle
lnplz lnplz_005 Postal code
prplz pruef_005 Check rule for postal code
addrs addrs_005 Address layout key
xplzs xplzs_005 Postal code req
xplpf xplpf_005 PO Box pst cde
spras spras Language
xland xland_005 Version C/R
xaddr xaddr_005 Print C/R Name
nmfmt nmfmt_005 Name format
xregs xregs_005 City file act
xplst xplst_005 Street postcode
intca intca ISO Code
intca3 intca3 ISO Code 3 Char
intcn3 intcn3 ISO Code Num. 3
xegld xegld EU Country
xskfn xskfn Net Discount Base
xmwsn xmwsn Net Tax Base

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.

-- Länder
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T005 (
    MANDT,   -- Client [mandt]
    LAND1,   -- Country/Reg. [land1]
    LANDK,   -- Vehicle [landk]
    LNPLZ,   -- Postal code [lnplz_005]
    PRPLZ,   -- Check rule for postal code [pruef_005]
    ADDRS,   -- Address layout key [addrs_005]
    XPLZS,   -- Postal code req [xplzs_005]
    XPLPF,   -- PO Box pst cde [xplpf_005]
    SPRAS,   -- Language [spras]
    XLAND,   -- Version C/R [xland_005]
    XADDR,   -- Print C/R Name [xaddr_005]
    NMFMT,   -- Name format [nmfmt_005]
    XREGS,   -- City file act [xregs_005]
    XPLST,   -- Street postcode [xplst_005]
    INTCA,   -- ISO Code [intca]
    INTCA3,  -- ISO Code 3 Char [intca3]
    INTCN3,  -- ISO Code Num. 3 [intcn3]
    XEGLD,   -- EU Country [xegld]
    XSKFN,   -- Net Discount Base [xskfn]
    XMWSN,   -- Net Tax Base [xmwsn]
    PRIMARY KEY (MANDT, LAND1)
);

Learn More