SAP table EMBK (Legal Control: License Master - Header Data)
SAP table EMBK has 2 primary key fields being MANDT,GENNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||
| GENNR | Internal license number | CHAR | 10 | 0 | GENNR | ||||||||||||||
| INDEI | Indicator: Legal Control Import / Export | CHAR | 1 | 0 | INDEI |
|
|||||||||||||
| GEGRU | Legal Regulation for Legal Control | CHAR | 2 | 0 | T606G | GEGRU | |||||||||||||
| GEART | License type | CHAR | 4 | 0 | T606 | GEART | |||||||||||||
| EXGEN | External license number | CHAR | 20 | 0 | EXGEN | ||||||||||||||
| GENST | Status for Legal Control | CHAR | 1 | 0 | GENST |
|
|||||||||||||
| ANFDA | Application date | DATS | 8 | 0 | ANFDA | ||||||||||||||
| ANFUZ | Application time | TIMS | 6 | 0 | ANFUZ | ||||||||||||||
| ABGDA | Rejection date | DATS | 8 | 0 | ABGDA | ||||||||||||||
| ABGUZ | Time of rejection | TIMS | 6 | 0 | ABGUZ | ||||||||||||||
| EIGDA | Date of receipt | DATS | 8 | 0 | EIGDA | ||||||||||||||
| EIGUZ | Time received | TIMS | 6 | 0 | EIGUZ | ||||||||||||||
| VELDA | Renewal date | DATS | 8 | 0 | VELDA | ||||||||||||||
| VELUZ | Renewal time | TIMS | 6 | 0 | VELUZ | ||||||||||||||
| REODA | Reorganization date | DATS | 8 | 0 | REODA | ||||||||||||||
| REOUZ | Reorganization time | TIMS | 6 | 0 | REOUZ | ||||||||||||||
| GST_0 | Comment for status '_' | CHAR | 50 | 0 | GST_0 | ||||||||||||||
| GST_A | Comment for status 'A' | CHAR | 50 | 0 | GST_A | ||||||||||||||
| GST_B | Comment for status 'B' | CHAR | 50 | 0 | GST_B | ||||||||||||||
| GST_C | Comment for status 'C' | CHAR | 50 | 0 | GST_C | ||||||||||||||
| GST_D | Comment for status 'D' | CHAR | 50 | 0 | GST_D | ||||||||||||||
| GST_Z | Comment for status 'Z' | CHAR | 50 | 0 | GST_Z | ||||||||||||||
| GANDA | Validity start date | DATS | 8 | 0 | GANDA | ||||||||||||||
| GENDA | Validity end date | DATS | 8 | 0 | GENDA | ||||||||||||||
| GMAXW | Maximum license value | CURR | 15 | 2 | GMAXW | ||||||||||||||
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||||||||||
| GMAXQ | Maximum license quantity | QUAN | 13 | 3 | GMAXQ | ||||||||||||||
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |||||||||||||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||||||||||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||||||||||
| ERZET | Entry time | TIMS | 6 | 0 | ERZET | ||||||||||||||
| GENLA | Country of destination | CHAR | 3 | 0 | T005 | GENLA | |||||||||||||
| EXART | Business Transaction Type | CHAR | 2 | 0 | T605 | EXART | |||||||||||||
| GAUFW | Value consumed by orders | CURR | 15 | 2 | GAUFW | ||||||||||||||
| GLIEW | Value consumed by deliveries | CURR | 15 | 2 | GLIEW | ||||||||||||||
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||||||
| ZTERM | Terms of payment key | CHAR | 4 | 0 | DZTERM | ||||||||||||||
| GMAXA | Maximum number of orders | DEC | 4 | 0 | GMAXA | ||||||||||||||
| GAUFA | Current number of orders | DEC | 4 | 0 | GAUFA | ||||||||||||||
| GPRZW | Max. value excess in percent | NUMC | 3 | 0 | GPRZW | ||||||||||||||
| GAUFQ | Updated order quantity | QUAN | 13 | 3 | GAUFQ | ||||||||||||||
| GLIEQ | Updated delivery quantity | QUAN | 13 | 3 | GLIEQ | ||||||||||||||
| VBELN | Number of SD document assigned to license | CHAR | 10 | 0 | * | GVBLN | |||||||||||||
| VBDFG | Validity of export license for affiliated companies | CHAR | 1 | 0 | VBDFG |
|
|||||||||||||
| VBDNR | Affiliated company number | CHAR | 6 | 0 | T880 | VBDNR | |||||||||||||
| BEHO2 | Authority of exporting country | CHAR | 10 | 0 | T610O | BEHO2 | |||||||||||||
| BEHOE1 | Issuing authority from importing country | CHAR | 10 | 0 | T610O | BEHOE1 | |||||||||||||
| BEHOE2 | Issuing authority from country of dispatch | CHAR | 10 | 0 | T610O | BEHOE2 |
EMBK foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EMBK | BEHO2 | T610O | Foreign Trade: Authorities | MANDT |
| 0 EMBK | BEHO2 | T610O | Foreign Trade: Authorities | BEHOE |
| 1 EMBK | BEHOE1 | T610O | Foreign Trade: Authorities | MANDT |
| 1 EMBK | BEHOE1 | T610O | Foreign Trade: Authorities | BEHOE |
| 0 EMBK | BEHOE2 | T610O | Foreign Trade: Authorities | MANDT |
| 0 EMBK | BEHOE2 | T610O | Foreign Trade: Authorities | BEHOE |
| 1 EMBK | BUKRS | T001 | Company Codes | BUKRS |
| 0 EMBK | EXART | T605 | Business Transaction Type | LAND1 |
| 0 EMBK | EXART | T605 | Business Transaction Type | EXART |
| 1 EMBK | GEART | T606 | Legal Control: License Types | GEGRU |
| 0 EMBK | GEGRU | T606G | Legal Control: Legal Regulations | GEGRU |
| 1 EMBK | GENLA | T005 | Countries | MANDT |
| 1 EMBK | GENLA | T005 | Countries | LAND1 |
| 0 EMBK | MANDT | T000 | Clients | MANDT |
| 1 EMBK | MEINS | T006 | Units of Measurement | MANDT |
| 1 EMBK | MEINS | T006 | Units of Measurement | MSEHI |
| 0 EMBK | VBDNR | T880 | Global Company Data (for KONS Ledger) | MANDT |
| 0 EMBK | VBDNR | T880 | Global Company Data (for KONS Ledger) | RCOMP |
| 1 EMBK | WAERS | TCURC | Currency Codes | MANDT |
| 1 EMBK | WAERS | TCURC | Currency Codes | WAERS |