SAP ABAP View DEBI (Cust.master record matchcode object)
Basic Data
View Type | ||
DEBI | ||
Short Description | Cust.master record matchcode object | |
Root table | KNA1 | General Data in Customer Master |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | KNA1 | KNA1 | ||
2 | KNVV | KNA1 | KUNNR | I |
3 | KNB1 | KNA1 | KUNNR | I |
4 | KNBK | KNA1 | KUNNR | I |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | KNA1 | MANDT | MANDT | Client | |||
2 | KUNNR | KNA1 | KUNNR | KUNNR | Customer Number | |||
3 | VKORG | KNVV | VKORG | VKORG | Sales Organization | |||
4 | VTWEG | KNVV | VTWEG | VTWEG | Distribution Channel | |||
5 | SPART | KNVV | SPART | SPART | Division | |||
6 | BUKRS | KNB1 | BUKRS | BUKRS | Company Code | |||
7 | BANKS | KNBK | BANKS | BANKS | Bank country key | |||
8 | BANKL | KNBK | BANKL | BANKK | Bank Keys | |||
9 | BANKN | KNBK | BANKN | BANKN | Bank account number | |||
10 | LAND1 | KNA1 | LAND1 | LAND1_GP | Country Key | |||
11 | PSTLZ | KNA1 | PSTLZ | PSTLZ | Postal Code | |||
12 | ORT01 | KNA1 | ORT01 | ORT01_GP | City | |||
13 | SPRAS | KNA1 | STRAS | STRAS_GP | House number and street | |||
14 | NAME1 | KNA1 | NAME1 | NAME1_GP | Name 1 | |||
15 | NAME2 | KNA1 | NAME2 | NAME2_GP | Name 2 | |||
16 | SORTL | KNA1 | SORTL | SORTL | Sort field | |||
17 | KNRZE | KNB1 | KNRZE | KNRZE | Head office account number (in branch accounts) | |||
18 | VKGRP | KNVV | VKGRP | VKGRP | Sales group | |||
19 | VKBUR | KNVV | VKBUR | VKBUR | Sales office | |||
20 | DATLT | KNA1 | DATLT | DATLT | Data communication line no. | |||
21 | PFACH | KNA1 | PFACH | PFACH | PO Box | |||
22 | TELBX | KNA1 | TELBX | TELBX | Telebox number | |||
23 | TELF1 | KNA1 | TELF1 | TELF1 | First telephone number | |||
24 | TELF2 | KNA1 | TELF2 | TELF2 | Second telephone number | |||
25 | TELFX | KNA1 | TELFX | TELFX | Fax Number | |||
26 | TELTX | KNA1 | TELTX | TELTX | Teletex number | |||
27 | TELX1 | KNA1 | TELX1 | TELX1 | Telex number | |||
28 | STCEG | KNA1 | STCEG | STCEG | VAT Registration Number | |||
29 | REGIO | KNA1 | REGIO | REGIO | Region (State, Province, County) | |||
30 | COUNC | KNA1 | COUNC | COUNC | County Code | |||
31 | CITYC | KNA1 | CITYC | CITYC | City Code | |||
32 | STCD1 | KNA1 | STCD1 | STCD1 | Tax Number 1 | |||
33 | STCD2 | KNA1 | STCD2 | STCD2 | Tax Number 2 | |||
34 | ALTKN | KNB1 | ALTKN | ALTKN | Previous Master Record Number | |||
35 | STRAS | KNA1 | STRAS | STRAS_GP | House number and street | |||
36 | BKREF | KNBK | BKREF | BKREF | Reference specifications for bank details | |||
37 | KTOKD | KNA1 | KTOKD | KTOKD | Customer Account Group | |||
38 | MCOD1 | KNA1 | MCOD1 | MCDD1 | Search term for matchcode search | |||
39 | MCOD2 | KNA1 | MCOD2 | MCDD2 | Search Term for Matchcode Search | |||
40 | MCOD3 | KNA1 | MCOD3 | MCDD3 | Search term for matchcode search | |||
41 | PSTL2 | KNA1 | PSTL2 | PSTL2 | P.O. Box Postal Code | |||
42 | BBBNR | KNA1 | BBBNR | BBBNR | International location number (part 1) | |||
43 | BBSNR | KNA1 | BBSNR | BBSNR | International location number (Part 2) | |||
44 | KONZS | KNA1 | KONZS | KONZS | Group key | |||
45 | VBUND | KNA1 | VBUND | RASSC | Company ID of trading partner | |||
46 | WERKS | KNA1 | WERKS | WERKS_D | Plant | |||
47 | PERNR | KNB1 | PERNR | PERNR_D | Personnel Number | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 19960410 |
SAP Release Created in |