| Status | Approved |
|---|---|
| Owner | |
| Stakeholders |
Purpose
This document defines the conversion approach for migrating Sales (V1) and Billing (V3) output condition records from SAP ECC to SAP S/4HANA, based on a new BRF+-driven output management strategy.
This document introduces a new approach to migrating output management, shifting from the legacy ECC output condition record model to a simplified, rules-driven BRF+ framework. It describes the end-to-end migration process, covering data extraction (via Syniti), functional transformation (advised by the Functional Team), and loading into BRF+ decision tables (by the functional team)—ensuring alignment with overall project governance and design principles.
New 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.
- Global template layout per output type (as much as possible)
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. This approach requires that the relevant attributes be maintained during Business Partner migration, aligned with the existing output conditions.
Key Implications:
There will be no direct one-to-one mapping between ECC output condition records and BRF+ decision tables. Instead, this approach will use a rules-based model that covers the majority of business scenarios and reduces operational complexity.
The new model will establish and maintain output determination records—including email recipients, output channels, and Business Partner–related conditions—within BRF+.
The transformation builds upon the configuration and master data currently maintained under the Classic Output Management (NAST framework) in ECC, adapting it to the BRF+ governance structure in S/4HANA.
Note:
this document
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;
- Mapping of Classic condition record keys (application, condition type, key combination) to BRF+ OPD parameters (e.g., Document Type, Output Type, Sales Organization,);
- 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;
- 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
- Active records where the deletion indicator (LOEKZ) is initial.
- 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., LE, MM, FI outputs)
Data Profiling
List of source systems and approximate number of records for tables for tables in use
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 | S4/OPD | |
| 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 | 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 | ||
| 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 | FUPI/RD00/RD02/RD04/ZFC1/ZINV/ZRD3/ZRD7 /ZRDA/ZRDB/ | 952 | ||
| WQ2 | V3 | 008 | Billing Type | ZLO1/ZLOT/ZPI3/ZQBC/ZQCA/ZRAR/ZREJ/ | 39 | ||
| WQ2 | V3 | 011 | Sales Organization/Billing Type | ZBA1/ZEID/ZEIG/ZEII/ZGST/ZPLD/ZRAC/ZRAR/ZRB0/ZRB1/ZRD0/ZRD1 /ZRD2/ZRD8/ZRDE/ZRDP/ZRDQ/ZRLA/ZRLR/ZRS1/ZRS2/ZRSC/ZRUP/ | 411 | ||
| WQ2 | V3 | 013 | Sales Org. | RD04/ZFMX/ZRAR/ZRD3/ZRD5/ZRD7/ZRMX/ZRS5/ | 9 | ||
| WQ2 | V3 | 504 | Sales organization/ Shipping point | ZRD4/ZRD5/ZRD6/ZRDD/ZRN5/ZRN6/ZRS5/ZRS6/ | 1 | ||
| WQ2 | V3 | 505 | Sales organization/Shipping point/Bill-to party | ZRD6/ZRN6/ZRS6/ | 3 | ||
| WQ2 | V3 | 507 | Sales organization/Sales office/Bill-to party | ZGST/ZLIF/ZLIP/ZRAR/ZRB0/ZRD0/ZRD1/ZRD2/ZRD8/ZRDE/ZRDP/ZREJ/ZRS1/ZRS2/ZRSC/ | 163 | ||
| WQ2 | V3 | 511 | Sales organization/Sales office | ZLIF/ZLIP/ZRAR/ZRB0/ZRD0/ZRD1/ZRD2/ZRD8/ZRDE/ZRDP/ZRDQ/ZRS1/ZRS2/ZRSC/ | 53 | ||
| WQ2 | V3 | 512 | Sales organization/Sales office/Commercial assistant | ZCOR/ZPLD/ZRB0/ZRB1/ZRD0/ZRD1/ZRD2/ZRD5/ZRDE/ ZRDP/ZRDQ/ZRS1/ZRS2/ZRS5/ZRSC/ | 47 | ||
| WQ2 | V3 | 533 | Sales Org/Distribution Channel/Sales Office | ZRD6/ZRN6/ZRS6/ | 5 | ||
| WQ2 | V3 | 539 | Sales org./Sales Off./Created/Bill. Type | ZPLD/ZRB0/ZRB1/ZRD0/ZRD1/ZRD2/ZRD8/ZRDE/ZRS1/ZRSC/ | 1 | ||
| WQ2 | V3 | 551 | Sales org./Doc.cat./Sales Off./Bill to | ZINV/ZRDC/ZREI/ZRWF/ | 79 | ||
| WQ2 | V3 | 552 | Sales org./Sales Off./Doc.cat./SalesDocTy/e-inv. flag | ZRDC/ZRWF/ | 788 | ||
| WQ2 | V3 | 553 | Sales Off./Doc.cat./e-inv. flag | ZREI/ZRWF/ | 85 | ||
| WQ2 | V3 | 554 | Sales org./Sales Off./Doc.cat./e-inv. flag | ZRDC/ZREI/ZRWF/ | 673 | ||
| WQ2 | V3 | 558 | Sales Organization/Sales Office/Billing Type | ZRAC/ZRB0/ZRDE/ZRSC/ | 106 | ||
| WQ2 | V3 | 560 | Sales Off./e-inv. flag | ZRDC/ZREI/ | 6 | ||
| WQ2 | V3 | 569 | Sales org./Currency/Plant/Bill. Type | ZRAR/ZRB0/ZRD0/ZRD3/ZRDE/ZREJ/ZRLA/ZRN5/ZRS2/ZRSC/ | 11 | ||
| WQ2 | V3 | 570 | Sales org./Currency/Bill. Type | ZGSU/ZPLD/ZRAR/ZRD5/ZRD8/ZRDE/ZREJ/ | 6 | ||
| WQ2 | V3 | 572 | Sales org./Distr. Chl/Bill. Type/Sold-To Pt | ZGST/ZRB0/ZRDE/ZRSC/ | 21 | ||
| WQ2 | V3 | 889 | Sales org./Sold-to pt | ZRDC/ZRWF/ | 27 | ||
| WQ2 | V3 | 910 | Interco. billing: Org.comm./Bill-to | ZGST/ZRB0/ZRD0/ZRD1/ZRD5/ZRD8/ZRDE/ZRDQ/ZRLA/ZRLR/ZRN5/ZRS5/ZRSC/ | 37 | ||
| WQ2 | V3 | 923 | Sales Organization/Distribution Channel/Bill-to party | ZGST/ZLIF/ZRB0/ZRD0/ZRD5/ZRDE/ZRS1/ZRS5/ZRSC/ | 51 | ||
| WQ2 | V3 | 953 | Sales org./Bill.type/Payer | ZRDA/ZRGE/ | 84 | ||
| WQ2 | V3 | 955 | Sales org./Ship.point/Bill.type/RecipCntry | ZRM6/ | 6541 | ||
| WQ2 | V3 | 957 | Sales organization/Billing type/Bill-to party | ZINV/ZRD5/ZRDA/ZRDB/ZRS5/ | 7326 | ||
| WQ2 | V3 | 960 | e-invoicing | ZRAR/ZREJ/ZRS2/ | 1 | ||
| WQ2 | V3 | 962 | Sales Organization/Distribution Channel/Billing Type/Ship-to | ZLIF/ZRB0/ZRD0/ZRDE/ZRGE/ZRS1/ZRSC/ | 72 | ||
| WQ2 | V3 | 995 | Sales Org/Sales Office/Billing Type/Dest country | ZRDE/ZRS2/ | 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 | 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 | ||
| 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 | FUPI/RD00/RD02/RD04/ZFC1/ZINV/ZRD3/ZRD7/ZRDA/ZRDB/ | 2966 | ||
| QF2 | V3 | 006 | SOrg./Distrib.Ch/Division/Customer | RD04 | 387 | ||
| QF2 | V3 | 008 | Billing Type | ZQBC | 2 | ||
| QF2 | V3 | 011 | Sales Organization/Billing Type | ZBA1/ZEID/ZEIG/ZEII/ZGST/ZPLD/ZRAC/ZRAR/ZRB0/ZRB1/ZRD0/ZRD1/ZRD2/ZRD8/ ZRDE/ZRDP/ZRDQ/ZRLA/ZRLR/ZRS1/ZRS2/ZRSC/ZRUP/ | 195 | ||
| QF2 | V3 | 013 | Sales Org. | RD04/ZFMX/ZRAR/ZRD3/ZRD5/ZRD7/ZRMX/ZRS5/ | 63 | ||
| QF2 | V3 | 840 | Sales office / Sold-to Doc type / Billing Type | ZF00/ | 35 | ||
| QF2 | V3 | 841 | Sales office / Sold-to Doc type | ZF00/ZF0R/ZF1R/ | 122 | ||
| QF2 | V3 | 913 | Sales office | ZF00/ZF01/ZF05/ZFCF/ | 110 | ||
| QF2 | V3 | 916 | Bill-to party | ZF01/ | 2 | ||
| QF2 | V3 | 919 | Sales office/Bill-to party/Billing type | ZF00/ZF01/ZF30/ | 1332 | ||
| QF2 | V3 | 920 | Bill.type/Sales org./RecipCntry | ZF00/ZF01/ | 14 | ||
| QF2 | V3 | 921 | Sales office/Bill-to party | ZF00/ZF01/ZF05/ZF10/ | 14365 | ||
| QF2 | V3 | 927 | Billing type/Bill-to party | RD06/ZF06/ZF17/ | 72 | ||
| QF2 | V3 | 932 | Payer | ZF00/ | 192 | ||
| QF2 | V3 | 935 | Sales organization/Shipping point/Billing type | ZF15/ZF16/ | 69 | ||
| QF2 | V3 | 937 | Payer/Billing type | ZF00/ZF01/ | 986 | ||
| QF2 | V3 | 939 | Sales office/Manual invoice maintenance | ZF00/ZF01/ZF05/ | 28 | ||
| QF2 | V3 | 940 | Sales office/Bill-to party/Manual invoice maintenance | ZF01/ | 46 | ||
| QF2 | V3 | 942 | Sales office/Country (Bill-to party) | ZF00/ZF01/ZF05/ZF10/ | 271 | ||
| QF2 | V3 | 953 | Sales office/Sales group | ZF00/ZF01/ | 72 | ||
| QF2 | V3 | 958 | Sales off./Sales org./Bill.type | ZF00/ | 71 | ||
| QF2 | V3 | 963 | Sales org./Contact agent/Bill.type | ZFCA/ | 1056 | ||
| QF2 | V3 | 966 | Sales org./Payer/Bill.type | ZF00/ZF01/ZF02/ZFCF/ZFMX/ | 32553 | ||
| QF2 | V3 | 967 | Sales Organization/PO type/Sold-to party | ZF2B/ | 1 | ||
| QF2 | V3 | 973 | Bill.type/Sales org./RecipCntry/Payer | ZF01/ZF99/ | 96 | ||
| QF2 | V3 | 974 | Sales organization/Billing type/Bill-to party | RD06/ZF15/ZF16/ZF17/ZFIL/ZFIM/ | 1882 | ||
| QF2 | V3 | 975 | Sales organization/Billing type/Delivering country | ZF15/ | 23 | ||
| QF2 | V3 | 985 | Sales organization/Sold-to party | 11 | |||
| QF2 | V3 | 993 | Sales Organization/Billing Type/Destination Country | ZF15/ | 16 | ||
| QF2 | V3 | 998 | Sales organization/Payer | ZFIL/ | 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 (Email, Print, EDI, IDoc)
- Form Template (Adobe Form)
- Receiver (Partner Function)
- Language
The decision tables below depict the typical structures of BRF+ tables and are based on the current design within the Toolkit. Please note that these tables are for demonstration purposes and will change once the final design has been confirmed.
SALES DECISION TABLES:
| 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 | Input Parameter 10 | 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 | ||||
| DT_FORM_TEMPLATE | Output Type | Sales Org | Distribution Channel | Division | Sales Office | Role | Channel | Sender Ctry/Reg | Receiver Ctry/Reg | Receiver Language | Form template | Form Language |
BILLING DECISION TABLES:
| 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 | Input Parameter 10 | Result | Result |
| DT_OUTPUT_TYPE | Document Cat. | Billing Type | Sales Org. | Distr. Channel | Division | Sales Office | Sales Group | Bill to party | Output Type | Dispatch Time | ||
| DT_RECEIVER | Output Type | Partner Role | Exclusive Indicator | |||||||||
| DT_CHANNEL | Output Type | Partner Role | Sales Org. | Distr. Channel | Division | Sales Office | Recipient | Customer Group 5 | Channel | |||
| DT_PRINTER | Output Type | Sales Org. | Distribution Channel | Division | Sales Office | Billing Type | Print Queue | Number of Copies | ||||
| DT_EMAIL_SETTING | Output Type | Partner Role | Sales Org. | Distr. Channel | Division | Sales Office | Billing Type | Sender Email | Email Template | |||
| DT_EMAIL_RECEIVER | Output Type | Partner Role | Email Type Code | E-Mail Address | ||||||||
| DT_FORM_TEMPLATE | Output Type | Sales Org. | Sender Ctry/Reg. | Recipient Ctry/Reg. | Recipient Language | Document Cat. | Billing Type | Form Template | Form Language | |||
| DT_OUTPUT_RELEVANCE | Output Type | Document Category | Posting Status | Billing Type | Sales Org. | Bill to Party | Receiver Ctry/Reg | Relevance Indicator |
Data Cleansing
N/A
| 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 SQL based 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 in scope records.
Extraction Run Sheet: To be provided after the first mock cycle.
This data will not be migrated, it will be used to complete the data collection files based on BRF+ Decision tables setup.
Source Table to be extracted: NACH Table
| Table | Field | Data Element | Data Type | Length | Short Description | Requirement | |
| 1 | NACH | MANDT | MANDT | CLNT | 3 | Client | Mandatory |
| 2 | NACH | KNUMH | NNUMH | CHAR | 10 | Number of output condition record | Mandatory |
| 5 | NACH | KVEWE | KVEWE | CHAR | 1 | Usage of the condition table | Mandatory |
| 6 | NACH | KOTABNR | KOTABNR | CHAR | 3 | Condition table | Mandatory |
| 7 | NACH | KAPPL | KAPPL | CHAR | 2 | Application | Mandatory |
| 8 | NACH | KSCHL | KSCHL_OC | CHAR | 4 | Condition Type | Mandatory |
| 9 | NACH | VAKEY | VAKEY | CHAR | 100 | Variable key 100 bytes | Mandatory |
| 10 | NACH | DATAB | DATAB | DATS | 8 | ValidFrom Date | Optional |
| 11 | NACH | DATBI | DATBI | DATS | 8 | Valid To Date | Optional |
| 12 | NACH | KOSRT | KOSRT | CHAR | 10 | Search term for conditions | Optional |
| 13 | NACH | PARVW | PARVW | CHAR | 2 | Partner Function | Mandatory |
| 14 | NACH | PARNR | NA_PARNR_OC | CHAR | 10 | Message partner | Mandatory |
| 15 | NACH | NACHA | NA_NACHA | CHAR | 1 | Message transmission medium | Mandatory |
| 17 | NACH | VSZTP | NA_VSZTP | CHAR | 1 | Dispatch time | Mandatory |
| 18 | NACH | SPRAS | SPRAS | LANG | 1 | Language Key | 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 | NACH-KVEWE 'B' (Usage Output) NACHK-APPL 'V1' (Application Sales Order) NACH-KOTABNR ( Table: all ) NACH-KSCHL (Output types) NACH-NACHA (Transmission Medium) | |
001 WP2 V3 | NACH-KVEWE 'B' (Usage Output) NACHK-APPL 'V3' (Application Sales Order) NACH-KOTABNR ( Table: all ) NACH-KSCHL (Output types) NACH-NACHA (Transmission Medium) | |
| 001 PF2 V1 | NACH-KVEWE 'B' (Usage Output) NACHK-APPL 'V1' (Application Sales Order) NACH-KOTABNR ( Table: all ) NACH-KSCHL (Output types) NACH-NACHA (Transmission Medium) | |
001 WP2 V3 | NACH-KVEWE 'B' (Usage Output) NACHK-APPL 'V3' (Application Sales Order) NACH-KOTABNR ( Table: all ) NACH-KSCHL (Output types) NACH-NACHA (Transmission Medium) |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| Not applicable |
Data Collection Templates (DCT)
BRF+ provides a built-in feature to download and upload decision tables as Excel files.
Steps:
Go to BRF+ application in transaction BRF+
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 back.
Note:
- Each table must be handled individually.
- The creation of Data collection template must be aligned with BRF+ configurations . For now, the following Templates are based on interim configurations (from S/4HANA sandbox). This will be replaced once the configuration is ready. The same applies to the contents of the DTs, they are here as examples of how the entries look like and will be replaced by real objects .
- DT_OUTPUT_TYPE
- DT_RECEIVER
- DT_OUTPUT_CHANNEL
- DT_EMAIL_SETTING
- DT_EMAIL_RECEIVER
- DT_OUTPUT_RELEVANCE
- DT_FORM_TEMPLATE
SALES DECISION TABLES
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: (Partner)
DCT Rules:
| DT_RECEIVER | ||||||||||
| 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 Name | 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:
| 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 | - |
| =CUSTOMER_RETURN | AG | - |
| =CUSTOMER_RETURN_CHANGE | AG | - |
| =DEBIT_MEMO_REQUEST | ZM | - |
| =DEBIT_MEMO_REQUEST_CHANGE | ZM | - |
| =CREDIT_MEMO_REQUEST | ZM | - |
DT__CHANNEL: (Medium)
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 |
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 | - | ||||
| =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 | ||||||
| =CREDIT_MEMO_REQUEST | =C | contains not any 'BC' | is initial | X |
DT__FORM_TEMPLATE:
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 | ||||
| SALESORGANIZATION | Sales Org | Element (Text ) | 1 | 0 | X | |||||
| DISTRIBUTIONCHANNEL | Distribution Channel | Element (Text ) | 1 | 0 | X | |||||
| DIVISION | Division | Element (Text ) | 1 | 0 | X | |||||
| SALESOFFICE | Sales Office | Element (Text ) | 2 | 0 | X | |||||
| ROLE | Role | Element (Text ) | 2 | 0 | X | |||||
| CHANNEL | Channel | Element (Text ) | 1 | 0 | X | |||||
| SENDER_COUNTRY | Sender Ctry/Reg | Element (Text ) | 2 | 0 | X | |||||
| RECEIVER_COUNTRY | Receiver Ctry/Reg | Element (Text ) | 2 | 0 | X | |||||
| RECEIVER_LANGUAGE | Receiver Language | Element (Text ) | 2 | 0 | X | |||||
| FORM_TEMPLATE_NAME | Form template Name | X | Element (Text ) | 0 | X | |||||
| FORM_TEMPLATE_LANGUAGE | Form template Language | X | Element (Text ) |
DCT Template:
| Output Type | Sales Org | Distribution Channel | Division | Sales Office | Role | Channel | Sender Ctry/Reg | Receiver Ctry/Reg | Receiver Language | Form template Name | Form Template Language |
| =Z_ORDER_ACKNOWLEDGEMENT_EMAIL | =" " | " " | X | X |
BILLING DECISION TABLES
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 | |||||
| BILLINGDOCUMENTTYPE | Billing Type | Element (Text ) | FKART | 4 | 0 | X | ||||
| SALESORGANIZATION | Sales Org. | Element (Text ) | VKORG | 4 | 0 | X | ||||
| DISTRIBUTIONCHANNEL | Distr. Channel | Element (Text ) | VTWEG | 2 | 0 | X | ||||
| DIVISION | Division | Element (Text ) | SPART | 2 | 0 | X | ||||
| SALESOFFICE | Sales Office | Element (Text ) | VKGRP | 2 | 0 | X | ||||
| SALESGROUP | Sales Group | Element (Text ) | VKBUR | 4 | 0 | X | ||||
| Bill to party | Bill to party | Element (Text ) | KUNNR | 10 | 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 category | Billing Doc Type | Sales Org | Distribution Channel | Division | Sales Office | Sales Group | Bill-to Partner | Output Type | Dispatch Time |
| X | X |
DT_RECEIVER: (Partner)
DCT Rules:
| DT_RECEIVER | ||||||||||
| 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:
| Output Type | Role | Exclusive Indicator |
DT_CHANNEL: (Medium)
DCT Rules:
| 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 | ||||
| DIVISION | Division | Element (Text ) | SPART | 2 | 0 | X | ||||
| SALESOFFICE | Sales Office | Element (Text ) | 2 | 0 | X | |||||
| BUSINESS_PARTNER_ID | Recipient | Element (Text ) | APOC_RECEIVER_ID | 10 | 0 | X | ||||
| CUSTOMERGROUP5 | Customer Group 5 | Element (Text ) | KDGRP | 2 | 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_PRINTER
DCT Rules:
| 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 | ||||
| SALESORGANIZATION | Sales Org. | Element (Text ) | VKORG | 4 | 0 | X | ||||
| DISTRIBUTIONCHANNEL | Distr. Channel | Element (Text ) | VTWEG | 2 | 0 | X | ||||
| DIVISION | Division | Element (Text ) | SPART | 2 | 0 | X | ||||
| SALESOFFICE | Sales Office | Element (Text ) | 2 | 0 | X | |||||
| BILLINGDOCUMENTTYPE | Billing Type | Element (Text ) | FKART | 4 | 0 | X | ||||
| PRINT_QUEUE_NAME | Print Queue | X | Element (Text ) | APOC_PRINT_QUEUE | 32 | 0 | X | |||
| NUMBER_OF_COPIES | Number of Copies | X | Element (Number ) | APOC_NUMBER_OF_COPIES | 5 | 0 | X |
DT_EMAIL_SETTING
DCT Rules:
| 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 | ||||
| DIVISION | Division | Element (Text ) | SPART | 2 | 0 | X | ||||
| SALESOFFICE | Sales Office | Element (Text ) | 2 | 0 | X | |||||
| BILLINGDOCUMENTTYPE | Billing Type | Element (Text ) | FKART | 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 |
DT_EMAIL_RECEIVER
DCT Rules:
| 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 |
DT_FORM_TEMPLATE: ()
DCT Rules:
| 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 | ||||
| SALESORGANIZATION | Sales Org. | Element (Text ) | VKORG | 4 | 0 | X | ||||
| SENDER_COUNTRY | Sender Ctry/Reg. | Element (Text ) | APOC_SENDER_COUNTRY | 3 | 0 | X | ||||
| RECEIVER_COUNTRY | Recipient Ctry/Reg. | Element (Text ) | APOC_RECEIVER_COUNTRY | 3 | 0 | X | ||||
| RECEIVER_LANGUAGE | Recipient Language | Element (Text ) | APOC_RECEIVER_LANGUAGE | 1 | 0 | |||||
| SDDOCUMENTCATEGORY | Document Cat. | Element (Text ) | VBTYPL | 4 | 0 | |||||
| BILLINGDOCUMENTTYPE | Billing Type | Element (Text ) | FKART | 4 | 0 | X | ||||
| FORM_TEMPLATE_NAME | Form Template | X | Element (Text ) | APOC_FORM_TEMPLATE_ID | 30 | 0 | X | |||
| FORM_TEMPLATE_LANGUAGE | Form Language | X | Element (Text ) | APOC_FORM_TEMPLATE_LANGUAGE | 1 | 0 |
DCT Template:
| Output Type | Sales Org | Sender Country/Reg | Recipient Ctry/Reg. | Recipient Language | Document Cat. | Billing Type | Form template Name | Form Template Language |
| =" " | X | X |
DT_OUTPUT_RELEVANCE: ()
DCT Rules:
| 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 | ||||
| SDDOCUMENTCATEGORY | Document Cat. | Element (Text ) | VBTYPL | 4 | 0 | |||||
| ACCOUNTINGTRANSFERSTATUS | Posting Status | Element (Text ) | RFBSK | 1 | 0 | X | ||||
| BILLINGDOCUMENTTYPE | Billing Type | Element (Text ) | FKART | 4 | 0 | X | ||||
| SALESORGANIZATION | Sales Org. | Element (Text ) | VKORG | 4 | 0 | X | ||||
| Bill to party | Bill to party | Element (Text ) | KUNNR | 10 | 0 | X | ||||
| RECEIVER_COUNTRY | Recipient Ctry/Reg. | Element (Text ) | APOC_RECEIVER_COUNTRY | 3 | 0 | X | ||||
| RELEVANCE_IND | Relevance Indicator | X | Element (Text ) | APOC_RELEVANCE_INDICATOR | 1 | 0 | X |
DCT Template:
| Output Type | Document Cat. | Posting status | Billing Type | sales Org | Bill-to partner | Recipient Ctry/Reg. | Relevance Indicator | All Items | Channel | Exclusive Indicator |
| =" " | " " | - |
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
There will be no transformation on the legacy data. The data will be used to help design / complete the new decision tables in S/4 Hana.
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. | ||
Legacy condition tables setup:
Please note that there is no direct mapping between the output condition types and the BRF+ output types. Not all Communication medium will be used in OPD. The tables below are used as guidelines as how the outputs will be managed in S/4.
Legacy Communication Medium to OPD Channel:
| Application | MEDIUM | CHANNEL |
| V1/V3 | ALE | |
| V1/V3 | EDI | |
| V1/V3 | EXTERNAL SEND | |
| V1/V3 | ||
| V1/V3 | ||
| V1/V3 | SPECIAL FUNCTION |
The table below contains the list of legacy output types and how they would have been mapped if all conditions were migrated. Please also note that conditions no longer associated to V1 have been excluded.
- The number of legacy access sequences per output medium.
- The last 2 column, indicate the number of legacy accesses based on the business partner and the sales office.
| System | Application | Condition Type | Condition type Name | BRF+ Output Type | Distribution (ALE) | EDI | External send | Fax | Print output | Simple Mail | Special function | Access VKBUR | Access KUNNR |
| QF2 | V1 | BA00 | BA00 Order Confirmation | ORDER_CONFIRMATION | 1 | 1 | 1 | ||||||
| QF2 | V1 | ZC10 | ZC10 Order Confirmation | ORDER_CONFIRMATION | 7 | 3 | 7 | 7 | 7 | ||||
| QF2 | V1 | ZC11 | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | 4 | 2 | 6 | 6 | |||||
| QF2 | V1 | ZC13 | ZC13 Order Conf. (No Pr.) | ORDER_CONFIRMATION | 5 | 2 | 2 | 9 | 5 | ||||
| QF2 | V1 | ZC17 | ZC17 Order Conf. One Time | ORDER_CONFIRMATION | 6 | 1 | 7 | 4 | |||||
| QF2 | V1 | ZC19 | ZC19 Order Conf. Manual | ORDER_CONFIRMATION | 5 | 1 | 6 | 4 | |||||
| QF2 | V1 | ZC2B | ZC2B B2B Message | ORDER_CONFIRMATION | 3 | 3 | |||||||
| QF2 | V1 | ZC35 | ZC35 Transmission Letter | ORDER_CONFIRMATION | 2 | 2 | 2 | ||||||
| QF2 | V1 | ZC36 | ZC36 Trans. Letter (C) | ORDER_CONFIRMATION | 2 | 2 | 2 | ||||||
| QF2 | V1 | ZTP1 | ZTP1 TP - Mail creat | ORDER_CONFIRMATION | 1 | ||||||||
| QF2 | V1 | ZCAR | ZCAR Acknowled. Receipt | Z_ORDER_ACKNOWLEDGEMENT | 8 | 1 | 4 | 13 | 5 | ||||
| QF2 | V1 | ZCOE | ZCOE Order Acknowledgment | Z_ORDER_ACKNOWLEDGEMENT | 5 | 1 | 2 | 8 | 6 | ||||
| WQ2 | V1 | ZAAR | ZAAR Archive Ord Con Aero | ORDER_CONFIRMATION | 3 | 1 | |||||||
| WQ2 | V1 | ZARC | ZARC PDF by mail | ORDER_CONFIRMATION | 1 | 1 | 7 | 6 | 3 | ||||
| WQ2 | V1 | ZARD | ZARD PDF by mail | ORDER_CONFIRMATION | 1 | 4 | 3 | ||||||
| WQ2 | V1 | ZARE | ZARE Order Confirm Aero | ORDER_CONFIRMATION | 4 | 2 | |||||||
| WQ2 | V1 | ZARM | ZARM Order creation Email | ORDER_CONFIRMATION | 7 | 4 | 1 | ||||||
| WQ2 | V1 | ZAWA | ZAWA EMail to Assistant | ORDER_CONFIRMATION | 2 | 1 | |||||||
| WQ2 | V1 | ZBA0 | ZBA0 Order Confirmation | ORDER_CONFIRMATION | 3 | 4 | 1 | 6 | 2 | ||||
| WQ2 | V1 | ZBA1 | ZBA1 Order Confirmation | ORDER_CONFIRMATION | 1 | 6 | 4 | 1 | |||||
| WQ2 | V1 | ZBA2 | ZBA2 Order Confirmation | ORDER_CONFIRMATION | 1 | 6 | 5 | 2 | |||||
| WQ2 | V1 | ZBA5 | ZBA5 Order Confirmation | ORDER_CONFIRMATION | 3 | 2 | 1 | ||||||
| WQ2 | V1 | ZBA6 | ZBA6 Order Confirmation | ORDER_CONFIRMATION | 3 | 1 | |||||||
| WQ2 | V1 | ZBA8 | ZBA8 Order Confirmation | ORDER_CONFIRMATION | 3 | 1 | |||||||
| WQ2 | V1 | ZBAR | ZBAR Archive Ord.Conf. | ORDER_CONFIRMATION | 3 | 2 | |||||||
| WQ2 | V1 | ZBSC | ZBSC Ord.Confirmation GTC | ORDER_CONFIRMATION | 1 | 6 | 5 | 1 | |||||
| WQ2 | V1 | ZDOC | ZDOC Document creation | ORDER_CONFIRMATION | 1 | ||||||||
| WQ2 | V1 | ZMRC | ZMRC eOrd. Conf. to Cust. | ORDER_CONFIRMATION | 1 | 5 | 3 | 1 | |||||
| WQ2 | V1 | ZPI1 | ZPI1 Monitoring 1er order | ORDER_CONFIRMATION | 1 | ||||||||
| WQ2 | V1 | ZSTC | ZSTC AERO O.F reject STO | ORDER_CONFIRMATION | 1 | ||||||||
| WQ2 | V1 | ZSTO | ZSTO AERO Overf whse STO | ORDER_CONFIRMATION | 1 | 1 | |||||||
| WQ2 | V1 | ZTP1 | ZTP1 TP - Mail creat | ORDER_CONFIRMATION | 1 | ||||||||
| WQ2 | V1 | ZBA9 | ZBA9 Order acknoled Asia | Z_ORDER_ACKNOWLEDGEMENT | 6 | 4 | 1 | ||||||
| WQ2 | V1 | ZMRM | ZMRM eOrd. Ackn. To Cust | Z_ORDER_ACKNOWLEDGEMENT | 6 | 4 | 1 | ||||||
| WQ2 | V1 | ZRSP | ZRSP Ack.Ord.EDI (V2 SYC) | Z_ORDER_ACKNOWLEDGEMENT | 1 | 1 | 2 | ||||||
| WQ2 | V1 | ZRST | ZRST Tech.Ack.ord EDI(V2) | Z_ORDER_ACKNOWLEDGEMENT | 1 | 1 | 2 | ||||||
| WQ2 | V1 | ZAN0 | ZAN0 Quotation | ||||||||||
| WQ2 | V1 | ZAN1 | ZAN1 Quotation | ||||||||||
| WQ2 | V1 | ZBAC | ZBAC EP Contract - Asia | ||||||||||
| WQ2 | V1 | ZCQR | ZCQR Archive Contract | ||||||||||
| QF2 | V3 | RD00 | RD00 Invoice | 1 | 1 | 1 | 3 | ||||||
| QF2 | V3 | RD04 | RD04 InvoiceReceipt FI IV | 2 | 2 | 1 | 2 | 7 | |||||
| QF2 | V3 | RD06 | RD06 Inv. Bridge ERP/RCS | 2 | 2 | ||||||||
| QF2 | V3 | ZF00 | ZF00 Invoice | 1 | 4 | 13 | 3 | 14 | 1 | 18 | 19 | ||
| QF2 | V3 | ZF01 | ZF01 Invoice (C. Cust.) | 10 | 4 | 12 | 14 | 18 | |||||
| QF2 | V3 | ZF02 | ZF02 Invoice (C. Acc.Dep) | 3 | 3 | 2 | |||||||
| QF2 | V3 | ZF06 | ZF06 Invoice (C.Loc.cur.) | 1 | 1 | ||||||||
| QF2 | V3 | ZF0R | ZF0R Invoice archive | 1 | 1 | ||||||||
| QF2 | V3 | ZF15 | ZF15 Customs/Prof Invoice | 5 | 5 | 2 | |||||||
| QF2 | V3 | ZF16 | ZF16 Export document | 1 | 1 | 1 | |||||||
| QF2 | V3 | ZF17 | ZF17 Customs Invoice (C) | 2 | 1 | 2 | 5 | ||||||
| QF2 | V3 | ZF1R | ZF1R Inv. archive w/o T&C | 1 | 1 | ||||||||
| QF2 | V3 | ZF99 | ZF99 Invoice (Copy BG) | 1 | 1 | ||||||||
| QF2 | V3 | ZFCF | ZFCF Invoice (C. Frwd) | 1 | 1 | 1 | 1 | ||||||
| QF2 | V3 | ZFEI | ZFEI Excise Invoice IN | 1 | 1 | ||||||||
| QF2 | V3 | ZFIL | ZFIL Invoice list | 3 | 2 | ||||||||
| QF2 | V3 | ZFIM | ZFIM Invoice list(C.Cust) | 1 | 1 | ||||||||
| QF2 | V3 | ZFMX | ZFMX Invoice (MX) | 2 | 1 | ||||||||
| QF2 | V3 | ZQBC | ZQBC Batch cert for India | 1 | |||||||||
| WQ2 | V3 | RD04 | RD04 Invoice Receipt MM | 2 | 1 | ||||||||
| WQ2 | V3 | ZBA1 | ZBA1 Appl Negotiation (1) | 1 | |||||||||
| WQ2 | V3 | ZCOR | ZCOR Cert of Origin(Asia) | 1 | 1 | ||||||||
| WQ2 | V3 | ZEID | ZEID IN Excise inv depot | 1 | |||||||||
| WQ2 | V3 | ZEIG | ZEIG IN Form 403 gujarat | 1 | |||||||||
| WQ2 | V3 | ZEII | ZEII IN Excise invoice | 1 | |||||||||
| WQ2 | V3 | ZFMX | ZFMX XML invoice (MX) | 1 | |||||||||
| WQ2 | V3 | ZGST | ZGST IN GST invoice | 1 | 3 | 1 | 2 | 3 | 6 | ||||
| WQ2 | V3 | ZGSU | ZGSU IN GST Subcontractin | 1 | |||||||||
| WQ2 | V3 | ZINV | ZINV EDI: Invoice | 3 | 1 | 2 | 4 | ||||||
| WQ2 | V3 | ZPI3 | ZPI3 Pilotage | 1 | |||||||||
| WQ2 | V3 | ZRAC | ZRAC Original Inv Aero | 1 | 2 | 2 | |||||||
| WQ2 | V3 | ZRAR | ZRAR Invoice archive | 1 | 1 | 8 | 2 | 5 | 4 | ||||
| WQ2 | V3 | ZRB0 | ZRB0 Original Asian Inv | 12 | 2 | 7 | 5 | ||||||
| WQ2 | V3 | ZRB1 | ZRB1 duplicata Asian Inv | 4 | 3 | ||||||||
| WQ2 | V3 | ZRD0 | ZRD0 Original Invoice | 1 | 2 | 12 | 1 | 8 | 8 | ||||
| WQ2 | V3 | ZRD1 | ZRD1 Invoice | 1 | 1 | 8 | 1 | 9 | 4 | ||||
| WQ2 | V3 | ZRD2 | ZRD2 Invoice comm. assit | 5 | 4 | 1 | |||||||
| WQ2 | V3 | ZRD3 | ZRD3 Invoice for accounti | 3 | 1 | 1 | |||||||
| WQ2 | V3 | ZRD5 | ZRD5 Export Invoice | 8 | 2 | 2 | 4 | ||||||
| WQ2 | V3 | ZRD6 | ZRD6 Plant Invoice | 6 | 1 | 1 | 3 | ||||||
| WQ2 | V3 | ZRD7 | ZRD7 Inv for plant abroad | 2 | 1 | ||||||||
| WQ2 | V3 | ZRD8 | ZRD8 Orig Inv Letter | 6 | 3 | 2 | |||||||
| WQ2 | V3 | ZRDA | ZRDA Invoice Direct Ship. | 2 | 3 | 5 | |||||||
| WQ2 | V3 | ZRDB | ZRDB IntercoBridg RCS/ERP | 2 | 2 | ||||||||
| WQ2 | V3 | ZRDC | ZRDC eInvoice PDF by mail | 1 | 5 | 4 | 3 | ||||||
| WQ2 | V3 | ZRDD | ZRDD Invoice Customs Mono | 2 | |||||||||
| WQ2 | V3 | ZRDE | ZRDE Inv by mail to ZI | 1 | 3 | 13 | 8 | 8 | |||||
| WQ2 | V3 | ZREI | ZREI EDI: e-Invoice | 4 | 4 | 1 | |||||||
| WQ2 | V3 | ZREJ | ZREJ Invoice PDF by mail | 1 | 4 | 1 | 1 | ||||||
| WQ2 | V3 | ZRLA | ZRLA Letter of Auth. CN | 3 | 1 | ||||||||
| WQ2 | V3 | ZRLR | ZRLR Invoice List | 3 | 1 | 1 | |||||||
| WQ2 | V3 | ZRM6 | ZRM6 PDF Invoice by email | 1 | 1 | 1 | |||||||
| WQ2 | V3 | ZRMX | ZRMX Invoice mexico | 1 | |||||||||
| WQ2 | V3 | ZRN5 | ZRN5 Export Invoice Lett | 4 | 2 | ||||||||
| WQ2 | V3 | ZRN6 | ZRN6 Plant Invoice Letter | 6 | 1 | ||||||||
| WQ2 | V3 | ZRS1 | ZRS1 Invoice Cust. copy | 8 | 5 | 3 | |||||||
| WQ2 | V3 | ZRS2 | ZRS2 Invoice comm. assit | 8 | 4 | 1 | |||||||
| WQ2 | V3 | ZRS5 | ZRS5 Export Invoice | 7 | 1 | 4 | |||||||
| WQ2 | V3 | ZRS6 | ZRS6 Plant Invoice | 4 | 1 | ||||||||
| WQ2 | V3 | ZRSC | ZRSC Original Invoice GTC | 2 | 2 | 12 | 9 | 8 | |||||
| WQ2 | V3 | ZRWF | ZRWF Workflow | 5 | 4 | 2 |
List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
| Not Applicable | |
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Decision Tables are complete | Functional Team (L2C) + Data Team (L2C) |
| 2 | OPD configuration is complete | Functional Team (L2C) + Data Team (L2C) |
| 3 | Org structure configuration is complete | Functional Team (L2C) + Data Team (L2C) |
| 4 | Dependent Master Data records for Customer and Material are loaded | Functional Team (L2C) + Data Team (L2C) |
PreLoad Validation
Project Team
Completeness
| Task | Action |
|---|---|
| Configuration | Ensure necessary configurations are in place in target system |
| Check Values | Validate the pre-load data confirming the values are aligned with BRF+ configuration |
| Validate template structure and required field population | Ensure mandatory fields as per the definition table are available |
Accuracy
| Task | Action |
|---|---|
| Perform format validation (if relevant) | Standardize format to match SAP accepted input (e.g., YYYYMMDD for dates) |
| Conduct dry runs using BRF+ Simulations | Analyze load results and correct format or conversion errors |
Business
Completeness
| Task | Action |
|---|---|
| Completeness | Review and confirm if the extraction contain all the relevant DT and DT entries |
Accuracy
| Task | Action |
|---|---|
| Completeness | Review and confirm if the extraction contain all the accurate DT and DT entries |
Load
The load process includes:
- The process will involve downloading the DCT Excel Decision Tables and then uploading the tables into the target system using the standard SAP BRF+ upload functionality .The generated excel files will be used as load files
- Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation
BRF+ provides a built-in feature to download and upload decision tables as Excel files.
Steps:
Go to BRF+ application in transaction BRF+
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 back.
Load Run Sheet
Each Item represent a Decision table downloaded from Golden Client
There will be Decision tables for sales and Billing.
| Item # | Step Description | Team Responsible |
|---|---|---|
DT_OUTPUT_TYPE | ||
| DT_OUTPUT_CHANNEL | ||
| DT_RECEIVER | ||
| DT_EMAIL_SETTING | ||
| DT_EMAIL_RECEIVER | ||
| DT_OUTPUT_RELEVANCE |
Load Phase and Dependencies
Configuration
| Item # | Configuration Item |
|---|---|
| BRF+ configurations | Ensure configurations are complete for the target system and mapping tables are updated accordingly |
| Organization Data | Ensure configurations for all the organization units are imported into the target system |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| Material Master | Material Master Basic and Sales View |
| Business Partner | Business Partner Basic and Sales View |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
| Authorization Errors | Lack of access to execute load in target client/system | Raised access request; obtained necessary authorizations |
| Obsolete Master Data | Customer or material master data no longer exists in target system | Replaced or removed based on business input |
| Technical Load Failure | File not processed due to syntax/format error or system issue | Reviewed logs; regenerated file; re-executed load after resolving issue |
| Missing Dependencies | Dependent records (Order types, business partners, Email Addresses) not available | Reviewed config dependencies; coordinated with config team for correction |
PostLoad Validation
Project Team
Completeness
| Task | Action |
|---|---|
| Download DT in target as described before | |
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.
