| 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 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 SyWay 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 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.
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
- 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 | 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 | 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
Following Decision tables have been identified in the sandbox. This tables are for demonstration purposes and may change. Dynamic from conf toolkit
| 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 |
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 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 |
| 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 |
|---|---|---|---|---|
| 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 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 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
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 | ||||||||||
| 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 | ||||
| ROLEName | 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 | - |
| =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 |
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 |
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 simply contains the list of legacy output types and how they would have been mapped if all conditions were migrated. Please also note that all conditions no longer associated to V1 have been excluded.
| 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 | |||||||
| QF2 | V1 | ZC10 | ZC10 Order Confirmation | ORDER_CONFIRMATION | 7 | 3 | 7 | 17 | 7 | ||||
| QF2 | V1 | ZC11 | ZC11 Order Conf. (Copy C) | ORDER_CONFIRMATION | 4 | 2 | 6 | 12 | 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 | ZLO1 | ZLO1 Batch number recov. | 1 | |||||||||
| WQ2 | V3 | ZLOT | ZLOT Batch number recov. | 1 | |||||||||
| WQ2 | V3 | ZPI3 | ZPI3 Pilotage | 1 | |||||||||
| WQ2 | V3 | ZPLD | ZPLD Pack List (Dropship) | 4 | 2 | ||||||||
| WQ2 | V3 | ZQBC | ZQBC Batch cert for India | 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
| 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.
