SAP ABAP Table V_EKKONA (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | V_EKKONA |
|
| Short Description | Generated Table for View |
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 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | ||
| 3 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
| 4 | |
EBSTYP | EBSTYP | CHAR | 1 | 0 | Purchasing Document Category | ||
| 5 | |
ESART | BSART | CHAR | 4 | 0 | Purchasing Document Type | T161 | |
| 6 | |
BSAKZ | BSAKZ | CHAR | 1 | 0 | Control indicator for purchasing document type | ||
| 7 | |
ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
| 8 | |
ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
| 9 | |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 10 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
| 11 | |
BKGRP | EKGRP | CHAR | 3 | 0 | Purchasing Group | T024 | |
| 12 | |
EBDAT | DATUM | DATS | 8 | 0 | Purchasing Document Date | ||
| 13 | |
AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ||
| 14 | |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
| 15 | |
RESWK | WERKS | CHAR | 4 | 0 | Supplying (issuing) plant in case of stock transport order | T001W | |
| 16 | |
SNA_KAPPL | CHAR2 | CHAR | 2 | 0 | Application for message conditions | ||
| 17 | |
NA_OBJKEY | NA_OBJKEY | CHAR | 30 | 0 | Object key | ||
| 18 | |
SNA_KSCHL | CHAR4 | CHAR | 4 | 0 | Message type | ||
| 19 | |
NA_SPRAS | SPRAS | LANG | 1 | 0 | Message language | T002 | |
| 20 | |
NA_PARNR | NA_PARNR | CHAR | 10 | 0 | Message partner | ||
| 21 | |
SNA_PARVW | CHAR2 | CHAR | 2 | 0 | Partner function (for example SH for ship-to party) | ||
| 22 | |
NA_ERDAT | DATUM | DATS | 8 | 0 | Date on which status record was created | ||
| 23 | |
NA_ERUHR | UZEIT | TIMS | 6 | 0 | Time at which status record was created | ||
| 24 | |
AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ||
| 25 | |
NA_NACHA | NA_NACHA | CHAR | 1 | 0 | Message transmission medium | ||
| 26 | |
NA_ANZAL | DEC2 | DEC | 2 | 0 | Number of messages (original + copies) | ||
| 27 | |
NA_VSZTP | NA_VSZTP | CHAR | 1 | 0 | Dispatch time | ||
| 28 | |
NA_VSDAT | DATUM | DATS | 8 | 0 | Requested date for sending message | ||
| 29 | |
NA_VSURA | UZEIT | TIMS | 6 | 0 | Requested time for sending message (from) | ||
| 30 | |
NA_VSURB | UZEIT | TIMS | 6 | 0 | Requested time for sending message (to) | ||
| 31 | |
NA_MANUE | NA_MANUE | CHAR | 1 | 0 | Message processed manually | ||
| 32 | |
NA_DATVR | DATUM | DATS | 8 | 0 | Processing date | ||
| 33 | |
NA_UHRVR | UZEIT | TIMS | 6 | 0 | Processing time | ||
| 34 | |
NA_DATRE | DATUM | DATS | 8 | 0 | Date of the expected response to a message | ||
| 35 | |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | ||
| 36 | |
NA_VSTAT | NA_VSTAT | CHAR | 1 | 0 | Processing status of message | ||
| 37 | |
NA_AKTIV | CHAR1 | CHAR | 1 | 0 | Active | ||
| 38 | |
CSTRATEGY | CSTRATEGY | CHAR | 4 | 0 | Communication strategy | TCSTR | |
| 39 | |
RSPOPNAME | RSPOPNAME | CHAR | 4 | 0 | Spool: Output device | TSP03 | |
| 40 | |
RSPO0NAME | CHAR6 | CHAR | 6 | 0 | Spool request: Name | ||
| 41 | |
RSPO1NAME | CHAR4 | CHAR | 4 | 0 | Spool request: Suffix 1 | ||
| 42 | |
RSPO2NAME | CHAR12 | CHAR | 12 | 0 | Spool request: Suffix 2 | ||
| 43 | |
TDIMMED | TDBOOL | CHAR | 1 | 0 | Print immediately | ||
| 44 | |
TDDELETE | TDBOOL | CHAR | 1 | 0 | Release after output | ||
| 45 | |
NA_TELFX | TEXT31 | CHAR | 31 | 0 | Fax number | ||
| 46 | |
TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
| 47 | |
TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
| 48 | |
NA_AENDE | NA_AENDE | CHAR | 1 | 0 | Change message flag | ||
| 49 | |
NA_REPET | NA_REPET | CHAR | 1 | 0 | Repeatability of message | ||
| 50 | |
NA_OBS008 | CHAR8 | CHAR | 8 | 0 | Unused field | ||
| 51 | |
NA_OBS030 | CHAR30 | CHAR | 30 | 0 | Unused field | ||
| 52 | |
NA_OBS030 | CHAR30 | CHAR | 30 | 0 | Unused field | ||
| 53 | |
NA_OBS030 | CHAR30 | CHAR | 30 | 0 | Unused field | ||
| 54 | |
NA_TDFORM | CHAR30 | CHAR | 30 | 0 | WFMC: SAPscript form in 30-character field | ||
| 55 | |
NA_LABEL | FUNCNAME | CHAR | 30 | 0 | WFMC: Function module for print formatting | TFDIR | |
| 56 | |
NA_OBS003 | CHAR03 | CHAR | 3 | 0 | Unused field | ||
| 57 | |
NA_OBS003 | CHAR03 | CHAR | 3 | 0 | Unused field | ||
| 58 | |
NA_OBS003 | CHAR03 | CHAR | 3 | 0 | Unused field | ||
| 59 | |
NA_OBS003 | CHAR03 | CHAR | 3 | 0 | Unused field | ||
| 60 | |
NA_OBS003 | CHAR03 | CHAR | 3 | 0 | Unused field | ||
| 61 | |
NA_OBJKY_L | NA_OBJKY_L | CHAR | 70 | 0 | Object key (long) | ||
| 62 | |
TDID | TDID | CHAR | 4 | 0 | Text ID | TTXID | |
| 63 | |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 64 | |
NA_DUNNING_DATE | CHAR8 | CHAR | 8 | 0 | Dunning Date (Used in Retail) | ||
| 65 | |
NA_DUNNING_TIME | CHAR6 | CHAR | 6 | 0 | Dunning Time (Used in Retail) | ||
| 66 | |
SO_SND_DR | SO_FLAG | CHAR | 1 | 0 | Send: As disregard | ||
| 67 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 68 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 69 | |
AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
| 70 | |
BCS_RQST | BCS_RQST | CHAR | 1 | 0 | Requested Status | ||
| 71 | |
BCS_STML | BCS_STML | CHAR | 1 | 0 | Setting for Which Statuses Are Reported by Mail | ||
| 72 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 73 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 74 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 75 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 76 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 77 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 78 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 79 | |
NA_OBS001 | CHAR1 | CHAR | 1 | 0 | Unused field | ||
| 80 | |
NA_NAUTO | XFELD | CHAR | 1 | 0 | Message determined via conditions | ||
| 81 | |
SYPRREC | SYCHAR12 | CHAR | 12 | 0 | Spool Recipient Name | ||
| 82 | |
SYPRABT | SYCHAR12K | CHAR | 12 | 0 | Spool Department Name | ||
| 83 | |
SYPRSAP | SYPRSAP | CHAR | 1 | 0 | Print SAP Cover Page | ||
| 84 | |
SYPRTXT | SYCHAR68K | CHAR | 68 | 0 | Spool Description | ||
| 85 | |
SYPRBER | SYCHAR12 | CHAR | 12 | 0 | Print: Authorization | ||
| 86 | |
SYARMOD | SYARMOD | CHAR | 1 | 0 | Print Archive Mode | ||
| 87 | |
NA_OPTAR | NA_OPTAR | NUMC | 10 | 0 | Archive number for optical archives | ||
| 88 | |
NA_CMF_NR | NUMC12 | NUMC | 12 | 0 | Error management number | ||
| 89 | |
NA_PERS_12 | CHAR12 | CHAR | 12 | 0 | WFMC: Address number, 12 characters | ||
| 90 | |
SWO_EVENT | SWC_ELEM | CHAR | 32 | 0 | Event | ||
| 91 | |
NAST_SORTK | CHAR20 | CHAR | 20 | 0 | Sort criteria for message status records | ||
| 92 | |
NAST_SORTK | CHAR20 | CHAR | 20 | 0 | Sort criteria for message status records | ||
| 93 | |
NAST_SORTK | CHAR20 | CHAR | 20 | 0 | Sort criteria for message status records | ||
| 94 | |
OJ_NAME | OJ_NAME | CHAR | 10 | 0 | Object type | TOJTB | |
| 95 | |
SKSCHEDULE | SKSCHEDULE | CHAR | 3 | 0 | Send time request | ||
| 96 | |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | V_EKKONA | BSART | |
|
REF | 1 | N |
| 2 | V_EKKONA | BUKRS | |
|
REF | 1 | N |
| 3 | V_EKKONA | EKGRP | |
|
REF | 1 | N |
| 4 | V_EKKONA | EKORG | |
|
REF | 1 | N |
| 5 | V_EKKONA | EKSPRAS | |
|
REF | 1 | N |
| 6 | V_EKKONA | KUNNR | |
|
REF | 1 | N |
| 7 | V_EKKONA | LDEST | |
|
REF | C | CN |
| 8 | V_EKKONA | LIFNR | |
|
REF | 1 | N |
| 9 | V_EKKONA | MANDT | |
|
KEY | 1 | N |
| 10 | V_EKKONA | OBJTYPE | |
|
|||
| 11 | V_EKKONA | PFLD5 | |
|
|||
| 12 | V_EKKONA | RESWK | |
|
REF | 1 | N |
| 13 | V_EKKONA | SPRAS | |
|
KEY | 1 | CN |
| 14 | V_EKKONA | TCODE | |
|
|||
| 15 | V_EKKONA | TDID | |
|
|||
| 16 | V_EKKONA | TDSPRAS | |
|
REF | 1 | CN |
| 17 | V_EKKONA | TLAND | |
|
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |