SAP + Le New Black integration overview
SAP is an ERP system that lets you manage finance, accounting, CRM, your product catalogue and more. Le New Black offers a collaborative B2B portal for your team and retailers, and an order-taking iPad app for your sales team.
The connector uses automated file transfer via your SFTP server to exchange data |
|
Le New Black drives all data flows: it triggers every push and pull operation |
|
The connector requires data mapping and configuration in Le New Black and SAP |
Data flows
| Type | Flow |
| Inventory stock levels | SAP ⇢ Le New Black |
| Orders | SAP ⇠ Le New Black |
Data flow: Inventory stock levels
Available-to-promise quantities are imported from SAP for each EAN13.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
File: Name agreed during set-up (setting filename_pattern)
File format: XML file read by Le New Black from a folder of your SFTP server, then moved to an archive folder of the server (settings remote_path and remote_path_to_archive).
File content: For each size, its EAN (EAN11) and its available-to-promise quantity (MENGE)
Matching keys: Size: EAN13.
Import mode: Add by default → only the sizes in the file are updated, the others keep their quantity. Replace, when set up → the stock of every size is set to 0 before the quantities are applied. Negative quantities are imported as 0.
Rejected rows: Rows whose EAN13 is unknown in Le New Black are ignored and reported in the task log: import products first.
Configuration
| Setting | Values | Type | Comment |
filename_pattern |
file name pattern | string | Name of the file to import, agreed during set-up |
remote_path |
folder of the SFTP server | string | Folder of your SFTP server the stock file is read from |
remote_path_to_archive |
folder of the SFTP server | string | Folder of your SFTP server the stock file is moved to once downloaded |
import_mode |
add (default) / replace | string | With replace, the stock of every size is set to 0 before the quantities are applied |
lnb_sku_identifier_column |
ean13 (default) / sku | string | Le New Black key the stock rows are matched against |
lnb_stock_column |
quantity (default) / incoming_quantity | string | Le New Black quantity updated |
Callouts
- A file without any stock data is reported as an error in the task log, and the stock in Le New Black is left as it is.
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are sent to SAP as sales order IDocs, one file per order.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Orders exported: Status Invoicing
Integration status: Only orders whose integration status is Pending are exported, and it becomes Successfully sent after export. The selection can be adapted during set-up.
Status after export: Closed
Blocked orders: An order that fails a check keeps its status and gets the integration status Blocked, with the reason in the task log. It is not sent again until you set its integration status back to Pending from the orders list (action Set integration status to Pending).
Limit: No limit
File: INT043_ followed by the export date and time, your brand identifier and the Le New Black order number on 16 digits, .pos: one file per order
File format: XML IDoc of type /AFS/ORDERS06, put by Le New Black in a folder of your SFTP server (setting remote_path).
File content: One order header (season code, sales type, sales organisation, distribution channel, division, requested delivery date, sold-to customer, ship-to address, PO number set to the Le New Black order number), then one item per ordered size (material, EAN13, size grid value, quantity)
Matching keys: Customer: LNB retailer reference, sent as the SAP customer number (sold-to). Ship-to: LNB address reference of the delivery address. Products: variant reference (sent as the SAP material), EAN13 and SAP size grid value.
Configuration
| Setting | Values | Type | Comment |
division |
SAP division code | string | Division written on every exported order |
environment |
environment name, mapped to its SAP code in the global configuration | string | SAP environment the orders are sent to |
remote_path |
folder of the SFTP server | string | Folder of your SFTP server the order files are put in |
validate_stock_ats |
true / false | bool | With true, the orders are exported in stock allocation order: by status (Invoicing first), then by date |
Callouts
- An order containing a product without an EAN13 code is blocked as a whole: none of its lines is exported.
- An order whose customer has no SAP customer reference in Le New Black is blocked. Other orders are still exported.
- An order is also blocked when its delivery start date, its delivery address reference, its season code or its sales type is missing, or when its customer has no sales organisation or distribution channel.
- With the setting validate_stock_ats, an order with a size ordered beyond its available-to-sell stock is blocked as well.
- The sales organisation and the distribution channel of each customer are read from its first and second extra fields in Le New Black. The SAP season code, sales type and size grid value are set up for your brand with your account manager.
- After the order has been exported from Le New Black, any further change must be made directly in SAP.
Global configuration
Configuration
| Setting | Values | Type | Comment |
ftp_host |
SAP SFTP server address | string | Address of your SAP account |
path_to_private_key |
SAP SFTP private key | string | Credential of your SAP account, set up with your account manager |
environment_code_mapping |
SAP code per environment | list | SAP code of each environment, written as sender and receiver port of every order |
brand_identifier |
SAP brand identifier | string | Identifier of your brand in the name of the order files |
brand_identifier_bis |
SAP brand identifier | string | Identifier of your brand written as receiver address of every order |
Integration project
Who's assigned from your team?
Your SAP administrator, or an IT profile within your company who is familiar with your specific setup. A Sales Manager who understands your business and your merchandising strategy.
Who's in charge at Le New Black
Your account manager at Le New Black takes care of the whole process from day 1:
- Asking questions about your specific SAP setup and sales process.
- Collaborating with SAP as they configure the data files to import and export.
- Generating and exporting test orders to SAP.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and SAP to troubleshoot any unexpected issue after launch.
Integration monitoring
Once the connector is set up, the Integration center of your back-office gives you a set of tools to manage and monitor the integration:
- Task logs, for continuous monitoring and troubleshooting (for example a missing EAN13 or retailer reference that prevents an order from being exported)
- Running a task on demand, to push or pull data at once
- A preview of the data before the actual import (only available on some connectors)
- E-mail notifications per task, set up on request: exported and blocked orders, import errors
- The integration status of each order in the orders list (Pending, Successfully sent, Blocked), which you can set back to Pending to send an order again
Each import task processes one file per run: when several files are waiting, the next ones are processed on the following runs. A file that cannot be read or misses a required column is set aside and reported in the task log, so it does not hold back the next files.
Comments
0 comments
Please sign in to leave a comment.