SAP ABAP Table RELUC_COUNTRY_X (Land und Zusatzfelder (T005/T005T))
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷
RE-FX (Application Component) Flexible Real Estate Management
⤷
RE_MI_LU (Package) RE: Migration LUM (Data Dictionary only)
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | RELUC_COUNTRY_X |
|
| Short Description | Land und Zusatzfelder (T005/T005T) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
0 | 0 | Land (T005) | |||||
| 2 | |
0 | 0 | Countries | |||||
| 3 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 4 | |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
| 5 | |
LANDK | LANDK | CHAR | 3 | 0 | Vehicle country key | ||
| 6 | |
LNPLZ_005 | NUM02 | NUMC | 2 | 0 | Postal code length | ||
| 7 | |
PRUEF_005 | PR005 | CHAR | 1 | 0 | Rule for the postal code field check | ||
| 8 | |
ADDRS_005 | ADDRS | CHAR | 3 | 0 | Formatting routine key for printing addresses | T005A | |
| 9 | |
XPLZS_005 | XFELD | CHAR | 1 | 0 | Flag: Street address postal code required entry? | ||
| 10 | |
XPLPF_005 | XFELD | CHAR | 1 | 0 | Flag: PO Box postal code required? | ||
| 11 | |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 12 | |
XLAND_005 | XLAND_005 | CHAR | 1 | 0 | Country version flag | ||
| 13 | |
XADDR_005 | XFELD | CHAR | 1 | 0 | Flag: Print country name in foreign addresses? | ||
| 14 | |
NMFMT_005 | AD_NAMFORM | CHAR | 2 | 0 | Standard name format | T005N | |
| 15 | |
XREGS_005 | XFELD | CHAR | 1 | 0 | Flag: City file address check | ||
| 16 | |
XPLST_005 | XFELD | CHAR | 1 | 0 | Flag: Street-specific postal code? (City file) | ||
| 17 | |
INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
| 18 | |
INTCA3 | INTCA3 | CHAR | 3 | 0 | ISO country code 3 char | ||
| 19 | |
INTCN3 | NUM03 | NUMC | 3 | 0 | ISO Country Code Numeric 3-Characters | ||
| 20 | |
XEGLD | XFELD | CHAR | 1 | 0 | Indicator: European Union Member? | ||
| 21 | |
XSKFN | XFELD | CHAR | 1 | 0 | Indicator: Discount base amount is the net value | ||
| 22 | |
XMWSN | XFELD | CHAR | 1 | 0 | Indicator: Base amount for tax is net of discount ? | ||
| 23 | |
0 | 0 | Application base fields for table T005 | |||||
| 24 | |
LNBKN_005 | NUM02 | NUMC | 2 | 0 | Bank account number length | ||
| 25 | |
PRBKN_005 | PR005 | CHAR | 1 | 0 | Rule for checking bank account number field | ||
| 26 | |
LNBLZ_005 | NUM02 | NUMC | 2 | 0 | Bank number length | ||
| 27 | |
PRBLZ_005 | PR005 | CHAR | 1 | 0 | Rule for checking bank number field | ||
| 28 | |
LNPSK_005 | NUM02 | NUMC | 2 | 0 | Post office bank current account number length | ||
| 29 | |
PRPSK_005 | PR005 | CHAR | 1 | 0 | Rule for checking postal check account number field | ||
| 30 | |
XPRBK_005 | XFELD | CHAR | 1 | 0 | Indicator: Use check module for bank fields ? | ||
| 31 | |
BNKEY | BNKEY | CHAR | 1 | 0 | Name of the bank key | ||
| 32 | |
LNBKS_005 | NUM02 | NUMC | 2 | 0 | Length of Bank Key | ||
| 33 | |
PRBKS_005 | PR005 | CHAR | 1 | 0 | Rule for checking bank key field | ||
| 34 | |
XPRSO_005 | XFELD | CHAR | 1 | 0 | Indicator: Use check module for tax fields etc. ? | ||
| 35 | |
PRUIN_005 | PR005 | CHAR | 1 | 0 | Rule for checking VAT registration number field | ||
| 36 | |
UINLN | NUM02 | NUMC | 2 | 0 | VAT registration number length | ||
| 37 | |
LNST1_005 | NUM02 | NUMC | 2 | 0 | Permitted Input Length for Tax Numbre 1 | ||
| 38 | |
PRST1_005 | PR005 | CHAR | 1 | 0 | Rule for checking tax code 1 field | ||
| 39 | |
LNST2_005 | NUM02 | NUMC | 2 | 0 | Permitted Input Length for Tax Number 2 | ||
| 40 | |
PRST2_005 | PR005 | CHAR | 1 | 0 | Rule for checking tax code 2 field | ||
| 41 | |
LNST3_005 | NUM02 | NUMC | 2 | 0 | Permitted Input Length for Tax Number 3 | ||
| 42 | |
PRST3_005 | PR005 | CHAR | 1 | 0 | Rule for checking tax code 3 field | ||
| 43 | |
LNST4_005 | NUM02 | NUMC | 2 | 0 | Permitted Input Length for Tax Number 4 | ||
| 44 | |
PRST4_005 | PR005 | CHAR | 1 | 0 | Rule for checking tax code 4 field | ||
| 45 | |
LNST5_005 | NUM02 | NUMC | 2 | 0 | Permitted Input Length for Tax Number 5 | ||
| 46 | |
PRST5_005 | PR005 | CHAR | 1 | 0 | Rule for checking tax code 5 field | ||
| 47 | |
0 | 0 | ||||||
| 48 | |
0 | 0 | HR-Specific Fields in Table T005 | |||||
| 49 | |
DUSTA | DUSTA | CHAR | 3 | 0 | DUEVO: Nationality | T5D4E | |
| 50 | |
0 | 0 | Include T005, transport layer SPAY | |||||
| 51 | |
KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | T683 | |
| 52 | |
0 | 0 | Table T005 Application Fields | |||||
| 53 | |
LANDA | LANDA | CHAR | 3 | 0 | Alternative Country Key | ||
| 54 | |
WECHF | NUM03 | NUMC | 3 | 0 | Payment period for bill of exchange | ||
| 55 | |
LKVRZ | CHAR7 | CHAR | 7 | 0 | Short Name for Foreign Trade Statistics | ||
| 56 | |
INTCN | NUM03 | NUMC | 3 | 0 | Intrastat Code | ||
| 57 | |
XDEZP | XFELD | CHAR | 1 | 0 | Decimal point format | ||
| 58 | |
DATFM | DATFM | CHAR | 1 | 0 | Date Format | ||
| 59 | |
CURIN | WAERS | CUKY | 5 | 0 | Currency Key of the Index-Based Currency | TCURC | |
| 60 | |
CURHA | WAERS | CUKY | 5 | 0 | Currency key of the hard currency | TCURC | |
| 61 | |
WAERS_005 | WAERS | CUKY | 5 | 0 | Country currency | TCURC | |
| 62 | |
KURST_005 | KURST | CHAR | 4 | 0 | Exchange Rate Type for Translation into Country Currency | TCURV | |
| 63 | |
AFAPL | AFAPL | CHAR | 4 | 0 | Chart of depreciaton for asset valuation | T096 | |
| 64 | |
GWGWRT | WERT13 | CURR | 13 | 2 | Maximum low-value asset amount | ||
| 65 | |
UMRWRT | WERT13 | CURR | 13 | 2 | Net book value for changeover of depreciation method | ||
| 66 | |
KZRBWB | XFELD | CHAR | 1 | 0 | Indicator post net book value for retirement | ||
| 67 | |
XANZUM | XFELD | CHAR | 1 | 0 | Indicator transfer down payments from previous years | ||
| 68 | |
CTNCONCEPT | CTNCONCEPT | CHAR | 4 | 0 | Withholding tax certificate numbering: Concepts | WITH_CTNCOKEY | |
| 69 | |
KZSRV | XFELD | CHAR | 1 | 0 | Taxes at individual service level | ||
| 70 | |
XXINVE | XFELD | CHAR | 1 | 0 | Indicator: Display Capital Goods Indicator? | ||
| 71 | |
0 | 0 | Appendix to T005 | |||||
| 72 | |
PRQ_SUREG | PRQ_CH8 | CHAR | 8 | 0 | Super region per country | TBKS | |
| 73 | |
0 | 0 | IS-M/SD: Append Structure | |||||
| 74 | |
LANDGRP_VP | LANDGRP_VP | CHAR | 2 | 0 | Country grouping for shipping schedule | TJG94 | |
| 75 | |
RELUXSCOUNTRY | RECAXSDESCRIPTION | CHAR | 15 | 0 | Bezeichnung für ein Land | ||
| 76 | |
NATIO | TEXT15 | CHAR | 15 | 0 | Nationality |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | RELUC_COUNTRY_X | ADDRS | |
|
REF | ||
| 2 | RELUC_COUNTRY_X | AFAPL | |
|
REF | 1 | CN |
| 3 | RELUC_COUNTRY_X | CTNCONCEPT | |
|
1 | CN | |
| 4 | RELUC_COUNTRY_X | CURHA | |
|
REF | 1 | CN |
| 5 | RELUC_COUNTRY_X | CURIN | |
|
REF | 1 | CN |
| 6 | RELUC_COUNTRY_X | KALSM | |
|
REF | C | CN |
| 7 | RELUC_COUNTRY_X | KURST | |
|
|||
| 8 | RELUC_COUNTRY_X | LANDD | |
|
KEY | 1 | CN |
| 9 | RELUC_COUNTRY_X | LANDGRP_VP | |
|
|||
| 10 | RELUC_COUNTRY_X | MANDT | |
|
KEY | ||
| 11 | RELUC_COUNTRY_X | NMFMT | |
|
REF | ||
| 12 | RELUC_COUNTRY_X | SPRAS | |
|
REF | ||
| 13 | RELUC_COUNTRY_X | SUREG | |
|
REF | C | CN |
| 14 | RELUC_COUNTRY_X | WAERS | |
|
History
| Last changed by/on | SAP | 20131127 |
| SAP Release Created in | 220 |