T005

Countries | #masterdata | #language | Component: Address Management/Business Address
Column Name Description
MANDT FK Client
LAND1 Country/Region Key
Column Name Description
💲 Reporting Currency (WAERS):
GWGWRT Maximum Low-Value Asset Amount
UMRWRT Net Book Value for Changeover of Depreciation Method
Column Name Description
Column Name Description
Column Name Description
PRPLZ Rule for the postal code field check Show values
XPLZS Flag: Street address postal code required entry? Show values
XPLPF Flag: PO Box postal code required? Show values
XLAND Indicator: Country/Region Version Availability Show values
XADDR Indicator: Print Country/Region for Addresses of Other C/R Show values
XREGS Flag: City file address check Show values
XPLST Flag: Street-specific postal code? (City file) Show values
XEGLD Indicator: European Union Member? Show values
XSKFN Indicator: Discount base amount is the net value Show values
XMWSN Indicator: Base amount for tax is net of discount ? Show values
PRBKN Rule for checking bank account number field Show values
PRBLZ Rule for checking bank number field Show values
PRPSK Rule for checking postal check account number field Show values
XPRBK Indicator: Use check module for bank fields ? Show values
BNKEY Name of the bank key Show values
PRBKS Rule for checking bank key field Show values
XPRSO Indicator: Use check module for tax fields etc. ? Show values
PRUIN Rule for checking VAT registration number field Show values
PRST1 Rule for checking tax code 1 field Show values
PRST2 Rule for checking tax code 2 field Show values
PRST3 Rule for checking tax code 3 field Show values
PRST4 Rule for checking tax code 4 field Show values
PRST5 Rule for checking tax code 5 field Show values
XDEZP Decimal Point Format Show values
DATFM Date Format Show values
KZRBWB Indicator Post Net Book Value for Retirement Show values
XANZUM Indicator transfer down payments from previous years Show values
KZSRV Taxes at individual service level Show values
XXINVE Indicator: Display Capital Goods Indicator? Show values
NET_GROSS_POSTING_TYPE Calculate and Post Impairment Based on Net or Gross Amount Show values
XGCCV Indicator: GCC Member? Show values
Column Name Description Domain name
LANDK Vehicle Country/Region Key LANDK
LNPLZ Postal code length NUM02
INTCA ISO Code of the Country/Region INTCA
INTCA3 ISO Country/Region Code 3 Characters INTCA3
INTCN3 ISO Country/Region Code Numeric 3-Characters NUM03
LNBKN Bank account number length NUM02
LNBLZ Bank number length NUM02
LNPSK Post office bank current account number length NUM02
LNBKS Length of Bank Key NUM02
UINLN VAT registration number length NUM02
LNST1 Permitted Input Length for Tax Numbre 1 NUM02
LNST2 Permitted Input Length for Tax Number 2 NUM02
LNST3 Permitted Input Length for Tax Number 3 NUM02
LNST4 Permitted Input Length for Tax Number 4 NUM02
LNST5 Permitted Input Length for Tax Number 5 NUM02
LANDA Alternative Country/Region Key LANDA
WECHF Bill of Exchange Payment Period NUM03
LKVRZ Short Name for Foreign Trade Statistics CHAR7
INTCN Intrastat Code NUM03
Master Data Relations | to Other Relations ↓ Join Conditions
Formatting routine key for printing addresses
  • T005.MANDT == T005A.MANDT
  • T005.ADDRS == T005A.ADDRS
Chart of Depreciaton for Asset Valuation
  • T005.MANDT == T096.MANDT
  • T005.AFAPL == T096.AFAPL
Withholding Tax Certificate Numbering: Concepts T005.CTNCONCEPT == WITH_CTNCOKEY.CTNCONCEPT
Currency Key of the Hard Currency
  • T005.MANDT == TCURC.MANDT
  • T005.CURHA == TCURC.WAERS
Currency Key of the Index-Based Currency
  • T005.MANDT == TCURC.MANDT
  • T005.CURIN == TCURC.WAERS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • T005.MANDT == T683.MANDT
  • T005.[column in domain "KAPPL"] == T683.KAPPL
  • T005.KALSM == T683.KALSM
  • T005.[column in domain "KVEWE"] == T683.KVEWE
Exchange Rate Type for Translation into Reporting Currency
  • T005.MANDT == TCURV.MANDT
  • T005.KURST == TCURV.KURST
Client T005.MANDT == T000.MANDT
Language Key T005.SPRAS == T002.SPRAS
Super Region for Each Country/Region
  • T005.MANDT == TBKS.MANDT
  • T005.SUREG == TBKS.SUREG
Reporting Currency
  • T005.MANDT == TCURC.MANDT
  • T005.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
DUEVO: Nationality
  • ?
  • DUEVO: Nationality
  • T005.[column in domain "ENDDA"] == T5D4E.ENDDA
  • T005.LANDD == T5D4E.DUNAT
Standard name format
  • Country/Region Key
  • Standard name format
  • T005.MANDT == T005N.MANDT
  • T005.LAND1 == T005N.LAND1
  • T005.NMFMT == T005N.NAMEFORMAT