T005

Transparent Table Customizing Table
66 Fields 45 CDS Views

Countries

T005 is an SAP database table in S/4HANA. Countries. It contains 66 fields. 45 CDS views read from this table.

CDS Views using this table (45)

ViewTypeJoinVDMDescription
/PF1/P_T005 view from Countries/Regions
Aps_Om_Form_Tmpl_Ctry view from Output Management: Form Template Countries
CUAN_Freetext_Mapping view_entity from View for freetext mapping
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
FCCX_V_TASKMODEL_CA_CHKO 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_BankCountryFieldCheck view_entity from Country Field Check
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_HCM_BkDtaFldRlvncePerCountry view_entity from BASIC Bank Data Field Relevance per Country
I_HCMNationality view_entity from BASIC Nationality
I_IN_GSTRvsChrgTaxCndnType view_entity inner BASIC GST India RCM Tax Cond Type
I_InsurClmLtgtnItemCountry view_entity from BASIC InsurClm Litigation Item Country
I_JVATaxCodeCompanyCode view_entity inner BASIC Tax Code for Company Code
I_PPS_TaxCalculationProcedure view_entity inner BASIC PPS Tax Calculation Procedure
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 (66)

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
lnbkn LNBKN_005 Bank account number
prbkn PRBKN_005 Check rule for bank acct no.
lnblz LNBLZ_005 Bank number
prblz PRBLZ_005 Check rule for bank number
lnpsk LNPSK_005 Post bank acct no.
prpsk PRPSK_005 Check rule for pst.chck acct no.
xprbk XPRBK_005 Bank data
bnkey BNKEY Bank Key
lnbks LNBKS_005 Bank Key Length
prbks PRBKS_005 Check rule for bank key
xprso XPRSO_005 Other data
pruin PRUIN_005 VAT registr.no.
uinln UINLN VAT registr.no.
lnst1 LNST1_005 Tax Number 1
prst1 PRST1_005 Check rule for tax code 1
lnst2 LNST2_005 Tax Number 2
prst2 PRST2_005 Check rule for tax code 2
lnst3 LNST3_005 Tax Number 3
prst3 PRST3_005 Check rule for tax code 3
lnst4 LNST4_005 Tax Number 4
prst4 PRST4_005 Check rule for tax code 4
lnst5 LNST5_005 Tax Number 5
prst5 PRST5_005 Check rule for tax code 5
landd DUSTA National.
kalsm KALSM_D Procedure
landa LANDA Alternative Key
wechf WECHF BoE Payment Period
lkvrz LKVRZ Short Name
intcn INTCN Intrastat Code
xdezp XDEZP Decimal Format
datfm DATFM Date Format
curin CURIN Index Cur.
curha CURHA Hard Currency
waers WAERS_005 Reporting Crcy
kurst KURST_005 Exch. Rate Type
afapl AFAPL Chart of Depr.
gwgwrt GWGWRT For Posting
umrwrt UMRWRT NBV for Change
kzrbwb KZRBWB Ind. Post NBV
xanzum XANZUM Capitalize AuC w/o downpayment
ctnconcept CTNCONCEPT WTax Cer.Num.Concept
kzsrv KZSRV Service taxes
xxinve XXINVE Capital Goods
net_gross_posting_type FINS_NET_GROSS_POSTING_TYPE Post Net or Gross
xgccv XGCCV GCC Member
sureg PRQ_SUREG 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.

-- Countries
-- 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]
    LNBKN,                   -- Bank account number [LNBKN_005]
    PRBKN,                   -- Check rule for bank acct no. [PRBKN_005]
    LNBLZ,                   -- Bank number [LNBLZ_005]
    PRBLZ,                   -- Check rule for bank number [PRBLZ_005]
    LNPSK,                   -- Post bank acct no. [LNPSK_005]
    PRPSK,                   -- Check rule for pst.chck acct no. [PRPSK_005]
    XPRBK,                   -- Bank data [XPRBK_005]
    BNKEY,                   -- Bank Key [BNKEY]
    LNBKS,                   -- Bank Key Length [LNBKS_005]
    PRBKS,                   -- Check rule for bank key [PRBKS_005]
    XPRSO,                   -- Other data [XPRSO_005]
    PRUIN,                   -- VAT registr.no. [PRUIN_005]
    UINLN,                   -- VAT registr.no. [UINLN]
    LNST1,                   -- Tax Number 1 [LNST1_005]
    PRST1,                   -- Check rule for tax code 1 [PRST1_005]
    LNST2,                   -- Tax Number 2 [LNST2_005]
    PRST2,                   -- Check rule for tax code 2 [PRST2_005]
    LNST3,                   -- Tax Number 3 [LNST3_005]
    PRST3,                   -- Check rule for tax code 3 [PRST3_005]
    LNST4,                   -- Tax Number 4 [LNST4_005]
    PRST4,                   -- Check rule for tax code 4 [PRST4_005]
    LNST5,                   -- Tax Number 5 [LNST5_005]
    PRST5,                   -- Check rule for tax code 5 [PRST5_005]
    LANDD,                   -- National. [DUSTA]
    KALSM,                   -- Procedure [KALSM_D]
    LANDA,                   -- Alternative Key [LANDA]
    WECHF,                   -- BoE Payment Period [WECHF]
    LKVRZ,                   -- Short Name [LKVRZ]
    INTCN,                   -- Intrastat Code [INTCN]
    XDEZP,                   -- Decimal Format [XDEZP]
    DATFM,                   -- Date Format [DATFM]
    CURIN,                   -- Index Cur. [CURIN]
    CURHA,                   -- Hard Currency [CURHA]
    WAERS,                   -- Reporting Crcy [WAERS_005]
    KURST,                   -- Exch. Rate Type [KURST_005]
    AFAPL,                   -- Chart of Depr. [AFAPL]
    GWGWRT,                  -- For Posting [GWGWRT]
    UMRWRT,                  -- NBV for Change [UMRWRT]
    KZRBWB,                  -- Ind. Post NBV [KZRBWB]
    XANZUM,                  -- Capitalize AuC w/o downpayment [XANZUM]
    CTNCONCEPT,              -- WTax Cer.Num.Concept [CTNCONCEPT]
    KZSRV,                   -- Service taxes [KZSRV]
    XXINVE,                  -- Capital Goods [XXINVE]
    NET_GROSS_POSTING_TYPE,  -- Post Net or Gross [FINS_NET_GROSS_POSTING_TYPE]
    XGCCV,                   -- GCC Member [XGCCV]
    SUREG,                   -- Super Region [PRQ_SUREG]
    PRIMARY KEY (MANDT, LAND1)
);

Learn More