Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
VKORG | Sales organization | string ( 4 ) | Yes | The parameter setting is located in the "Service for receiving sales organizations of the client." Example of filling VKORG=4000 |
KUNNR_RG | Buyer | string ( 10 ) | Yes | Available values are returned to the "Client Structure Retrieval Service". Table RG_TAB-KUNNR Example of filling KUNNR_RG=00000000 |
SCRDATE | Creation date From | string ( 10 ) | No | Creation date From (if the parameter is not filled in, the current date is set) Date format YYYYMMDD Filling example SCRDATE=20170105 |
ECRDATE | Software creation date | string ( 10 ) | No | Software creation date (if the parameter is not filled in, the current date is set) Date format YYYYMMDD Filling example ECRDATE=20170105 |
SDLDATE | Delivery of goods C | string ( 10 ) | No | Delivery of goods From Date format YYYYMMDD Filling example SDLDATE=20170105 |
EDLDATE | Delivery of software goods | string ( 10 ) | No | If you need to receive only rejected order items, then set this parameter = 1 |
KURR_LOGIN | Current login | 0,1,or empty string ( 1 ) | No | Orders are filtered by current login |
general description of the answer
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
DATA | Search results table | array ( - ) | No | |
INF | Summary information on received data | array ( - ) | No |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
ORDER | Order number | string ( 10 ) | No | Order number |
ORDER_TYPE | Order type | string ( 100 ) | No | The order type depends on the location of shipment (marked in different colors in the ETP), takes the following values: Shipment from MAIN warehouses Delivery from NEAR warehouses Delivery from FAR warehouses Delivery from central locker |
ORDER_DATE | Order date | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
ORDER_STATUS | Order status | string ( 100 ) | No | Order status can take the following values (icon next to the number in the ETP): Created In progress Closed Rejected |
ORDER_SUM | Order amount | string ( 20 ) | No | Order amount. Important! Applies ONLY to the Order, if the Order was delivered in parts (see Delivery), then the report will have more than the 1st line with this Order Number and in each line the value “Order Amount” will be the same (same as in the ETP) |
CURRENCY | Currency | string ( 4 ) | No | |
DELIVERY | Delivery | string ( 10 ) | No | Delivery number. Important! If the order is delivered in parts, then in this table there will be a separate line for each Delivery, but their “Order Number” will be the same (just like in the ETP) |
INVOICE | Invoice | string ( 10 ) | No | Invoice number. Important! Several deliveries and, accordingly, Orders can be combined into one invoice, so this number can be on different lines with different orders and deliveries (as well as in the ETP). |
STATCRED | Loan status | string ( 100 ) | No | Loan status Can take the following values (same as in ETP): Checked Blocked Unblocked |
MIN_SUM | MinSum Status | string ( 100 ) | No | Status for the minimum shipment amount (same as in the ETP): Not blocked Blocked Unblocked |
ETDAT | Deliver item C | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
VDATU | Deliver goods By | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
INCOTERMS_TXT | Delivery type | string ( 100 ) | No | Accepts the following values: Delivery to the Client Pickup |
NUMDOG | Agreement number | string ( 100 ) | No | External Contract Number (same as in ETP) |
COMMENT | Order comment | string ( 100 ) | No | Comment on the order (same as in the ETP) |
COMMENT_EXP | Comment on the expedition | string ( 100 ) | No | Commentary of the expedition (same as in ETP) |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
SUM | Sum | string ( 10 ) | No | Total amount for orders in the selection |
CURRENCY | Currency | string ( 4 ) | No | |
NUM | Number of orders | string ( 20 ) | No | Number of unique order numbers in the selection (may not be the same as the number of rows in the DATA table) |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
VKORG | Sales organization | string ( 4 ) | Yes | The parameter setting is located in the "Service for receiving sales organizations of the client." Example of filling VKORG=4000 |
KUNNR_RG | Buyer | string ( 10 ) | Yes | Available values are returned to the "Client Structure Retrieval Service". Table RG_TAB-KUNNR Example of filling KUNNR_RG=00000000 |
SCRDATE | Creation date From | string ( 10 ) | No | Creation date From (if the parameter is not filled in, the current date is set) Date format YYYYMMDD Filling example SCRDATE=20170105 |
ECRDATE | Software creation date | string ( 10 ) | No | Software creation date (if the parameter is not filled in, the current date is set) Date format YYYYMMDD Filling example ECRDATE=20170105 |
SDLDATE | Delivery of goods C | string ( 10 ) | No | Delivery of goods From Date format YYYYMMDD Filling example SDLDATE=20170105 |
EDLDATE | Delivery of software goods | string ( 10 ) | No | If you need to receive only rejected order items, then set this parameter = 1 |
KURR_LOGIN | Current login | 0,1,or empty string ( 1 ) | No | Orders are filtered by current login |
general description of the answer
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
DATA | Search results table | array ( - ) | No | |
INF | Summary information on received data | array ( - ) | No |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
POSNR | Item number in the order | string ( 10 ) | No | |
BRAND | Brand | string ( <18 ) | No | Brand name |
PIN | Item number | string ( <40 ) | No | PIN (search string) |
NAME | Name | string ( 100 ) | No | Item name |
ORDER | Order number | string ( 10 ) | No | Order number |
ORDER_TYPE | Order type | string ( 100 ) | No | The order type depends on the location of shipment (marked in different colors in the ETP), takes the following values: Shipment from MAIN warehouses Delivery from NEAR warehouses Delivery from FAR warehouses Delivery from central locker |
ORDER_DATE | Order date | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
ORDER_STATUS | Order status | string ( 100 ) | No | Order status can take the following values (icon next to the number in the ETP): Created In progress Closed Rejected |
ETDAT | Deliver item C | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
VDATU | Deliver goods By | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
KWMENG | Quantity in order | string ( 20 ) | No | Quantity "On order" |
KWMENG_REQ | Quantity to be purchased | string ( 20 ) | No | Quantity "To be purchased" only for orders ORDER_TYPE = "Delivery from central lock" for others = "-" |
KWMENG_PROC | Expected quantity | string ( 20 ) | No | Quantity "Expected" only for orders ORDER_TYPE = "Delivery from central lock" for others = "-" |
KWMENG_L | Quantity posted | string ( 20 ) | No | Quantity "Capitalized" to the purchasing warehouse only for orders ORDER_TYPE = "Delivery from central warehouse" for others = "-" |
KWMENG_REJ_P | Quantity rejected by supplier | string ( 20 ) | No | Quantity "Rejected by supplier" only for orders ORDER_TYPE = "Delivery from central lock" for others = "-" |
KWMENG_WAYIN | Quantity in transit | string ( 20 ) | No | Quantity "On the way" only for orders ORDER_TYPE = "Delivery from central locker" for others = "-" |
KWMENG_P | For delivery | string ( 20 ) | No | Quantity "To be delivered" if <> 0 then displays the quantity ready for shipment to the Client |
KWMENG_R | Quantity Shipped | string ( 20 ) | No | Quantity "Shipped" quantity ALREADY shipped to the Client |
KWMENG_REJ | Rejected quantity | string ( 20 ) | No | Rejected quantity that was rejected |
PRICE | Unit price | string ( 20 ) | No | Price per unit Item |
CURRENCY | Currency | string ( 4 ) | No | |
STATUS | Position status | string ( 100 ) | No | Accepts the following values: - empty value - position fully delivered - position partially delivered - position partially rejected - position completely rejected |
STATCRED | Credit blocked | string ( 50 ) | No | Loan status Can take the following values (same as in ETP): Blocked Not blocked |
NOTE | Note | string ( 100 ) | No | Position note |
DLVRD | Expected date | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
WRNTD | Guaranteed date | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
ABGRU_TXT | Reason for rejection | string ( 100 ) | No | If a position is rejected, the text Rejection Reasons is displayed |
POSEX | Link to "Parent Position" | string ( 6 ) | No | The number of the parent position from which the reorder was made, or the item was transferred to substandard. Positions are numbered sequentially for several reorders, forming a chain of reorders |
POSROOT | Link "To root position" | string ( 6 ) | No | Root position number. This number is referenced by all created dependent items |
CHARG | Sign of substandard | string ( 10 ) | No | If NOT empty, then this position contains a substandard product. You can see a photo of it in the ETP |
CHARG_BLK | Sign of blocking substandard conditions for shipment | bool ( 1 ) | No | If = True, then this item of substandard goods is blocked for shipment and a decision must be made on whether to ship it or not. You can unblock it in the ETP when editing the order or you need to contact the manager |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
SUM | Sum | string ( 10 ) | No | Total amount for orders in the selection |
CURRENCY | Currency | string ( 4 ) | No | |
NUM | Number of orders | string ( 20 ) | No | Number of unique order numbers in the selection (may not be the same as the number of rows in the DATA table) |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
VKORG | Sales organization | string ( 4 ) | Yes | The parameter setting is located in the "Service for receiving sales organizations of the client." Example of filling VKORG=4000 |
KUNNR_RG | Buyer | string ( 10 ) | Yes | Available values are returned to the "Client Structure Retrieval Service". Table RG_TAB-KUNNR Example of filling KUNNR_RG=00000000 |
SCRDATE | Creation date From | string ( 10 ) | No | Creation date From (if the parameter is not filled in, the current date is set) Date format YYYYMMDD Filling example SCRDATE=20170105 |
ECRDATE | Software creation date | string ( 10 ) | No | Software creation date (if the parameter is not filled in, the current date is set) Date format YYYYMMDD Filling example ECRDATE=20170105 |
SDLDATE | Delivery of goods C | string ( 10 ) | No | Delivery of goods From Date format YYYYMMDD Filling example SDLDATE=20170105 |
EDLDATE | Delivery of software goods | string ( 10 ) | No | If you need to receive only rejected order items, then set this parameter = 1 |
Rejected | Rejected items only | 0,1,or empty string ( 1 ) | No | 0,1,or empty string |
KURR_LOGIN | Current login | 0,1,or empty string ( 1 ) | No | Orders are filtered by current login |
general description of the answer
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
DATA | Search results table | array ( - ) | No | |
INF | Summary information on received data | array ( - ) | No |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
POSNR | Item number in the order | string ( 10 ) | No | |
BRAND | Brand | string ( <18 ) | No | Brand name |
PIN | Item number | string ( <40 ) | No | PIN (search string) |
NAME | Name | string ( 100 ) | No | Item name |
ORDER | Order number | string ( 10 ) | No | Order number |
ORDER_TYPE | Order type | string ( 100 ) | No | The order type depends on the location of shipment (marked in different colors in the ETP), takes the following values: Shipment from MAIN warehouses Delivery from NEAR warehouses Delivery from FAR warehouses Delivery from central locker |
ORDER_DATE | Order date | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
ORDER_STATUS | Order status | string ( 100 ) | No | Order status can take the following values (icon next to the number in the ETP): Created In progress Closed Rejected |
ETDAT | Deliver item C | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
VDATU | Deliver goods By | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
KWMENG | Quantity in order | string ( 20 ) | No | Quantity "On order" |
KWMENG_REQ | Quantity to be purchased | string ( 20 ) | No | Quantity "To be purchased" only for orders ORDER_TYPE = "Delivery from central lock" for others = "-" |
KWMENG_PROC | Expected quantity | string ( 20 ) | No | Quantity "Expected" only for orders ORDER_TYPE = "Delivery from central lock" for others = "-" |
KWMENG_L | Quantity posted | string ( 20 ) | No | Quantity "Capitalized" to the purchasing warehouse only for orders ORDER_TYPE = "Delivery from central warehouse" for others = "-" |
KWMENG_REJ_P | Quantity rejected by supplier | string ( 20 ) | No | Quantity "Rejected by supplier" only for orders ORDER_TYPE = "Delivery from central lock" for others = "-" |
KWMENG_WAYIN | Quantity in transit | string ( 20 ) | No | Quantity "On the way" only for orders ORDER_TYPE = "Delivery from central locker" for others = "-" |
KWMENG_P | For delivery | string ( 20 ) | No | Quantity "To be delivered" if <> 0 then displays the quantity ready for shipment to the Client |
KWMENG_R | Quantity Shipped | string ( 20 ) | No | Quantity "Shipped" quantity ALREADY shipped to the Client |
KWMENG_REJ | Rejected quantity | string ( 20 ) | No | Rejected quantity that was rejected |
PRICE | Unit price | string ( 20 ) | No | Price per unit Item |
CURRENCY | Currency | string ( 4 ) | No | |
STATUS | Position status | string ( 100 ) | No | Accepts the following values: - empty value - position fully delivered - position partially delivered - position partially rejected - position completely rejected |
STATCRED | Credit blocked | string ( 50 ) | No | Loan status Can take the following values (same as in ETP): Blocked Not blocked |
NOTE | Note | string ( 100 ) | No | Position note |
DLVRD | Expected date | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
WRNTD | Guaranteed date | string ( 20 ) | No | Date format YYYYMMDDHHIISS Filling example DLVDT=20181005120000 |
ABGRU_TXT | Reason for rejection | string ( 100 ) | No | If a position is rejected, the text Rejection Reasons is displayed |
POSEX | Link to "Parent Position" | string ( 6 ) | No | The number of the parent position from which the reorder was made, or the item was transferred to substandard. Positions are numbered sequentially for several reorders, forming a chain of reorders |
POSROOT | Link "To root position" | string ( 6 ) | No | Root position number. This number is referenced by all created dependent items |
CHARG | Sign of substandard | string ( 10 ) | No | If NOT empty, then this position contains a substandard product. You can see a photo of it in the ETP |
CHARG_BLK | Sign of blocking substandard conditions for shipment | bool ( 1 ) | No | If = True, then this item of substandard goods is blocked for shipment and a decision must be made on whether to ship it or not. You can unblock it in the ETP when editing the order or you need to contact the manager |
ZZKWMENG | Ordered | string ( 20 ) | No | Originally ordered quantity |
REJECTED | Rejected | string ( 20 ) | No | Rejected quantity that was rejected |
PROCESSING | In progress | string ( 20 ) | No | The quantity of inventory in warehouses, and for orders ORDER_TYPE = "Delivery from the central locker" additional quantity purchased from the supplier |
READY | Ready to ship | string ( 20 ) | No | Quantity ready for shipment. Includes the quantity in the shipping warehouse and the quantity already picked (in deliveries) |
REJ_MENGE | Client failure | string ( 20 ) | No | Quantity that the Customer refused upon delivery |
ReadyToIssue | Ready to issue | string ( 20 ) | No | |
Issued | Issued | string ( 20 ) | No |
Parameter | Name | Type(max-size) | Required | Note |
---|---|---|---|---|
SUM | Sum | string ( 10 ) | No | Total amount for orders in the selection |
CURRENCY | Currency | string ( 4 ) | No | |
NUM | Number of orders | string ( 20 ) | No | Number of unique order numbers in the selection (may not be the same as the number of rows in the DATA table) |