Additional queries
The existing query MD_CC_365 has been extended by the field VAT Registration Number (STCEG).
The query MD_VENDOR_365, which also exists, now contains the additional fields E-Mail and URL.
For xSuite Orders Cube the following queries have been added:
Query name | Title | InfoSet |
|---|---|---|
MD_ORDERS_KST | Orders customer master | /WMD/MD_ORDERS_KST |
MD_ORDERS_MST | Orders material master | /WMD/MD_ORDERS_MATST |
The following fields are available in the queries:
MD_ORDERS_KST
Field | Technical name |
|---|---|
Customer Number 1 | KNVV-KUNNR |
Sales Organization | KNVV-VKORGPSTL |
Distribution Channel | KNVV-VTWEG |
Division | KNVV-SPART |
Name 1 to Name 3 | KNA1-NAME1 to KNA1-NAME3 |
House number and street | KNA1-STRAS |
Postal Code | KNA1-PSTLZ |
City | KNA1-ORT01 |
PO Box | KNA1-PFACH |
PO Box city | KNA1-PFORT |
Country Key | KNA1-LAND1 |
Region (State, Province, County) | KNA1-REGIO |
First telephone number | KNA1-TELF1 |
Second telephone number | KNA1-TELF2 |
VAT Registration Number | KNA1-STCEG |
Tax Number 2 | KNA1-STCD2 |
Tax Number 1 | KNA1-STCD1 |
VAT Registration Number | KNAS-STCEG |
E-Mail Address Seach Field | ADR6-SMTP_SRCH |
URI address search field | ADR12-URI_SRCH |
MD_ORDERS_MST
Field | Technical name |
|---|---|
Material Number | MVKE-MATNR |
Sales Organization | MVKE-VKORG |
Distribution Channel | MVKE-VTWEG |
Old material number | MARA-BISMT |
International Article Number (EAN/UPC) | MARA-EAN11 |
Customer number | KNMT-KUNNR |
Material Number Used by Customer | KNMT-KDMAT |
Customer description of material | KNMT-POSTX |
Material description in upper case for matchcodes | MAKT-MAKTG |