| Status | Approved |
|---|---|
| Owner | |
| Stakeholders |
Purpose
The purpose of this document is to define the functional requirements, methodology, and approach for the initial data loading and subsequent synchronization of Business Rule Framework Plus (BRF+) Output Management data in SAP S/4HANA.
This process will establish and maintain output determination records (e.g., email recipients, output channels, and conditions related to BP) in BRF+ based on the configuration and master data currently maintained in Classic Output Management (NAST framework) within the legacies from SAP ECC.
Conversion Scope
The conversion scope covers the extraction, transformation, and loading of output determination data from Classic Output Management (NAST-based framework) into BRF+ Output Parameter Determination (OPD) in S/4HANA, ensuring both initial migration and interim synchronization until full adoption of BRF+ is achieved.
The scope includes:
- Extraction of customer-related output condition records (e.g., for Sales Orders, Quotations, Contracts, Scheduling Agreements, Invoice and Credit and Debit memos) from Classic Output Management, including associated communication details such as email addresses, language, and output channels;
- Cleansing and Harmonization of extracted data to remove obsolete, incomplete, or duplicated entries, ensuring only valid and active output records are migrated;
- Mapping of Classic condition record keys (application, condition type, key combination) to BRF+ OPD parameters (e.g., Customer, Sales Organization, Document Type, Output Type);
- Transformation of medium and dispatch settings from Classic (e.g., NAST medium codes) to BRF+ equivalent channels (e.g., Email, Print, EDI), ensuring compatibility with S/4HANA Output Management settings;
- Initial Load of the transformed dataset into BRF+ Output Parameter Determination using the OPD framework and/or BRF+ application data load methods;
- Ongoing Synchronization process to detect and apply changes made in Classic Output Management to BRF+, allowing a parallel run period until Classic Output Management is fully decommissioned;
- Validation to ensure that migrated BRF+ records produce identical output results as their Classic counterparts for equivalent sales scenarios.
Out of Scope:
- Migration of output determination for applications outside of sales (e.g., MM Purchasing outputs);
- Modifications to customer master data beyond the email and communication fields required for BRF+;
- Changes to output form templates (Smartforms/Adobe Forms) beyond what is required for enabling BRF+.
The data from legacy system includes:
- Active output condition records for Sales (Application V1 and V3) linked to customers (Partner Function SP, BP,PY, CONTACTS) with maintained communication details (email address, fax, etc.)
- Output types relevant for Sales Orders, Quotations, Contracts, Invoices and memos and Scheduling Agreements that are in active use in the business process
- Records with valid medium settings (e.g., Email, Print, EDI) compatible with S/4HANA BRF+ output channels
- Language assignments that are valid in the target system
The data from legacy system excludes:
- Obsolete, expired, or logically deleted output condition records
- Condition records for customers that are blocked for sales or flagged for deletion in the customer master
- Output types not used in the current or target S/4HANA sales processes
- Records with incomplete or invalid communication data (e.g., missing email for email output medium)
- Condition records belonging to applications other than sales (e.g., MM, FI outputs)
Data Profiling
List of source systems and approximate number of records for tables for
Usage = B
Application: = V1 and V3
- transmission mediums 5,6,7,8:
List of source systems and approximate number of records
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| PF2 V1 | 53997 records (raw count) | S4/Hana | ||
| PF2 V3 | 134195 records (raw count) | |||
| WP2 V1 | 36012 records (raw count) | |||
| WP2 V3 | 42777 records (raw count) | S4/Hana | ||
| Source | Application | Table | Table Description | Output Types | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|---|---|---|
| WQ2 V1 SALES OUTPUTS | |||||||
| WQ2 | V1 | 001 | Sales Organization/Customer Number | BA00/SDB/ZMCE/ZRC3/ZRS2/ZRSP/ZRST/ZSY2/ZSYC | 534 | ||
| WQ2 | V1 | 005 | Sales Organization/Order Type | SDB/ZAAR/ZAN1/ZARC/ZARD/ZARE/ZBA0/ZBA1/ZBA2/ZBA6/ZBA8/ZBA9/ZBAC/ ZBDC/ZBSC/ZCQ1/ZLRG/ZMRC/ZMRM/ZPL1/ZSTC/ZSTO/ZTP1/ | 2441 | ||
| WQ2 | V1 | 007 | Order Type | ZPI1/ | 37 | ||
| WQ2 | V1 | 013 | Sales Org. | ZAAR/ZAN0/ZAN1/ZARC/ZARD/ZARE/ZARM/ZBA1/ ZBA2/ZBA5/ZBA6/ZBA7/ZBA8/ZBA9/ZBAC/ZBAR/ZBSC/ | 125 | ||
| WQ2 | V1 | 502 | Sales org./Sales off. | ZAAR/ZAN0/ZAN1/ZARC/ZARD/ZARE/ZARM/ZBA0/ZBA1/ZBA2/ZBA3/ZBA5/ ZBA6/ZBA7/ZBA8/ZBA9/ZBAR/ZBSC/ZCQ1/ZCQR/ZCSC/ZMRC/ZMRM/ZPL1/ | 477 | ||
| WQ2 | V1 | 503 | Sales organization/Sales office/Commercial assistant | ZAAR/ZAN0/ZAN1/ZARC/ZARD/ZARE/ZARM/ZBA0/ZBA1/ZBA2/ZBA3/ZBA5/ZBA6/ ZBA7/ZBA8/ZBA9/ZBAR/ZBSC/ZCQ1/ZCQR/ZCSC/ZMRC/ZMRM/ZPL1/ | 278 | ||
| WQ2 | V1 | 506 | Sales organization/Sales office/Sold-to party | ZARC/ZARM/ZBA0/ZBA1/ZBA2/ZBA5/ZBA9/ZBAC/ ZBSC/ZC10/ZC17/ZC19/ZCAR/ZCOE/ZMRC/ZMRM/ | 179 | ||
| WQ2 | V1 | 532 | Sales Org/DC/Sales Office | ZARC/ZARM/ZBA1/ZBA2/ZBA9/ZBAC/ZBAR/ZBSC/ZMRM/ | 26 | ||
| 6 | |||||||
| WQ2 | V1 | 559 | Sales org./Sold to Country/Currency | ZARC/ZARM/ZBAC/ | 16 | ||
| WQ2 | V1 | 701 | Ship Point/SalesDocTy | ZDOC/ | 1 | ||
| WQ2 | V1 | 933 | Sales org./PO type | ZARM/ZAWA/ | 91 | ||
| WQ2 | V1 | 934 | Sales org./PO type/Sold-to pt | ZAWA/ | 763 | ||
| WQ2 V3 INVOICE OUTPUTS | |||||||
| WQ2 | V3 | 001 | Sales Organization/Customer Number | 952 | |||
| WQ2 | V3 | 008 | Billing Type | 39 | |||
| WQ2 | V3 | 011 | Sales Organization/Billing Type | 411 | |||
| WQ2 | V3 | 013 | Sales Org. | 9 | |||
| WQ2 | V3 | 504 | Sales organization/ Shipping point | 1 | |||
| WQ2 | V3 | 505 | Sales organization/Shipping point/Bill-to party | 3 | |||
| WQ2 | V3 | 507 | Sales organization/Sales office/Bill-to party | 163 | |||
| WQ2 | V3 | 511 | Sales organization/Sales office | 53 | |||
| WQ2 | V3 | 512 | Sales organization/Sales office/Commercial assistant | 47 | |||
| WQ2 | V3 | 533 | Sales Org/Distribution Channel/Sales Office | 5 | |||
| WQ2 | V3 | 539 | Sales org./Sales Off./Created/Bill. Type | 1 | |||
| WQ2 | V3 | 551 | Sales org./Doc.cat./Sales Off./Bill to | 79 | |||
| WQ2 | V3 | 552 | Sales org./Sales Off./Doc.cat./SalesDocTy/e-inv. flag | 788 | |||
| WQ2 | V3 | 553 | Sales Off./Doc.cat./e-inv. flag | 85 | |||
| WQ2 | V3 | 554 | Sales org./Sales Off./Doc.cat./e-inv. flag | 673 | |||
| WQ2 | V3 | 558 | Sales Organization/Sales Office/Billing Type | 106 | |||
| WQ2 | V3 | 560 | Sales Off./e-inv. flag | 6 | |||
| WQ2 | V3 | 569 | Sales org./Currency/Plant/Bill. Type | 11 | |||
| WQ2 | V3 | 570 | Sales org./Currency/Bill. Type | 6 | |||
| WQ2 | V3 | 572 | Sales org./Distr. Chl/Bill. Type/Sold-To Pt | 21 | |||
| WQ2 | V3 | 889 | Sales org./Sold-to pt | 27 | |||
| WQ2 | V3 | 910 | Interco. billing: Org.comm./Bill-to | 37 | |||
| WQ2 | V3 | 923 | Sales Organization/Distribution Channel/Bill-to party | 51 | |||
| WQ2 | V3 | 953 | Sales org./Bill.type/Payer | 84 | |||
| WQ2 | V3 | 955 | Sales org./Ship.point/Bill.type/RecipCntry | 6541 | |||
| WQ2 | V3 | 957 | Sales organization/Billing type/Bill-to party | 7326 | |||
| WQ2 | V3 | 960 | e-invoicing | 1 | |||
| WQ2 | V3 | 962 | Sales Organization/Distribution Channel/Billing Type/Ship-to | 72 | |||
| WQ2 | V3 | 995 | Sales Org/Sales Office/Billing Type/Dest country | 44 | |||
| QF1 V1 SALES OUTPUTS | |||||||
| QF2 | V1 | 001 | Sales Organization/Customer Number | BA00/SDB/ZC2B/ZC44/ZC46/ZC52/ZC55/ZMCE/ZRC3/ZRS2/ZRSP/ZRST/ZSY2/ZSYC | 18392 | ||
| QF2 | V1 | 005 | Sales Organization/Order Type | SDB/ZAAR/ZAN1/ZARC/ZARD/ZARE/ZBA0/ZBA1/ZBA2/ZBA6/ZBA8/ZBA9/ZBAC/ ZBDC/ZBSC/ZCQ1/ZLRG/ZMRC/ZMRM/ZPL1/ZSTC/ZSTO/ZTP1/ | 292 | ||
| QF2 | V1 | 006 | SOrg./Distrib.Ch/Division/Customer | ZC46/ZC50/ZCER/ | 11 | ||
| QF2 | V1 | 506 | Sales Off./Ship-To/SalesDocTy/Division | ZARC/ZARM/ZBA0/ZBA1/ZBA2/ZBA5/ZBA9/ZBAC/ ZBSC/ZC10/ZC17/ZC19/ZCAR/ZCOE/ZMRC/ZMRM/ | 75 | ||
| QF2 | V1 | 866 | Sales Organization/Division/Customer | SDB/ | 1 | ||
| QF2 | V1 | 867 | Sales Organization/Division/Customer/Quality code | SDB/ | 253 | ||
| QF2 | V1 | 875 | Sales Organization/Order Type/Quality code | SDB/ | 261 | ||
| QF2 | V1 | 876 | Sales Organization/Customer/Quality code | SDB/ | 53293 | ||
| QF2 | V1 | 891 | Sales Office/Customer/Sales Document Type | ZC10/ZC11/ZC13/ZC14/ZC15/ZC16/ZC17/ZC19/ ZC35/ZC36/ZC40/ZCAR/ZCOE/ZCOF/ | 11248 | ||
| 5 | |||||||
| QF2 | V1 | 912 | Sales office/Sales document type | ZC10/ZC11/ZC13/ZC15/ZC16/ZCAR/ZCOE/ | 121 | ||
| QF2 | V1 | 913 | Sales office | ZC10/ZC11/ZC13/ZC15/ZCAR/ | 31 | ||
| QF2 | V1 | 917 | Sales Office/Sales DocType/PO type | ZC10/ZC17/ZCAR/ | 121 | ||
| QF2 | V1 | 918 | Sales office/Sold-to party | ZC10/ZC11/ZC13/ZC14/ZC17/ZC19/ZC35/ZC36/ZCAR/ZCOE/ | 3318 | ||
| QF2 | V1 | 922 | Sales office/Shipping conditions. | ZC30/ZC31/ZC40/ | 221 | ||
| QF2 | V1 | 938 | Sales organization/Purchase order type/Customer | ZC2B/ | 24 | ||
| QF2 | V1 | 950 | Sales office/Division/Sales document type | ZC10/ZC11/ZC13/ZC17/ZC19/ZCAR/ZCOE/ | 344 | ||
| QF2 | V1 | 956 | Sales office/Shipping conditions/Plant | ZC30/ZC32/ | 34 | ||
| QF2 | V1 | 959 | Sales office/Shipping conditions/Service agent | ZC30/ZC40/ | 108 | ||
| QF2 | V1 | 972 | Sales office/Shipping conditions/Contact Agent | ZC31/ | 1 | ||
| QF2 | V1 | 986 | Sales office/Country (Sold-to party) | ZC10/ZC11/ZC17/ZC19/ZCAR/ | 319 | ||
| QF2 | V1 | 989 | Sales Organization/Customer/Sales Document Type | ZC2B/ | 4 | ||
| QF1 V3 INVOICE OUTPUTS | |||||||
| QF2 | V3 | 001 | Sales Organization/Customer Number | 2966 | |||
| QF2 | V3 | 006 | SOrg./Distrib.Ch/Division/Customer | 387 | |||
| QF2 | V3 | 008 | Billing Type | 2 | |||
| QF2 | V3 | 011 | Sales Organization/Billing Type | 195 | |||
| QF2 | V3 | 013 | Sales Org. | 63 | |||
| QF2 | V3 | 840 | Sales office / Sold-to Doc type / Billing Type | 35 | |||
| QF2 | V3 | 841 | Sales office / Sold-to Doc type | 122 | |||
| QF2 | V3 | 913 | Sales office | 110 | |||
| QF2 | V3 | 916 | Bill-to party | 2 | |||
| QF2 | V3 | 919 | Sales office/Bill-to party/Billing type | 1332 | |||
| QF2 | V3 | 920 | Bill.type/Sales org./RecipCntry | 14 | |||
| QF2 | V3 | 921 | Sales office/Bill-to party | 14365 | |||
| QF2 | V3 | 927 | Billing type/Bill-to party | 72 | |||
| QF2 | V3 | 932 | Payer | 192 | |||
| QF2 | V3 | 935 | Sales organization/Shipping point/Billing type | 69 | |||
| QF2 | V3 | 937 | Payer/Billing type | 986 | |||
| QF2 | V3 | 939 | Sales office/Manual invoice maintenance | 28 | |||
| QF2 | V3 | 940 | Sales office/Bill-to party/Manual invoice maintenance | 46 | |||
| QF2 | V3 | 942 | Sales office/Country (Bill-to party) | 271 | |||
| QF2 | V3 | 953 | Sales office/Sales group | 72 | |||
| QF2 | V3 | 958 | Sales off./Sales org./Bill.type | 71 | |||
| QF2 | V3 | 963 | Sales org./Contact agent/Bill.type | 1056 | |||
| QF2 | V3 | 966 | Sales org./Payer/Bill.type | 32553 | |||
| QF2 | V3 | 967 | Sales Organization/PO type/Sold-to party | 1 | |||
| QF2 | V3 | 973 | Bill.type/Sales org./RecipCntry/Payer | 96 | |||
| QF2 | V3 | 974 | Sales organization/Billing type/Bill-to party | 1882 | |||
| QF2 | V3 | 975 | Sales organization/Billing type/Delivering country | 23 | |||
| QF2 | V3 | 985 | Sales organization/Sold-to party | 11 | |||
| QF2 | V3 | 993 | Sales Organization/Billing Type/Destination Country | 16 | |||
| QF2 | V3 | 998 | Sales organization/Payer | 102 | |||
Additional Information
Multi-language Requirement
Output texts and messages will be migrated for all relevant languages (EN, FR, NL, PT, etc.).
Document Management
All deliverables, SQL extractions, and DCT templates will be version-controlled in Confluence and Jira.
Legal Requirement
Special Requirements
Target Design
In S/4HANA Output Management (via BRF+), decision tables replace the condition technique. Each BRF+ decision table acts like a flexible rule set:
Input Parameters → Decision Logic → Output Parameters (Result)
They determine:
- Output Type (e.g., ORDER_CONFIRMATION, BILLING_OUTPUT)
- Output Channel (e.g., Email, Print, EDI)
- Form Template (Adobe Form)
- Receiver (Partner Function)
- Language
Strategic Approach: BRF+ Output Simplification
Merge multiple legacy ECC output types (e.g., ZC10,ZC11,ZARM...) into a single BRF+-driven output type, e.g. ORDER_CONFIRMATION to simplify maintenance and governance.
Minimize the creation of outputs that are rarely triggered, focusing on high-value and frequently triggered scenarios.
Avoid using business partners or email addresses as decision table input parameters. Instead, leverage business partner attributes to determine the appropriate outputs and channels.
Implication:
There will be no direct one-to-one mapping from ECC condition records to BRF+ decision tables. The approach emphasizes a simplified, rules-driven model that covers the majority of business scenarios while reducing complexity.
Following Decision tables have been identified in the sandbox. This tables are for demonstration purposes and may change.
| Decision Table Name | Input Parameter 1 | Input Parameter 2 | Input Parameter 3 | Input Parameter 4 | Input Parameter 5 | Input Parameter 6 | Input Parameter 7 | Input Parameter 8 | Input Parameter 9 | Result | Result |
|---|---|---|---|---|---|---|---|---|---|---|---|
DT_OUTPUT_TYPE | Sales Document Cat. | Sales Doc. Type | Output Type | Dispatch Time | |||||||
| DT_OUTPUT_CHANNEL | Output Type | Partner Role | Sales Org. | Distr. Channel | Division | Sales Office | Recipient | Channel | |||
| DT_RECEIVER | Output Type | Partner Role | Exclusive Indicator | ||||||||
| DT_EMAIL_SETTING | Output Type | Partner Role | Sales Org. | Distr. Channel | Division | Sales Office | Sender Email | Email Template | |||
| DT_EMAIL_RECEIVER | Output Type | Partner Role | Email Type Code | E-Mail Address | |||||||
| DT_OUTPUT_RELEVANCE | Output Type | Purch Conf. Sts | Overall Header | Overall Cred Stat | Delivery Block | Billing Block | All Items | Relevance Indicator | |||
Data Cleansing
The cleansing activity involves validation of message types, partner functions, and language assignments. Records with missing partner data or invalid Output Types will be flagged for correction. Duplicate or inconsistent entries will be resolved before transformation. Currently none of those cases were encountered at Syensqo.
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|---|---|---|---|---|
Conversion Process
The high-level process is represented by the diagram below:
Data Privacy and Sensitivity
All data extracted must be anonymized and handled according to data protection policies.
Extraction
Data will be extracted from ECC using SQLbased queries executed on the source database. The extraction will include relevant tables such as NACH, TNAPR, The extraction methods are as follows:
- Full extraction from relevant tables in ECC (preferred).
- Extraction through the application layer when database access is restricted.
- Manual extraction via reports or DCT if system access is not possible.
Relevancy criteria will be applied to include only active, valid, and inscope records.
Extraction Run Sheet: To be provided after the first mock cycle.
Source Table to be extracted: NACH Table
| Table | Field | Data Element | Data Type | Length | Short Description | Requirement |
| NACH | MANDT | MANDT | CLNT | 3 | Client | Mandatory |
| NACH | KNUMH | NNUMH | CHAR | 10 | Number of output condition record | Mandatory |
| NACH | ERNAM | ERNAM | CHAR | 12 | Name of Person Who Created the Object | Optional |
| NACH | ERDAT | ERDAT | DATS | 8 | Date on Which Record Was Created | Optional |
| NACH | KVEWE | KVEWE | CHAR | 1 | Usage of the condition table | Mandatory |
| NACH | KOTABNR | KOTABNR | CHAR | 3 | Condition table | Mandatory |
| NACH | KAPPL | KAPPL | CHAR | 2 | Application | Mandatory |
| NACH | KSCHL | KSCHL_OC | CHAR | 4 | Condition Type | Mandatory |
| NACH | VAKEY | VAKEY | CHAR | 100 | Variable key 100 bytes | Mandatory |
| NACH | DATAB | DATAB | DATS | 8 | ValidFrom Date | Optional |
| NACH | DATBI | DATBI | DATS | 8 | Valid To Date | Optional |
| NACH | KOSRT | KOSRT | CHAR | 10 | Search term for conditions | Optional |
| NACH | PARVW | PARVW | CHAR | 2 | Partner Function | Mandatory |
| NACH | PARNR | NA_PARNR_OC | CHAR | 10 | Message partner | Mandatory |
| NACH | NACHA | NA_NACHA | CHAR | 1 | Message transmission medium | Mandatory |
| NACH | ANZAL | NA_ANZAL | DEC | 2 | Number of messages (original + copies) | Optional |
| NACH | VSZTP | NA_VSZTP | CHAR | 1 | Dispatch time | Mandatory |
| NACH | TCODE | CSTRATEGY | CHAR | 4 | Communication strategy | Optional |
| NACH | AENDE | NA_AENDE | CHAR | 1 | Change message flag | Optional |
| NACH | PFLD2 | NA_OBS030 | CHAR | 30 | Unused field | Optional |
| NACH | PFLD3 | TDSFNAME | CHAR | 30 | Smart Forms: Form Name | Optional |
| NACH | PFLD4 | NA_TDFORM | CHAR | 30 | WFMC: SAPscript form in 30character field | Optional |
| NACH | PFLD5 | NA_LABEL | CHAR | 30 | WFMC: Function module for print formatting | Optional |
| NACH | TDNAME | NA_OBJKY_L | CHAR | 70 | Object key (long) | Optional |
| NACH | TDID | TDID | CHAR | 4 | Text ID | Optional |
| NACH | SPRAS | SPRAS | LANG | 1 | Language Key | Optional |
| NACH | FORFB | BCS_RQST_OC | CHAR | 1 | Requested Status | Optional |
| NACH | PRIFB | BCS_STML_OC | CHAR | 1 | Setting for Which Statuses Are Reported by Mail | Optional |
| NACH | LDEST | RSPOPNAME | CHAR | 4 | Spool: Output device | Optional |
| NACH | DSNAM | RSPO0NAME | CHAR | 6 | Spool request: Name | Optional |
| NACH | DSUF1 | RSPO1NAME | CHAR | 4 | Spool request: Suffix 1 | Optional |
| NACH | DSUF2 | RSPO2NAME | CHAR | 12 | Spool request: Suffix 2 | Optional |
| NACH | DIMME | TDIMMED_OC | CHAR | 1 | Print immediately | Optional |
| NACH | DELET | TDDELETE_OC | CHAR | 1 | Release after output | Optional |
| NACH | TDRECEIVER | SYPRREC | CHAR | 12 | Spool Recipient Name | Optional |
| NACH | TDDIVISION | SYPRABT | CHAR | 12 | Spool Department Name | Optional |
| NACH | TDOCOVER | SYPRSAP | CHAR | 1 | Print: SAP cover page | Optional |
| NACH | TDCOVTITLE | SYPRTXT | CHAR | 68 | Spool Description | Optional |
| NACH | TDAUTHORITY | SYPRBER | CHAR | 12 | Print: Authorization | Optional |
| NACH | ACOUT | SO_ACOUT | CHAR | 1 | ToDo: To Be Completed Outside SAPoffice | Optional |
| NACH | SKIPS | NA_OBS001 | CHAR | 1 | Unused field | Optional |
| NACH | ACMEM | SO_ACMEM | CHAR | 32 | Process: memory ID | Optional |
| NACH | ACNAM | SNA_ACNAM | CHAR | 30 | Execute: Name of report, FM, DB, TCodes (old length) | Optional |
| NACH | EVENT | SWO_EVENT | CHAR | 32 | Event | Optional |
| NACH | OBJTYPE | OBJ_NAME_OC | CHAR | 10 | Object type | Optional |
| NACH | TDSCHEDULE | SKSCHEDULE_OC | CHAR | 3 | Send time request | Optional |
| NACH | TDARMOD | SYARMOD_OC | CHAR | 1 | Print: Archiving mode | Optional |
The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads
Extraction Run Sheet
| Req # | Requirement Description | Team Responsible |
|---|---|---|
| 001 WP2 V1 | NACHKVEWE 'B' (Usage Output) NACHKAPPL 'V1' (Application Sales Order) NACHKOTABNR ( Table: all ) NACHKSCHL (Output types) NACHNACHA (Transmission Medium) | |
001 WP2 V3 | NACHKVEWE 'B' (Usage Output) NACHKAPPL 'V3' (Application Invoice) NACHKOTABNR ( Table: all ) NACHKSCHL (Output types) NACHNACHA (Transmission Medium) | |
| 001 PF2 V1 | NACHKVEWE 'B' (Usage Output) NACHKAPPL 'V1' (Application Sales Order) NACHKOTABNR ( Table: all ) NACHKSCHL (Output types) NACHNACHA (Transmission Medium) | |
001 F22 V3 | NACHKVEWE 'B' (Usage Output) NACHKAPPL 'V3' (Application Invoice) NACHKOTABNR ( Table: all ) NACHKSCHL (Output types) NACHNACHA (Transmission Medium) |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
Data Collection Template (DCT)
BRF+ provides a builtin feature to download and upload decision tables as Excel files.
Steps:
Go to your BRF+ application in transaction BRF+ (or BRFPLUS).
Open the Decision Table object.
From the Table Maintenance screen:
Click on “Download to Excel” → system exports the current content and structure.
Fill in or update the Excel file offline.
Use “Upload from Excel” to import it back.
Note:
- Each table must be handled individually.
- The creation of Data collection template must be aligned with BRF+ configurations . For now, the following Template is prepared based on Configurations from S/4HANA Sandbox environment. This will be replaced once the configuration is ready. The same applies to the contents of the DTs, they are here as examples and will be replaced by real configuration objects .
| Decision Table Name | Input Parameter 1 | Input Parameter 2 | Input Parameter 3 | Input Parameter 4 | Input Parameter 5 | Input Parameter 6 | Input Parameter 7 | Input Parameter 8 | Input Parameter 9 | Result | Result |
|---|---|---|---|---|---|---|---|---|---|---|---|
DT_OUTPUT_TYPE | Sales Document Cat. | Sales Doc. Type | Output Type | Dispatch Time | |||||||
| DT_OUTPUT_CHANNEL | Output Type | Partner Role | Sales Org. | Distr. Channel | Division | Sales Office | Recipient | Channel | |||
| DT_RECEIVER | Output Type | Partner Role | Exclusive Indicator | ||||||||
| DT_EMAIL_SETTING | Output Type | Partner Role | Sales Org. | Distr. Channel | Division | Sales Office | Sender Email | Email Template | |||
| DT_EMAIL_RECEIVER | Output Type | Partner Role | Email Type Code | EMail Address | |||||||
| DT_OUTPUT_RELEVANCE | Output Type | Purch Conf. Sts | Overall Header | Overall Cred Stat | Delivery Block | Billing Block | All Items | Relevance Indicator |
DT_OUTPUT_TYPE:
DCT Rules:
| Name | Description(Text) | Result Column | Type | Binding | Length | Decimals | Only Positive | Only Uppercase | Timepoint Type | Dimension Key |
| SDDOCUMENTCATEGORY | Document Cat. | Element (Text ) | VBTYPL | 4 | 0 | |||||
| SALESDOCUMENTTYPE | Sales Doc. Type | Element (Text ) | AUART | 4 | 0 | X | ||||
| OUTPUT_TYPE | Output Type | X | Element (Text ) | APOC_OUTPUT_TYPE | 30 | 0 | X | |||
| DISPATCH_TIME | Dispatch Time | X | Element (Text ) | APOC_OR_DISPATCH_TIME | 1 | 0 | X |
DCT Template:
| Document Cat. | Sales Doc. Type | Output Type | Dispatch Time |
| =C | =OR | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | 2 |
| =C | <>BV ; exclude =SO01 ; =CCIS | ORDER_CONFIRMATION | 1 |
| =C | <>BV ; exclude =SO01 ; =CCIS | ORDER_CONFIRMATION_CHANGE | 1 |
| =C | =BV | CASH_SALE | 1 |
| =A | SALES_INQUIRY | 1 |
DT_RECEIVER:
DCT Rules:
| DT_RECEIVER | ||||||||||
| Name | Description(Text) | Result Column | Type | Binding | Length | Decimals | Only Positive | Only Uppercase | Timepoint Type | Dimension Key |
| OUTPUT_TYPE | Output Type | Element (Text ) | APOC_OUTPUT_TYPE | 30 | 0 | X | ||||
| ROLE | Role | X | Element (Text ) | APOC_ROLE_CODE | 2 | 0 | X | |||
| EXCLUSIVE_IND | Exclusive Indicator | X | Element (Text ) | APOC_EXCLUSIVE_INDICATOR | 1 | 0 | X | |||
DCT Template:
| DT_RECEIVER | ||
|---|---|---|
| Output Type | Role | Exclusive Indicator |
| =Z_ORDER_ACKNOWLEDGEMENT_EMAIL | AP | - |
| =ORDER_CONFIRMATION | AP | - |
| =ORDER_CONFIRMATION | AG | - |
| =ORDER_CONFIRMATION_CHANGE | AG | - |
| =CASH_SALE | RE | - |
| =CASH_SALE_CHANGE | RE | - |
| =SALES_INQUIRY | AG | - |
| =SALES_INQUIRY_CHANGE | AG | - |
| =SALES_QUOTATION | AG | - |
| =SALES_QUOTATION_CHANGE | AG | - |
| =SALES_CONTRACT | AG | - |
| =SALES_CONTRACT_CHANGE | AG | - |
| =CUSTOMER_RETURN | AG | - |
| =CUSTOMER_RETURN_CHANGE | AG | - |
| =ORDER_WO_CHARGE | AG | - |
| =ORDER_WO_CHARGE_CHANGE | AG | - |
| =DEBIT_MEMO_REQUEST | ZM | - |
| =DEBIT_MEMO_REQUEST_CHANGE | ZM | - |
| =CREDIT_MEMO_REQUEST | ZM | - |
| =CREDIT_MEMO_REQUEST_CHANGE | ZM | - |
DT__CHANNEL:
DCT Rules:
| Name | Description(Text) | Result Column | Type | Binding | Length | Decimals | Only Positive | Only Uppercase | Timepoint Type | Dimension Key |
| OUTPUT_TYPE | Output Type | Element (Text ) | APOC_OUTPUT_TYPE | 30 | 0 | X | ||||
| ROLE | Role | Element (Text ) | APOC_ROLE_CODE | 2 | 0 | X | ||||
| SALESORGANIZATION | Sales Org. | Element (Text ) | VKORG | 4 | 0 | X | ||||
| DISTRIBUTIONCHANNEL | Distr. Channel | Element (Text ) | VTWEG | 2 | 0 | X | ||||
| ORGANIZATIONDIVISION | Division | Element (Text ) | SPART | 2 | 0 | X | ||||
| SALESOFFICE | Sales Office | Element (Text ) | VKBUR | 4 | 0 | X | ||||
| BUSINESS_PARTNER_ID | Recipient | Element (Text ) | APOC_RECEIVER_ID | 10 | 0 | X | ||||
| SALESDOCUMENTTYPE | Sales Doc. Type | Element (Text ) | AUART | 4 | 0 | X | ||||
| OVRLITMGENERALINCOMPLETIONSTS | All Items | Element (Text ) | UVALL_SU | 1 | 0 | X | ||||
| CHANNEL | Channel | X | Element (Text ) | APOC_CHANNEL | 5 | 0 | X | |||
| EXCLUSIVE_IND | Exclusive Indicator | X | Element (Text ) | APOC_EXCLUSIVE_INDICATOR | 1 | 0 | X |
DCT Template:
| Output Type | Role | Sales Org. | Distr. Channel | Division | Sales Office | Recipient | Sales Doc. Type | All Items | Channel | Exclusive Indicator |
| =Z_ORDER_ACKNOWLEDGEMENT_EMAIL | - | |||||||||
| =ORDER_CONFIRMATION | =AP | - | ||||||||
| =ORDER_CONFIRMATION | =AG | - | ||||||||
| =ORDER_CONFIRMATION | =AG | =1001 | =OR | EDI | - | |||||
| =ORDER_CONFIRMATION | =AG | - | ||||||||
| =ORDER_CONFIRMATION_CHANGE | - | |||||||||
| =CASH_SALE | - |
DT__EMAIL_RECEIVER:
DCT Rules:
| Name | Description(Text) | Result Column | Type | Binding | Length | Decimals | Only Positive | Only Uppercase | Timepoint Type | Dimension Key |
| OUTPUT_TYPE | Output Type | Element (Text ) | APOC_OUTPUT_TYPE | 30 | 0 | X | ||||
| ROLE | Role | Element (Text ) | APOC_ROLE_CODE | 2 | 0 | X | ||||
| EMAIL_ROLE | Email Type Code | X | Element (Text ) | APOC_EMAIL_ROLE_CODE | 5 | 0 | X | |||
| EMAIL_URI | E-Mail Address | X | Element (Text ) | AD_SMTPADR | 241 | 0 |
DCT Template:
| Output Type | Role | Email Role | Email URI |
| =Z_ORDER_ACKNOWLEDGEMENT_EMAIL | =AP | TO | |
| =ORDER_CONFIRMATION | =AP | TO | |
| =ORDER_CONFIRMATION | =AG | TO |
DT__EMAIL_SETTING:
DCT Rules:
| Name | Description(Text) | Result Column | Type | Binding | Length | Decimals | Only Positive | Only Uppercase | Timepoint Type | Dimension Key |
| OUTPUT_TYPE | Output Type | Element (Text ) | APOC_OUTPUT_TYPE | 30 | 0 | X | ||||
| ROLE | Role | Element (Text ) | APOC_ROLE_CODE | 2 | 0 | X | ||||
| SALESORGANIZATION | Sales Org. | Element (Text ) | VKORG | 4 | 0 | X | ||||
| DISTRIBUTIONCHANNEL | Distr. Channel | Element (Text ) | VTWEG | 2 | 0 | X | ||||
| ORGANIZATIONDIVISION | Division | Element (Text ) | SPART | 2 | 0 | X | ||||
| SALESOFFICE | Sales Office | Element (Text ) | VKBUR | 4 | 0 | X | ||||
| EMAIL_FROM | Sender Email | X | Element (Text ) | APOC_SENDER_EMAIL_ADDR | 241 | 0 | ||||
| EMAIL_TEMPLATE_ID | Email Template | X | Element (Text ) | APOC_EMAIL_TEMPLATE | 30 | 0 | X |
DCT Template:
| Output Type | Role | Sales Org. | Distr. Channel | Division | Sales Office | Sender Email | Email Template |
| =ORDER_CONFIRMATION | =AG | =1001 | jatin.somaiya-ext@syensqo.com | SD_SLS_DEFAULT_EMAIL_TEMPLATE | |||
| =ORDER_CONFIRMATION | =1001 | jatin.somaiya-ext@syensqo.com | SD_SLS_DEFAULT_EMAIL_TEMPLATE | ||||
| =Z_ORDER_ACKNOWLEDGEMENT_EMAIL | =AP | jatin.somaiya-ext@syensqo.com | SD_SLS_DEFAULT_EMAIL_TEMPLATE |
DT__OUTPUT_RELEVANCE: DCT Rules:
| Name | Description(Text) | Result Column | Type | Binding | Length | Decimals | Only Positive | Only Uppercase | Timepoint Type | Dimension Key |
| OUTPUT_TYPE | Output Type | Element (Text ) | APOC_OUTPUT_TYPE | 30 | 0 | X | ||||
| OVERALLPURCHASECONFSTATUS | Purg Conf. Sts | Element (Text ) | COSTA_D | 1 | 0 | X | ||||
| HDRGENERALINCOMPLETIONSTATUS | Overall Header | Element (Text ) | UVALL_UK | 1 | 0 | X | ||||
| TOTALCREDITCHECKSTATUS | OverallCredStat | Element (Text ) | CMGST | 1 | 0 | X | ||||
| DELIVERYBLOCKREASON | Delivery Block | Element (Text ) | LIFSK | 2 | 0 | X | ||||
| HEADERBILLINGBLOCKREASON | Billing Block | Element (Text ) | FAKSK | 2 | 0 | X | ||||
| OVRLITMGENERALINCOMPLETIONSTS | All Items | Element (Text ) | UVALL_SU | 1 | 0 | X | ||||
| RELEVANCE_IND | Relevance Indicator | X | Element (Text ) | APOC_RELEVANCE_INDICATOR | 1 | 0 | X | |||
| OVRLITMGENERALINCOMPLETIONSTS | All Items | Element (Text ) | UVALL_SU | 1 | 0 | X | ||||
| CHANNEL | Channel | X | Element (Text ) | APOC_CHANNEL | 5 | 0 | X | |||
| EXCLUSIVE_IND | Exclusive Indicator | X | Element (Text ) | APOC_EXCLUSIVE_INDICATOR | 1 | 0 | X |
DT__OUTPUT_RELEVANCE: DCT Template:
| Output Type | Purg Conf. Sts | Overall Header | OverallCredStat | Delivery Block | Billing Block | All Items | Relevance Indicator | All Items | Channel | Exclusive Indicator |
| =Z_ORDER_ACKNOWLEDGEMENT_EMAIL | =" " | " " | - | |||||||
| =ORDER_CONFIRMATION | =C ; =" " | =C | contains not any 'BC' | is initial | =C | X | - | |||
| =ORDER_CONFIRMATION_CHANGE | =C ; =" " | =C | contains not any 'BC' | is initial | =C | X | - | |||
| =CASH_SALE | =C | contains not any 'BC' | is initial | is initial | X | EDI | - | |||
| =CASH_SALE_CHANGE | =C | contains not any 'BC' | is initial | is initial | X | - | ||||
| =SALES_INQUIRY | =C | X | - | |||||||
| =SALES_INQUIRY_CHANGE | =C | X | - | |||||||
| =SALES_QUOTATION | =C | X | - | |||||||
| =SALES_QUOTATION_CHANGE | =C | X | ||||||||
| =SALES_CONTRACT | =C | X | ||||||||
| =SALES_CONTRACT_CHANGE | =C | X | ||||||||
| =CUSTOMER_RETURN | =C | contains not any 'BC' | is initial | X | ||||||
| =CUSTOMER_RETURN_CHANGE | =C | contains not any 'BC' | is initial | X | ||||||
| =ORDER_WO_CHARGE | =C ; =" " | =C | contains not any 'BC' | is initial | X | |||||
| =ORDER_WO_CHARGE_CHANGE | =C ; =" " | =C | contains not any 'BC' | is initial | X | |||||
| =DEBIT_MEMO_REQUEST | =C | contains not any 'BC' | is initial | X | ||||||
| =DEBIT_MEMO_REQUEST_CHANGE | =C | contains not any 'BC' | is initial | X | ||||||
| =CREDIT_MEMO_REQUEST | =C | contains not any 'BC' | is initial | X | ||||||
| =CREDIT_MEMO_REQUEST_CHANGE | =C | contains not any 'BC' | is initial | X | ||||||
| =SEPA_MANDATE | =C | X |
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Source System Availability
| Syensqo IT |
| 2 | Data Structure
| Synithi |
| 3 | Referential Integrity
| Synithi |
| 4 | Extraction Methodology
| Synithi |
| 5 | Performance and Scalability Considerations
| Synithi |
| 6 | Security and Compliance
| Synithi |
Transformation
The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow to make the data Target ready:
- Perform value mapping and data transformation rules.
- Legacy values are mapped to the to-be values (this could include a default value)
- Values are transformed according to the rules defined in
- Prepare target ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Preload Data Validation
Transformation Run Sheet
| Item # | Step Description | Team Responsible |
|---|---|---|
| Finalized mapping document approved by Functional and Business teams. | ||
| Completion of source data extraction and cleansing. | ||
| Availability of default values for S/4 mandatory fields. | ||
Transformation Rules
Please note that there is no direct mapping between the condition types and the BRF+ output types. The table below will simply contain the list of legacy output types and how they would have been mapped if all conditions were migrated. Please note that all conditions no longer associated to V1have been excluded
| Application | Condition Type | Condition type Name | Cond type | BRF+ Output Type | ||
| V1 | BA00 | Order Confirmation | BA00 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | BA00 | Order Confirmation | BA00 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZAAR | Archive Ord Con Aero | ZAAR Archive Ord Con Aero | ORDER_CONFIRMATION | ||
| V1 | ZAAR | Archive Ord Con Aero | ZAAR Archive Ord Con Aero | ORDER_CONFIRMATION | ||
| V1 | ZAAR | Archive Ord Con Aero | ZAAR Archive Ord Con Aero | ORDER_CONFIRMATION | ||
| V1 | ZAN0 | Quotation | ZAN0 Quotation | SALES_QUOTATION | ||
| V1 | ZAN0 | Quotation | ZAN0 Quotation | SALES_QUOTATION | ||
| V1 | ZAN0 | Quotation | ZAN0 Quotation | SALES_QUOTATION | ||
| V1 | ZAN1 | Quotation | ZAN1 Quotation | SALES_QUOTATION | ||
| V1 | ZAN1 | Quotation | ZAN1 Quotation | SALES_QUOTATION | ||
| V1 | ZAN1 | Quotation | ZAN1 Quotation | SALES_QUOTATION | ||
| V1 | ZAN1 | Quotation | ZAN1 Quotation | SALES_QUOTATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARC | PDF by mail | ZARC PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARD | PDF by mail | ZARD PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARD | PDF by mail | ZARD PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARD | PDF by mail | ZARD PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARD | PDF by mail | ZARD PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARD | PDF by mail | ZARD PDF by mail | ORDER_CONFIRMATION | ||
| V1 | ZARE | Order Confirm Aero | ZARE Order Confirm Aero | ORDER_CONFIRMATION | ||
| V1 | ZARE | Order Confirm Aero | ZARE Order Confirm Aero | ORDER_CONFIRMATION | ||
| V1 | ZARE | Order Confirm Aero | ZARE Order Confirm Aero | ORDER_CONFIRMATION | ||
| V1 | ZARE | Order Confirm Aero | ZARE Order Confirm Aero | ORDER_CONFIRMATION | ||
| V1 | ZARM | Order creation Email | ZARM Order creation Email | ORDER_CONFIRMATION | ||
| V1 | ZARM | Order creation Email | ZARM Order creation Email | ORDER_CONFIRMATION | ||
| V1 | ZARM | Order creation Email | ZARM Order creation Email | ORDER_CONFIRMATION | ||
| V1 | ZARM | Order creation Email | ZARM Order creation Email | ORDER_CONFIRMATION | ||
| V1 | ZARM | Order creation Email | ZARM Order creation Email | ORDER_CONFIRMATION | ||
| V1 | ZARM | Order creation Email | ZARM Order creation Email | ORDER_CONFIRMATION | ||
| V1 | ZARM | Order creation Email | ZARM Order creation Email | ORDER_CONFIRMATION | ||
| V1 | ZAWA | EMail to Assistant | ZAWA EMail to Assistant | ORDER_CONFIRMATION | ||
| V1 | ZAWA | EMail to Assistant | ZAWA EMail to Assistant | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA0 | Order Confirmation | ZBA0 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA1 | Order Confirmation | ZBA1 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA1 | Order Confirmation | ZBA1 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA1 | Order Confirmation | ZBA1 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA1 | Order Confirmation | ZBA1 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA1 | Order Confirmation | ZBA1 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA1 | Order Confirmation | ZBA1 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA1 | Order Confirmation | ZBA1 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA2 | Order Confirmation | ZBA2 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA2 | Order Confirmation | ZBA2 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA2 | Order Confirmation | ZBA2 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA2 | Order Confirmation | ZBA2 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA2 | Order Confirmation | ZBA2 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA2 | Order Confirmation | ZBA2 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA2 | Order Confirmation | ZBA2 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA3 | Order confirm PDF A4 | ZBA3 Order confirm PDF A4 | ORDER_CONFIRMATION | ||
| V1 | ZBA5 | Order Confirmation | ZBA5 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA5 | Order Confirmation | ZBA5 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA5 | Order Confirmation | ZBA5 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA6 | Order Confirmation | ZBA6 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA6 | Order Confirmation | ZBA6 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA6 | Order Confirmation | ZBA6 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA7 | Order Confirmation | ZBA7 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA7 | Order Confirmation | ZBA7 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA8 | Order Confirmation | ZBA8 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA8 | Order Confirmation | ZBA8 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA8 | Order Confirmation | ZBA8 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZBA9 | Order acknoled Asia | ZBA9 Order acknoled Asia | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZBA9 | Order acknoled Asia | ZBA9 Order acknoled Asia | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZBA9 | Order acknoled Asia | ZBA9 Order acknoled Asia | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZBA9 | Order acknoled Asia | ZBA9 Order acknoled Asia | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZBA9 | Order acknoled Asia | ZBA9 Order acknoled Asia | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZBA9 | Order acknoled Asia | ZBA9 Order acknoled Asia | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZBAC | EP Contract - Asia | ZBAC EP Contract - Asia | SALES_CONTRACT | ||
| V1 | ZBAC | EP Contract - Asia | ZBAC EP Contract - Asia | SALES_CONTRACT | ||
| V1 | ZBAC | EP Contract - Asia | ZBAC EP Contract - Asia | SALES_CONTRACT | ||
| V1 | ZBAC | EP Contract - Asia | ZBAC EP Contract - Asia | SALES_CONTRACT | ||
| V1 | ZBAC | EP Contract - Asia | ZBAC EP Contract - Asia | SALES_CONTRACT | ||
| V1 | ZBAR | Archive Ord.Conf. | ZBAR Archive Ord.Conf. | ORDER_CONFIRMATION | ||
| V1 | ZBAR | Archive Ord.Conf. | ZBAR Archive Ord.Conf. | ORDER_CONFIRMATION | ||
| V1 | ZBAR | Archive Ord.Conf. | ZBAR Archive Ord.Conf. | ORDER_CONFIRMATION | ||
| V1 | ZBDC | Offer Sheet KOMC | ZBDC Offer Sheet KOMC | |||
| V1 | ZBSC | Ord.Confirmation GTC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | ||
| V1 | ZBSC | Ord.Confirmation GTC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | ||
| V1 | ZBSC | Ord.Confirmation GTC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | ||
| V1 | ZBSC | Ord.Confirmation GTC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | ||
| V1 | ZBSC | Ord.Confirmation GTC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | ||
| V1 | ZBSC | Ord.Confirmation GTC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | ||
| V1 | ZBSC | Ord.Confirmation GTC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | ||
| V1 | ZCQ1 | Contract | ZCQ1 Contract | SALES_CONTRACT | ||
| V1 | ZCQ1 | Contract | ZCQ1 Contract | SALES_CONTRACT | ||
| V1 | ZCQR | Archive Contract | ZCQR Archive Contract | SALES_CONTRACT | ||
| V1 | ZCSC | Contract with GTC | ZCSC Contract with GTC | SALES_CONTRACT | ||
| V1 | ZCSC | Contract with GTC | ZCSC Contract with GTC | SALES_CONTRACT | ||
| V1 | ZDLB | Mail delivery blocka | ZDLB Mail delivery blocka | |||
| V1 | ZDOC | Document creation | ZDOC Document creation | |||
| V1 | ZLRG | Regen DMR Conf. | ZLRG Regen DMR Conf. | ORDER_CONFIRMATION | ||
| V1 | ZMCE | Mail creat cmd EDI | ZMCE Mail creat cmd EDI | ORDER_CONFIRMATION | ||
| V1 | ZMRC | eOrd. Conf. to Cust. | ZMRC eOrd. Conf. to Cust. | ORDER_CONFIRMATION | ||
| V1 | ZMRC | eOrd. Conf. to Cust. | ZMRC eOrd. Conf. to Cust. | ORDER_CONFIRMATION | ||
| V1 | ZMRC | eOrd. Conf. to Cust. | ZMRC eOrd. Conf. to Cust. | ORDER_CONFIRMATION | ||
| V1 | ZMRC | eOrd. Conf. to Cust. | ZMRC eOrd. Conf. to Cust. | ORDER_CONFIRMATION | ||
| V1 | ZMRC | eOrd. Conf. to Cust. | ZMRC eOrd. Conf. to Cust. | ORDER_CONFIRMATION | ||
| V1 | ZMRC | eOrd. Conf. to Cust. | ZMRC eOrd. Conf. to Cust. | ORDER_CONFIRMATION | ||
| V1 | ZMRM | eOrd. Ackn. To Cust | ZMRM eOrd. Ackn. To Cust | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZMRM | eOrd. Ackn. To Cust | ZMRM eOrd. Ackn. To Cust | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZMRM | eOrd. Ackn. To Cust | ZMRM eOrd. Ackn. To Cust | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZMRM | eOrd. Ackn. To Cust | ZMRM eOrd. Ackn. To Cust | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZMRM | eOrd. Ackn. To Cust | ZMRM eOrd. Ackn. To Cust | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZMRM | eOrd. Ackn. To Cust | ZMRM eOrd. Ackn. To Cust | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZPI1 | Monitoring 1er order | ZPI1 Monitoring 1er order | |||
| V1 | ZPL1 | scheduling agreement | ZPL1 scheduling agreement | ORDER_CONFIRMATION | ||
| V1 | ZPL1 | scheduling agreement | ZPL1 scheduling agreement | ORDER_CONFIRMATION | ||
| V1 | ZPL1 | scheduling agreement | ZPL1 scheduling agreement | ORDER_CONFIRMATION | ||
| V1 | ZRC3 | Ack.Ord.EDI (V2 SYC) | ZRC3 Ack.Ord.EDI (V2 SYC) | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZRS2 | ORD RESP APRIS INDEN | ZRS2 ORD RESP APRIS INDEN | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZRSP | Ack.Ord.EDI (V2 SYC) | ZRSP Ack.Ord.EDI (V2 SYC) | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZRSP | Ack.Ord.EDI (V2 SYC) | ZRSP Ack.Ord.EDI (V2 SYC) | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZRST | Tech.Ack.ord EDI(V2) | ZRST Tech.Ack.ord EDI(V2) | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZRST | Tech.Ack.ord EDI(V2) | ZRST Tech.Ack.ord EDI(V2) | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZSTC | AERO O.F reject STO | ZSTC AERO O.F reject STO | |||
| V1 | ZSTO | AERO Overf whse STO | ZSTO AERO Overf whse STO | |||
| V1 | ZSTO | AERO Overf whse STO | ZSTO AERO Overf whse STO | |||
| V1 | ZSY2 | ORDRSP to PO. SYC | ZSY2 ORDRSP to PO. SYC | |||
| V1 | ZSYC | ORDRSP to SYCOMORE | ZSYC ORDRSP to SYCOMORE | |||
| V1 | ZTP1 | TP - Mail creat | ZTP1 TP - Mail creat | |||
| V1 | BA00 | Order Confirmation | BA00 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC10 | Order Confirmation | ZC10 Order Confirmation | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC11 | Order Conf. (Copy C) | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | ||
| V1 | ZC12 | Order Conf. (I.Copy) | ZC12 Order Conf. (I.Copy) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC13 | Order Conf. (No Pr.) | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | ||
| V1 | ZC14 | Order Conf. (T) | ZC14 Order Conf. (T) | ORDER_CONFIRMATION | ||
| V1 | ZC14 | Order Conf. (T) | ZC14 Order Conf. (T) | ORDER_CONFIRMATION | ||
| V1 | ZC14 | Order Conf. (T) | ZC14 Order Conf. (T) | ORDER_CONFIRMATION | ||
| V1 | ZC15 | Contract | ZC15 Contract | SALES_CONTRACT | ||
| V1 | ZC15 | Contract | ZC15 Contract | SALES_CONTRACT | ||
| V1 | ZC15 | Contract | ZC15 Contract | SALES_CONTRACT | ||
| V1 | ZC15 | Contract | ZC15 Contract | SALES_CONTRACT | ||
| V1 | ZC15 | Contract | ZC15 Contract | SALES_CONTRACT | ||
| V1 | ZC16 | Contract (Copy Cu.) | ZC16 Contract (Copy Cu.) | SALES_CONTRACT | ||
| V1 | ZC16 | Contract (Copy Cu.) | ZC16 Contract (Copy Cu.) | SALES_CONTRACT | ||
| V1 | ZC17 | Order Conf. One Time | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | ||
| V1 | ZC17 | Order Conf. One Time | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | ||
| V1 | ZC17 | Order Conf. One Time | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | ||
| V1 | ZC17 | Order Conf. One Time | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | ||
| V1 | ZC17 | Order Conf. One Time | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | ||
| V1 | ZC17 | Order Conf. One Time | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | ||
| V1 | ZC17 | Order Conf. One Time | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | ||
| V1 | ZC19 | Order Conf. Manual | ZC19 Order Conf. Manual | ORDER_CONFIRMATION | ||
| V1 | ZC19 | Order Conf. Manual | ZC19 Order Conf. Manual | ORDER_CONFIRMATION | ||
| V1 | ZC19 | Order Conf. Manual | ZC19 Order Conf. Manual | ORDER_CONFIRMATION | ||
| V1 | ZC19 | Order Conf. Manual | ZC19 Order Conf. Manual | ORDER_CONFIRMATION | ||
| V1 | ZC19 | Order Conf. Manual | ZC19 Order Conf. Manual | ORDER_CONFIRMATION | ||
| V1 | ZC19 | Order Conf. Manual | ZC19 Order Conf. Manual | ORDER_CONFIRMATION | ||
| V1 | ZC2B | B2B Message | ZC2B B2B Message | |||
| V1 | ZC2B | B2B Message | ZC2B B2B Message | |||
| V1 | ZC2B | B2B Message | ZC2B B2B Message | |||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCAR | Acknowled. Receipt | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCER | Certificate of Origi | ZCER Certificate of Origi | |||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOE | Order Acknowledgment | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZCOF | Order Ackn.ment-S2 | ZCOF Order Ackn.ment-S2 | Z_ORDER_ACKNOWLEDGEMENT_EMAIL | ||
| V1 | ZTP1 | TP - Mail creat | ZTP1 TP - Mail creat |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
PreLoad Validation
Project Team
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Business
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Load
The load process includes:
- Execute the automated data load into target system using load tool or product the load file if the load must be done manually
- Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation
Load Run Sheet
| Item # | Step Description | Team Responsible |
|---|---|---|
Load Phase and Dependencies
Configuration
| Item # | Configuration Item |
|---|---|
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram) | |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
PostLoad Validation
Project Team
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Business
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Key Assumptions
- Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
- is in scope based on data design and any exception requested by business.