SAP Table EUMZDKUNDE
Screen Fields for Determ. Cont. Acc./Cust. for Move-out/in
EUMZDKUNDE (Screen Fields for Determ. Cont. Acc./Cust. for Move-out/in) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EUMZDKUNDE to other SAP tables.
EUMZDKUNDE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VKONT | Contract Account Number | VKONT_KK | FKKVK | CHAR | 12 | 0 | ||||||||
| VKTYP_KK | Contract Account Category | VKTYP_KK | TFK002A | CHAR | 2 | 0 | ||||||||
| MUSTER | Reference for creating a standard customer for bus. partner | MUSTER_KUN | KNA1 | CHAR | 10 | 0 | ||||||||
| BU_TYPE | Business partner category | BU_TYPE | CHAR | 1 | 0 |
Possible values
|
||||||||
| BU_GROUP | Business Partner Grouping | BU_GROUP | TB001 | CHAR | 4 | 0 | ||||||||
| BU_XBUPP | Business partner is a natural person | BU_XBUPP | CHAR | 1 | 0 |
Possible values
|
||||||||
| BU_XBUPO | Business partner is an organization | BU_XBUPO | CHAR | 1 | 0 |
Possible values
|
||||||||
| BU_XBUPG | Business partner is a group | BU_XBUPG | CHAR | 1 | 0 |
Possible values
|
||||||||
| PARTNER | Business Partner Number | BU_PARTNER | BUT000 | CHAR | 10 | 0 | ||||||||
| PARTNERTEXT | Text (length 132) | TEXT132 | CHAR | 132 | 0 | |||||||||
| BU_NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR | 40 | 0 | |||||||||
| BU_NAME2 | Name field 2 (name2/first name) | BU_NAME2 | CHAR | 40 | 0 | |||||||||
| BU_NAMEMID | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | 0 | |||||||||
| STREET | Street | AD_STREET | CHAR | 60 | 0 | |||||||||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | 0 | |||||||||
| ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||||||||
| TELNR_LONG | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30 | 0 | |||||||||
| HOUSE_N1 | House Number | AD_HSNM1 | CHAR | 10 | 0 | |||||||||
| HOUSE_N2 | House number supplement | AD_HSNM2 | CHAR | 10 | 0 | |||||||||
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||
| POST_CO1 | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||||||||
| CITY1 | City | AD_CITY1 | CHAR | 40 | 0 | |||||||||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| BU_KIND | Business Partner Type | BU_BPKIND | TB004 | CHAR | 4 | 0 | ||||||||
| DR_LICENSE | Driver's license number | DR_LICENSE | CHAR | 20 | 0 | |||||||||
| DR_LICENSE_LAND1 | Country in which driver's license was acquired | DR_LICENSE_LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| DR_LICENSE_REGION | Region in which driver's license was acquired | DR_LICENSE_REGIO | T005S | CHAR | 3 | 0 | ||||||||
| SOC_SECU | Social Insurance Number | E_SOC_SECU | CHAR | 12 | 0 | |||||||||
EUMZDKUNDE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EUMZDKUNDE | BU_GROUP | SY | MANDT | TB001 | BP groupings | MANDT |
| EUMZDKUNDE | BU_GROUP | EUMZDKUNDE | BU_GROUP | TB001 | BP groupings | BU_GROUP |
| EUMZDKUNDE | BU_KIND | SY | MANDT | TB004 | BP types | CLIENT |
| EUMZDKUNDE | BU_KIND | EUMZDKUNDE | BU_KIND | TB004 | BP types | BPKIND |
| EUMZDKUNDE | COUNTRY | SY | MANDT | T005 | Countries | MANDT |
| EUMZDKUNDE | COUNTRY | EUMZDKUNDE | COUNTRY | T005 | Countries | LAND1 |
| EUMZDKUNDE | DR_LICENSE_LAND1 | EUMZDKUNDE | DR_LICENSE_LAND1 | T005 | Countries | LAND1 |
| EUMZDKUNDE | DR_LICENSE_LAND1 | SY | MANDT | T005 | Countries | MANDT |
| EUMZDKUNDE | DR_LICENSE_REGION | SY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| EUMZDKUNDE | DR_LICENSE_REGION | EUMZDKUNDE | DR_LICENSE_LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| EUMZDKUNDE | DR_LICENSE_REGION | EUMZDKUNDE | DR_LICENSE_REGION | T005S | Taxes: Region (Province) Key | BLAND |
| EUMZDKUNDE | MUSTER | SY | MANDT | KNA1 | General Data in Customer Master | MANDT |
| EUMZDKUNDE | MUSTER | EUMZDKUNDE | MUSTER | KNA1 | General Data in Customer Master | KUNNR |
| EUMZDKUNDE | PARTNER | SY | MANDT | BUT000 | BP: General data I | CLIENT |
| EUMZDKUNDE | PARTNER | EUMZDKUNDE | PARTNER | BUT000 | BP: General data I | PARTNER |
| EUMZDKUNDE | REGION | EUMZDKUNDE | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| EUMZDKUNDE | REGION | EUMZDKUNDE | REGION | T005S | Taxes: Region (Province) Key | BLAND |
| EUMZDKUNDE | REGION | SY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| EUMZDKUNDE | VKONT | SY | MANDT | FKKVK | Contract Account Header | MANDT |
| EUMZDKUNDE | VKONT | EUMZDKUNDE | VKONT | FKKVK | Contract Account Header | VKONT |
| EUMZDKUNDE | VKTYP_KK | SY | MANDT | TFK002A | Contract Account Categories | MANDT |
| EUMZDKUNDE | VKTYP_KK | 'R' | TFK002A | Contract Account Categories | APPLK | |
| EUMZDKUNDE | VKTYP_KK | EUMZDKUNDE | VKTYP_KK | TFK002A | Contract Account Categories | VKTYP |
