You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Status

  Approved

Owner
Stakeholders

Purpose

The purpose of this document is to define the functional requirements, methodology, and approach for the initial data loading and subsequent synchronization of Business Rule Framework Plus (BRF+) Output Management data in SAP S/4HANA.

This process will establish and maintain output determination records (e.g., email recipients, output channels, and conditions related to BP) in BRF+ based on the configuration and master data currently maintained in Classic Output Management (NAST framework) within the legacies from SAP ECC.


Conversion Scope


The conversion scope covers the extraction, transformation, and loading of output determination data from Classic Output Management (NAST-based framework) into BRF+ Output Parameter Determination (OPD) in S/4HANA, ensuring both initial migration and interim synchronization until full adoption of BRF+ is achieved.

The scope includes:

  • Extraction of customer-related output condition records (e.g., for Sales Orders,  Quotations, Contracts, Scheduling Agreements, Invoice and Credit and Debit memos) from Classic Output Management, including associated communication details such as email addresses, language, and output channels;
  • Cleansing and Harmonization of extracted data to remove obsolete, incomplete, or duplicated entries, ensuring only valid and active output records are migrated;
  • Mapping of Classic condition record keys (application, condition type, key combination) to BRF+ OPD parameters (e.g., Customer, Sales Organization, Document Type, Output Type);
  • Transformation of medium and dispatch settings from Classic (e.g., NAST medium codes) to BRF+ equivalent channels (e.g., Email, Print, EDI), ensuring compatibility with S/4HANA Output Management settings;
  • Initial Load of the transformed dataset into BRF+ Output Parameter Determination using the OPD framework and/or BRF+ application data load methods;
  • Ongoing Synchronization process to detect and apply changes made in Classic Output Management to BRF+, allowing a parallel run period until Classic Output Management is fully decommissioned;
  • Validation to ensure that migrated BRF+ records produce identical output results as their Classic counterparts for equivalent sales scenarios.

Out of Scope:

  • Migration of output determination for applications outside of sales (e.g., MM Purchasing outputs);
  • Modifications to customer master data beyond the email and communication fields required for BRF+;
  • Changes to output form templates (Smartforms/Adobe Forms) beyond what is required for enabling BRF+.



The data from legacy system includes:

  1. 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.)
    1. Output types relevant for Sales Orders, Quotations, Contracts, Invoices and memos and Scheduling Agreements that are in active use in the business process
  2. Records with valid medium settings (e.g., Email, Print, EDI) compatible with S/4HANA BRF+ output channels
  3. Language assignments that are valid in the target system

The data from legacy system excludes:

  1. Obsolete, expired, or logically deleted output condition records
  2. Condition records for customers that are blocked for sales or flagged for deletion in the customer master
  3. Output types not used in the current or target S/4HANA sales processes
  4. Records with incomplete or invalid communication data (e.g., missing email for email output medium)
  5. 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

SourceScope

Source Approx No. of Records

Target SystemTarget 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





SourceApplicationTable

Table Description

Output Types

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

WQ2 V1 SALES OUTPUTS
WQ2V1001Sales Organization/Customer NumberBA00/SDB/ZMCE/ZRC3/ZRS2/ZRSP/ZRST/ZSY2/ZSYC534

WQ2V1005Sales Organization/Order TypeSDB/ZAAR/ZAN1/ZARC/ZARD/ZARE/ZBA0/ZBA1/ZBA2/ZBA6/ZBA8/ZBA9/ZBAC/
ZBDC/ZBSC/ZCQ1/ZLRG/ZMRC/ZMRM/ZPL1/ZSTC/ZSTO/ZTP1/
2441

WQ2V1007Order TypeZPI1/37

WQ2V1013Sales Org.ZAAR/ZAN0/ZAN1/ZARC/ZARD/ZARE/ZARM/ZBA1/
ZBA2/ZBA5/ZBA6/ZBA7/ZBA8/ZBA9/ZBAC/ZBAR/ZBSC/
125

WQ2V1502Sales 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

WQ2V1503Sales organization/Sales office/Commercial assistantZAAR/ZAN0/ZAN1/ZARC/ZARD/ZARE/ZARM/ZBA0/ZBA1/ZBA2/ZBA3/ZBA5/ZBA6/
ZBA7/ZBA8/ZBA9/ZBAR/ZBSC/ZCQ1/ZCQR/ZCSC/ZMRC/ZMRM/ZPL1/
278

WQ2V1506Sales organization/Sales office/Sold-to partyZARC/ZARM/ZBA0/ZBA1/ZBA2/ZBA5/ZBA9/ZBAC/
ZBSC/ZC10/ZC17/ZC19/ZCAR/ZCOE/ZMRC/ZMRM/
179

WQ2V1532Sales Org/DC/Sales OfficeZARC/ZARM/ZBA1/ZBA2/ZBA9/ZBAC/ZBAR/ZBSC/ZMRM/26

WQ2V1536Sales Organization/Delivery block
6

WQ2V1559Sales org./Sold to Country/CurrencyZARC/ZARM/ZBAC/16

WQ2V1701Ship Point/SalesDocTyZDOC/1

WQ2V1933Sales org./PO typeZARM/ZAWA/91

WQ2V1934Sales org./PO type/Sold-to ptZAWA/763

WQ2 V3 INVOICE OUTPUTS
WQ2V3001Sales Organization/Customer Number
952

WQ2V3008Billing Type
39

WQ2V3011Sales Organization/Billing Type
411

WQ2V3013Sales Org.
9

WQ2V3504Sales organization/ Shipping point
1

WQ2V3505Sales organization/Shipping point/Bill-to party
3

WQ2V3507Sales organization/Sales office/Bill-to party
163

WQ2V3511Sales organization/Sales office
53

WQ2V3512Sales organization/Sales office/Commercial assistant
47

WQ2V3533Sales Org/Distribution Channel/Sales Office
5

WQ2V3539Sales org./Sales Off./Created/Bill. Type
1

WQ2V3551Sales org./Doc.cat./Sales Off./Bill to
79

WQ2V3552Sales org./Sales Off./Doc.cat./SalesDocTy/e-inv. flag
788

WQ2V3553Sales Off./Doc.cat./e-inv. flag
85

WQ2V3554Sales org./Sales Off./Doc.cat./e-inv. flag
673

WQ2V3558Sales Organization/Sales Office/Billing Type
106

WQ2V3560Sales Off./e-inv. flag
6

WQ2V3569Sales org./Currency/Plant/Bill. Type
11

WQ2V3570Sales org./Currency/Bill. Type
6

WQ2V3572Sales org./Distr. Chl/Bill. Type/Sold-To Pt
21

WQ2V3889Sales org./Sold-to pt
27

WQ2V3910Interco. billing: Org.comm./Bill-to
37

WQ2V3923Sales Organization/Distribution Channel/Bill-to party
51

WQ2V3953Sales org./Bill.type/Payer
84

WQ2V3955Sales org./Ship.point/Bill.type/RecipCntry
6541

WQ2V3957Sales organization/Billing type/Bill-to party
7326

WQ2V3960e-invoicing
1

WQ2V3962Sales Organization/Distribution Channel/Billing Type/Ship-to
72

WQ2V3995Sales Org/Sales Office/Billing Type/Dest country
44

QF1 V1 SALES OUTPUTS
QF2V1001Sales Organization/Customer NumberBA00/SDB/ZC2B/ZC44/ZC46/ZC52/ZC55/ZMCE/ZRC3/ZRS2/ZRSP/ZRST/ZSY2/ZSYC18392

QF2V1005Sales Organization/Order TypeSDB/ZAAR/ZAN1/ZARC/ZARD/ZARE/ZBA0/ZBA1/ZBA2/ZBA6/ZBA8/ZBA9/ZBAC/
ZBDC/ZBSC/ZCQ1/ZLRG/ZMRC/ZMRM/ZPL1/ZSTC/ZSTO/ZTP1/
292

QF2V1006SOrg./Distrib.Ch/Division/CustomerZC46/ZC50/ZCER/11

QF2V1506Sales Off./Ship-To/SalesDocTy/DivisionZARC/ZARM/ZBA0/ZBA1/ZBA2/ZBA5/ZBA9/ZBAC/
ZBSC/ZC10/ZC17/ZC19/ZCAR/ZCOE/ZMRC/ZMRM/
75

QF2V1866Sales Organization/Division/CustomerSDB/1

QF2V1867Sales Organization/Division/Customer/Quality codeSDB/253

QF2V1875Sales Organization/Order Type/Quality codeSDB/261

QF2V1876Sales Organization/Customer/Quality codeSDB/53293

QF2V1891Sales Office/Customer/Sales Document TypeZC10/ZC11/ZC13/ZC14/ZC15/ZC16/ZC17/ZC19/
ZC35/ZC36/ZC40/ZCAR/ZCOE/ZCOF/
11248

QF2V1911SalesDocTy/Ship-to/Material
5

QF2V1912Sales office/Sales document typeZC10/ZC11/ZC13/ZC15/ZC16/ZCAR/ZCOE/121

QF2V1913Sales officeZC10/ZC11/ZC13/ZC15/ZCAR/31

QF2V1917Sales Office/Sales DocType/PO typeZC10/ZC17/ZCAR/121

QF2V1918Sales office/Sold-to partyZC10/ZC11/ZC13/ZC14/ZC17/ZC19/ZC35/ZC36/ZCAR/ZCOE/3318

QF2V1922Sales office/Shipping conditions.ZC30/ZC31/ZC40/221

QF2V1938Sales organization/Purchase order type/CustomerZC2B/24

QF2V1950Sales office/Division/Sales document typeZC10/ZC11/ZC13/ZC17/ZC19/ZCAR/ZCOE/344

QF2V1956Sales office/Shipping conditions/PlantZC30/ZC32/34

QF2V1959Sales office/Shipping conditions/Service agentZC30/ZC40/108

QF2V1972Sales office/Shipping conditions/Contact AgentZC31/1

QF2V1986Sales office/Country (Sold-to party)ZC10/ZC11/ZC17/ZC19/ZCAR/319

QF2V1989Sales Organization/Customer/Sales Document TypeZC2B/4

QF1 V3 INVOICE OUTPUTS
QF2

V3

001Sales Organization/Customer Number
2966

QF2V3006SOrg./Distrib.Ch/Division/Customer
387

QF2V3008Billing Type
2

QF2V3011Sales Organization/Billing Type
195

QF2V3013Sales Org.
63

QF2V3840Sales office / Sold-to Doc type / Billing Type
35

QF2V3841Sales office / Sold-to Doc type
122

QF2V3913Sales office
110

QF2V3916Bill-to party
2

QF2V3919Sales office/Bill-to party/Billing type
1332

QF2V3920Bill.type/Sales org./RecipCntry
14

QF2V3921Sales office/Bill-to party
14365

QF2V3927Billing type/Bill-to party
72

QF2V3932Payer
192

QF2V3935Sales organization/Shipping point/Billing type
69

QF2V3937Payer/Billing type
986

QF2V3939Sales office/Manual invoice maintenance
28

QF2V3940Sales office/Bill-to party/Manual invoice maintenance
46

QF2V3942Sales office/Country (Bill-to party)
271

QF2V3953Sales office/Sales group
72

QF2V3958Sales off./Sales org./Bill.type
71

QF2V3963Sales org./Contact agent/Bill.type
1056

QF2V3966Sales org./Payer/Bill.type
32553

QF2V3967Sales Organization/PO type/Sold-to party
1

QF2V3973Bill.type/Sales org./RecipCntry/Payer
96

QF2V3974Sales organization/Billing type/Bill-to party
1882

QF2V3975Sales organization/Billing type/Delivering country
23

QF2V3985Sales organization/Sold-to party
11

QF2V3993Sales Organization/Billing Type/Destination Country
16

QF2V3998Sales 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:

  1. Output Type (e.g., ORDER_CONFIRMATION, BILLING_OUTPUT)
  2. Output Channel (e.g., Email, Print, EDI)
  3. Form Template (Adobe Form)
  4. Receiver (Partner Function)
  5. Language


Strategic Approach: BRF+ Output Simplification

  • Merge multiple legacy ECC output types (e.g., ZC10,ZC11,ZARM...) into a single BRF+-driven output type, e.g. ORDER_CONFIRMATION to simplify maintenance and governance.

  • Minimize the creation of outputs that are rarely triggered, focusing on high-value and frequently triggered scenarios.

  • Avoid using business partners or email addresses as decision table input parameters. Instead, leverage business partner attributes to determine the appropriate outputs and channels.

Implication:
There will be no direct one-to-one mapping from ECC condition records to BRF+ decision tables. The approach emphasizes a simplified, rules-driven model that covers the majority of business scenarios while reducing complexity.

Following Decision tables have been identified in the sandbox. This tables are for demonstration purposes and may change.

Decision Table NameInput Parameter 1Input Parameter 2Input Parameter 3Input Parameter 4Input Parameter 5Input Parameter 6Input Parameter 7Input Parameter 8Input Parameter 9ResultResult

DT_OUTPUT_TYPE


Sales Document Cat.Sales Doc. Type








Output TypeDispatch Time
DT_OUTPUT_CHANNEL

Output Type 

Partner RoleSales Org. Distr. Channel DivisionSales OfficeRecipient

Channel
DT_RECEIVER

Output Type 

Partner Role








Exclusive Indicator 
DT_EMAIL_SETTINGOutput Type Partner RoleSales Org.Distr. ChannelDivisionSales Office


Sender EmailEmail Template
DT_EMAIL_RECEIVEROutput Type Partner Role






Email Type CodeE-Mail Address
DT_OUTPUT_RELEVANCEOutput Type Purch Conf. StsOverall HeaderOverall Cred StatDelivery BlockBilling BlockAll Items

Relevance Indicator















Data Cleansing

The cleansing activity involves validation of message types, partner functions, and language assignments. Records with missing partner data or invalid Output Types will be flagged for correction. Duplicate or inconsistent entries will be resolved before transformation. Currently none of those cases were encountered at Syensqo.


IDCriticalityError Message/Report DescriptionRuleOutputSource System


























Conversion Process

The high-level process is represented by the diagram below:

Data Privacy and Sensitivity

All data extracted must be anonymized and handled according to data protection policies.


Extraction

Data will be extracted from ECC using SQLbased queries executed on the source database. The extraction will include relevant tables such as NACH, TNAPR, The extraction methods are as follows:

  • Full extraction from relevant tables in ECC (preferred).
  • Extraction through the application layer when database access is restricted.
  • Manual extraction via reports or DCT if system access is not possible.

Relevancy criteria will be applied to include only active, valid, and inscope records.

Extraction Run Sheet: To be provided after the first mock cycle.


Source Table to be extracted: NACH Table


TableFieldData ElementData TypeLengthShort DescriptionRequirement
NACHMANDTMANDTCLNT3ClientMandatory
NACHKNUMHNNUMHCHAR10Number of output condition recordMandatory
NACHERNAMERNAMCHAR12Name of Person Who Created the ObjectOptional
NACHERDATERDATDATS8Date on Which Record Was CreatedOptional
NACHKVEWEKVEWECHAR1Usage of the condition tableMandatory
NACHKOTABNRKOTABNRCHAR3Condition tableMandatory
NACHKAPPLKAPPLCHAR2ApplicationMandatory
NACHKSCHLKSCHL_OCCHAR4Condition TypeMandatory
NACHVAKEYVAKEYCHAR100Variable key 100 bytesMandatory
NACHDATABDATABDATS8ValidFrom DateOptional
NACHDATBIDATBIDATS8Valid To DateOptional
NACHKOSRTKOSRTCHAR10Search term for conditionsOptional
NACHPARVWPARVWCHAR2Partner FunctionMandatory
NACHPARNRNA_PARNR_OCCHAR10Message partnerMandatory
NACHNACHANA_NACHACHAR1Message transmission mediumMandatory
NACHANZALNA_ANZALDEC2Number of messages (original + copies)Optional
NACHVSZTPNA_VSZTPCHAR1Dispatch timeMandatory
NACHTCODECSTRATEGYCHAR4Communication strategyOptional
NACHAENDENA_AENDECHAR1Change message flagOptional
NACHPFLD2NA_OBS030CHAR30Unused fieldOptional
NACHPFLD3TDSFNAMECHAR30Smart Forms: Form NameOptional
NACHPFLD4NA_TDFORMCHAR30WFMC: SAPscript form in 30character fieldOptional
NACHPFLD5NA_LABELCHAR30WFMC: Function module for print formattingOptional
NACHTDNAMENA_OBJKY_LCHAR70Object key (long)Optional
NACHTDIDTDIDCHAR4Text IDOptional
NACHSPRASSPRASLANG1Language KeyOptional
NACHFORFBBCS_RQST_OCCHAR1Requested StatusOptional
NACHPRIFBBCS_STML_OCCHAR1Setting for Which Statuses Are Reported by MailOptional
NACHLDESTRSPOPNAMECHAR4Spool: Output deviceOptional
NACHDSNAMRSPO0NAMECHAR6Spool request: NameOptional
NACHDSUF1RSPO1NAMECHAR4Spool request: Suffix 1Optional
NACHDSUF2RSPO2NAMECHAR12Spool request: Suffix 2Optional
NACHDIMMETDIMMED_OCCHAR1Print immediatelyOptional
NACHDELETTDDELETE_OCCHAR1Release after outputOptional
NACHTDRECEIVERSYPRRECCHAR12Spool Recipient NameOptional
NACHTDDIVISIONSYPRABTCHAR12Spool Department NameOptional
NACHTDOCOVERSYPRSAPCHAR1Print: SAP cover pageOptional
NACHTDCOVTITLESYPRTXTCHAR68Spool DescriptionOptional
NACHTDAUTHORITYSYPRBERCHAR12Print: AuthorizationOptional
NACHACOUTSO_ACOUTCHAR1ToDo: To Be Completed Outside SAPofficeOptional
NACHSKIPSNA_OBS001CHAR1Unused fieldOptional
NACHACMEMSO_ACMEMCHAR32Process: memory IDOptional
NACHACNAMSNA_ACNAMCHAR30Execute: Name of report, FM, DB, TCodes (old length)Optional
NACHEVENTSWO_EVENTCHAR32EventOptional
NACHOBJTYPEOBJ_NAME_OCCHAR10Object typeOptional
NACHTDSCHEDULESKSCHEDULE_OCCHAR3Send time requestOptional
NACHTDARMODSYARMOD_OCCHAR1Print: Archiving modeOptional


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 DescriptionTeam 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 ScreenParameter NameSelection TypeRequirementValue to be entered/set





















Data Collection Template (DCT)

BRF+ provides a builtin feature to download and upload decision tables as Excel files. 

  • Steps:

    1. Go to your BRF+ application in transaction BRF+ (or BRFPLUS).

    2. Open the Decision Table object.

    3. From the Table Maintenance screen:

      • Click on “Download to Excel” → system exports the current content and structure.

      • Fill in or update the Excel file offline.

      • Use “Upload from Excel” to import it back.


Note: 

  • Each table must be handled individually.
  • The creation of Data collection template must be aligned with BRF+ configurations . For now, the following Template is prepared based on Configurations from S/4HANA Sandbox environment.  This will be replaced once the configuration is ready. The same applies to the contents of the DTs, they are here as examples and will be replaced by real configuration objects .

 

Decision Table NameInput Parameter 1Input Parameter 2Input Parameter 3Input Parameter 4Input Parameter 5Input Parameter 6Input Parameter 7Input Parameter 8Input Parameter 9ResultResult

DT_OUTPUT_TYPE


Sales Document Cat.Sales Doc. Type








Output TypeDispatch Time
DT_OUTPUT_CHANNEL

Output Type 

Partner RoleSales Org. Distr. Channel DivisionSales OfficeRecipient

Channel
DT_RECEIVER

Output Type 

Partner Role








Exclusive Indicator 
DT_EMAIL_SETTINGOutput Type Partner RoleSales Org.Distr. ChannelDivisionSales Office


Sender EmailEmail Template
DT_EMAIL_RECEIVEROutput Type Partner Role






Email Type CodeEMail Address
DT_OUTPUT_RELEVANCEOutput Type Purch Conf. StsOverall HeaderOverall Cred StatDelivery BlockBilling BlockAll Items

Relevance Indicator


DT_OUTPUT_TYPE: 

DCT Rules:


NameDescription(Text)Result ColumnTypeBindingLengthDecimalsOnly PositiveOnly UppercaseTimepoint TypeDimension Key
SDDOCUMENTCATEGORYDocument Cat.
Element (Text )VBTYPL40



SALESDOCUMENTTYPESales Doc. Type
Element (Text )AUART40
X

OUTPUT_TYPEOutput TypeXElement (Text )APOC_OUTPUT_TYPE300
X

DISPATCH_TIMEDispatch TimeXElement (Text )APOC_OR_DISPATCH_TIME10
X


DCT Template: 


Document Cat.Sales Doc. TypeOutput TypeDispatch Time
=C=ORZ_ORDER_ACKNOWLEDGEMENT_EMAIL2
=C<>BV ; exclude =SO01 ; =CCISORDER_CONFIRMATION1
=C<>BV ; exclude =SO01 ; =CCISORDER_CONFIRMATION_CHANGE1
=C=BVCASH_SALE1
=A
SALES_INQUIRY1



DT_RECEIVER: 

DCT Rules:

DT_RECEIVER 
NameDescription(Text)Result ColumnTypeBindingLengthDecimalsOnly PositiveOnly UppercaseTimepoint TypeDimension Key
OUTPUT_TYPEOutput Type
Element (Text )APOC_OUTPUT_TYPE300
X

ROLERoleXElement (Text )APOC_ROLE_CODE20
X

EXCLUSIVE_INDExclusive IndicatorXElement (Text )APOC_EXCLUSIVE_INDICATOR10
X


DCT Template:

DT_RECEIVER 
Output TypeRoleExclusive Indicator
=Z_ORDER_ACKNOWLEDGEMENT_EMAILAP-
=ORDER_CONFIRMATIONAP-
=ORDER_CONFIRMATIONAG-
=ORDER_CONFIRMATION_CHANGEAG-
=CASH_SALERE-
=CASH_SALE_CHANGERE-
=SALES_INQUIRYAG-
=SALES_INQUIRY_CHANGEAG-
=SALES_QUOTATIONAG-
=SALES_QUOTATION_CHANGEAG-
=SALES_CONTRACTAG-
=SALES_CONTRACT_CHANGEAG-
=CUSTOMER_RETURNAG-
=CUSTOMER_RETURN_CHANGEAG-
=ORDER_WO_CHARGEAG-
=ORDER_WO_CHARGE_CHANGEAG-
=DEBIT_MEMO_REQUESTZM-
=DEBIT_MEMO_REQUEST_CHANGEZM-
=CREDIT_MEMO_REQUESTZM-
=CREDIT_MEMO_REQUEST_CHANGEZM-


DT__CHANNEL:

DCT Rules:

NameDescription(Text)Result ColumnTypeBindingLengthDecimalsOnly PositiveOnly UppercaseTimepoint TypeDimension Key
OUTPUT_TYPEOutput Type
Element (Text )APOC_OUTPUT_TYPE300
X

ROLERole
Element (Text )APOC_ROLE_CODE20
X

SALESORGANIZATIONSales Org.
Element (Text )VKORG40
X

DISTRIBUTIONCHANNELDistr. Channel
Element (Text )VTWEG20
X

ORGANIZATIONDIVISIONDivision
Element (Text )SPART20
X

SALESOFFICESales Office
Element (Text )VKBUR40
X

BUSINESS_PARTNER_IDRecipient
Element (Text )APOC_RECEIVER_ID100
X

SALESDOCUMENTTYPESales Doc. Type
Element (Text )AUART40
X

OVRLITMGENERALINCOMPLETIONSTSAll Items
Element (Text )UVALL_SU10
X

CHANNELChannelXElement (Text )APOC_CHANNEL50
X

EXCLUSIVE_INDExclusive IndicatorXElement (Text )APOC_EXCLUSIVE_INDICATOR10
X


DCT Template:

Output TypeRoleSales Org.Distr. ChannelDivisionSales OfficeRecipientSales Doc. TypeAll ItemsChannelExclusive Indicator
=Z_ORDER_ACKNOWLEDGEMENT_EMAIL







EMAIL-
=ORDER_CONFIRMATION=AP






EMAIL-
=ORDER_CONFIRMATION=AG






PRINT-
=ORDER_CONFIRMATION=AG=1001



=OR
EDI-
=ORDER_CONFIRMATION=AG






PRINT-
=ORDER_CONFIRMATION_CHANGE







PRINT-
=CASH_SALE







PRINT-



DT__EMAIL_RECEIVER:

DCT Rules:

NameDescription(Text)Result ColumnTypeBindingLengthDecimalsOnly PositiveOnly UppercaseTimepoint TypeDimension Key
OUTPUT_TYPEOutput Type
Element (Text )APOC_OUTPUT_TYPE300
X

ROLERole
Element (Text )APOC_ROLE_CODE20
X

EMAIL_ROLEEmail Type CodeXElement (Text )APOC_EMAIL_ROLE_CODE50
X

EMAIL_URIE-Mail AddressXElement (Text )AD_SMTPADR2410




DCT Template:

Output TypeRoleEmail RoleEmail URI
=Z_ORDER_ACKNOWLEDGEMENT_EMAIL=APTO
=ORDER_CONFIRMATION=APTO
=ORDER_CONFIRMATION=AGTO


DT__EMAIL_SETTING:

DCT Rules:

NameDescription(Text)Result ColumnTypeBindingLengthDecimalsOnly PositiveOnly UppercaseTimepoint TypeDimension Key
OUTPUT_TYPEOutput Type
Element (Text )APOC_OUTPUT_TYPE300
X

ROLERole
Element (Text )APOC_ROLE_CODE20
X

SALESORGANIZATIONSales Org.
Element (Text )VKORG40
X

DISTRIBUTIONCHANNELDistr. Channel
Element (Text )VTWEG20
X

ORGANIZATIONDIVISIONDivision
Element (Text )SPART20
X

SALESOFFICESales Office
Element (Text )VKBUR40
X

EMAIL_FROMSender EmailXElement (Text )APOC_SENDER_EMAIL_ADDR2410



EMAIL_TEMPLATE_IDEmail TemplateXElement (Text )APOC_EMAIL_TEMPLATE300
X


DCT Template:

Output TypeRoleSales Org.Distr. ChannelDivisionSales OfficeSender EmailEmail Template
=ORDER_CONFIRMATION=AG=1001


jatin.somaiya-ext@syensqo.comSD_SLS_DEFAULT_EMAIL_TEMPLATE
=ORDER_CONFIRMATION
=1001


jatin.somaiya-ext@syensqo.comSD_SLS_DEFAULT_EMAIL_TEMPLATE
=Z_ORDER_ACKNOWLEDGEMENT_EMAIL=AP



jatin.somaiya-ext@syensqo.comSD_SLS_DEFAULT_EMAIL_TEMPLATE



DT__OUTPUT_RELEVANCE: DCT Rules:

NameDescription(Text)Result ColumnTypeBindingLengthDecimalsOnly PositiveOnly UppercaseTimepoint TypeDimension Key
OUTPUT_TYPEOutput Type
Element (Text )APOC_OUTPUT_TYPE300
X

OVERALLPURCHASECONFSTATUSPurg Conf. Sts
Element (Text )COSTA_D10
X

HDRGENERALINCOMPLETIONSTATUSOverall Header
Element (Text )UVALL_UK10
X

TOTALCREDITCHECKSTATUSOverallCredStat
Element (Text )CMGST10
X

DELIVERYBLOCKREASONDelivery Block
Element (Text )LIFSK20
X

HEADERBILLINGBLOCKREASONBilling Block
Element (Text )FAKSK20
X

OVRLITMGENERALINCOMPLETIONSTSAll Items
Element (Text )UVALL_SU10
X

RELEVANCE_INDRelevance IndicatorXElement (Text )APOC_RELEVANCE_INDICATOR10
X

OVRLITMGENERALINCOMPLETIONSTSAll Items
Element (Text )UVALL_SU10
X

CHANNELChannelXElement (Text )APOC_CHANNEL50
X

EXCLUSIVE_INDExclusive IndicatorXElement (Text )APOC_EXCLUSIVE_INDICATOR10
X


DT__OUTPUT_RELEVANCE: DCT Template:

Output TypePurg Conf. StsOverall HeaderOverallCredStatDelivery BlockBilling BlockAll ItemsRelevance IndicatorAll ItemsChannelExclusive Indicator
=Z_ORDER_ACKNOWLEDGEMENT_EMAIL=" "




" "
EMAIL-
=ORDER_CONFIRMATION=C ; =" "=Ccontains not any 'BC'is initial
=CX
EMAIL-
=ORDER_CONFIRMATION_CHANGE=C ; =" "=Ccontains not any 'BC'is initial
=CX
PRINT-
=CASH_SALE
=Ccontains not any 'BC'is initialis initial
X
EDI-
=CASH_SALE_CHANGE
=Ccontains not any 'BC'is initialis initial
X
PRINT-
=SALES_INQUIRY
=C



X
PRINT-
=SALES_INQUIRY_CHANGE
=C



X
PRINT-
=SALES_QUOTATION
=C



X
PRINT-
=SALES_QUOTATION_CHANGE
=C



X


=SALES_CONTRACT
=C



X


=SALES_CONTRACT_CHANGE
=C



X


=CUSTOMER_RETURN
=Ccontains not any 'BC'is initial

X


=CUSTOMER_RETURN_CHANGE
=Ccontains not any 'BC'is initial

X


=ORDER_WO_CHARGE=C ; =" "=Ccontains not any 'BC'is initial

X


=ORDER_WO_CHARGE_CHANGE=C ; =" "=Ccontains not any 'BC'is initial

X


=DEBIT_MEMO_REQUEST
=Ccontains not any 'BC'
is initial
X


=DEBIT_MEMO_REQUEST_CHANGE
=Ccontains not any 'BC'
is initial
X


=CREDIT_MEMO_REQUEST
=Ccontains not any 'BC'
is initial
X


=CREDIT_MEMO_REQUEST_CHANGE
=Ccontains not any 'BC'
is initial
X


=SEPA_MANDATE
=C



X



Extraction Dependencies


Item #Step DescriptionTeam Responsible
1

Source System Availability

  • Ensure that the source database or application is accessible.
  • Confirm that necessary credentials and permissions are granted
Syensqo IT
2

Data Structure

  • Identify relationships between tables, views, and stored procedures.
Synithi
3

Referential Integrity

  • Ensure dependent records are extracted together.
Synithi
4

Extraction Methodology

  • Define whether extraction is full, incremental, or delta-based.
  • Establish batch processing schedules for large datasets.
Synithi
5

Performance and Scalability Considerations

  • Optimize extraction queries to prevent system overload.
  • Ensure network bandwidth supports data transfer volumes.
Synithi
6

Security and Compliance

  • Adhere to regulatory standards for sensitive information if applicable
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:

  1. Perform value mapping and data transformation rules.
    1. Legacy values are mapped to the to-be values (this could include a default value)
    2. Values are transformed according to the rules defined in
  2. 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 DescriptionTeam Responsible

Finalized mapping document approved by Functional and Business teams.



Completion of source data extraction and cleansing.



Availability of default values for S/4 mandatory fields.




Transformation Rules

Please note that there is no direct mapping between the condition types and the BRF+ output types. The table below will simply contain the list of legacy output types and how they would have been mapped if all conditions were migrated. Please note that all conditions no longer associated to V1have been excluded


 ApplicationCondition TypeCondition type NameCond type BRF+ Output Type

V1BA00Order ConfirmationBA00  Order ConfirmationORDER_CONFIRMATION

V1BA00Order ConfirmationBA00  Order ConfirmationORDER_CONFIRMATION

V1ZAARArchive Ord Con AeroZAAR  Archive Ord Con AeroORDER_CONFIRMATION

V1ZAARArchive Ord Con AeroZAAR  Archive Ord Con AeroORDER_CONFIRMATION

V1ZAARArchive Ord Con AeroZAAR  Archive Ord Con AeroORDER_CONFIRMATION

V1ZAN0QuotationZAN0  QuotationSALES_QUOTATION

V1ZAN0QuotationZAN0  QuotationSALES_QUOTATION

V1ZAN0QuotationZAN0  QuotationSALES_QUOTATION

V1ZAN1QuotationZAN1  QuotationSALES_QUOTATION

V1ZAN1QuotationZAN1  QuotationSALES_QUOTATION

V1ZAN1QuotationZAN1  QuotationSALES_QUOTATION

V1ZAN1QuotationZAN1  QuotationSALES_QUOTATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARCPDF by mailZARC  PDF by mailORDER_CONFIRMATION

V1ZARDPDF by mailZARD  PDF by mailORDER_CONFIRMATION

V1ZARDPDF by mailZARD  PDF by mailORDER_CONFIRMATION

V1ZARDPDF by mailZARD  PDF by mailORDER_CONFIRMATION

V1ZARDPDF by mailZARD  PDF by mailORDER_CONFIRMATION

V1ZARDPDF by mailZARD  PDF by mailORDER_CONFIRMATION

V1ZAREOrder Confirm AeroZARE  Order Confirm AeroORDER_CONFIRMATION

V1ZAREOrder Confirm AeroZARE  Order Confirm AeroORDER_CONFIRMATION

V1ZAREOrder Confirm AeroZARE  Order Confirm AeroORDER_CONFIRMATION

V1ZAREOrder Confirm AeroZARE  Order Confirm AeroORDER_CONFIRMATION

V1ZARMOrder creation EmailZARM  Order creation EmailORDER_CONFIRMATION

V1ZARMOrder creation EmailZARM  Order creation EmailORDER_CONFIRMATION

V1ZARMOrder creation EmailZARM  Order creation EmailORDER_CONFIRMATION

V1ZARMOrder creation EmailZARM  Order creation EmailORDER_CONFIRMATION

V1ZARMOrder creation EmailZARM  Order creation EmailORDER_CONFIRMATION

V1ZARMOrder creation EmailZARM  Order creation EmailORDER_CONFIRMATION

V1ZARMOrder creation EmailZARM  Order creation EmailORDER_CONFIRMATION

V1ZAWAEMail to AssistantZAWA  EMail to AssistantORDER_CONFIRMATION

V1ZAWAEMail to AssistantZAWA  EMail to AssistantORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA0Order ConfirmationZBA0  Order ConfirmationORDER_CONFIRMATION

V1ZBA1Order ConfirmationZBA1  Order ConfirmationORDER_CONFIRMATION

V1ZBA1Order ConfirmationZBA1  Order ConfirmationORDER_CONFIRMATION

V1ZBA1Order ConfirmationZBA1  Order ConfirmationORDER_CONFIRMATION

V1ZBA1Order ConfirmationZBA1  Order ConfirmationORDER_CONFIRMATION

V1ZBA1Order ConfirmationZBA1  Order ConfirmationORDER_CONFIRMATION

V1ZBA1Order ConfirmationZBA1  Order ConfirmationORDER_CONFIRMATION

V1ZBA1Order ConfirmationZBA1  Order ConfirmationORDER_CONFIRMATION

V1ZBA2Order ConfirmationZBA2  Order ConfirmationORDER_CONFIRMATION

V1ZBA2Order ConfirmationZBA2  Order ConfirmationORDER_CONFIRMATION

V1ZBA2Order ConfirmationZBA2  Order ConfirmationORDER_CONFIRMATION

V1ZBA2Order ConfirmationZBA2  Order ConfirmationORDER_CONFIRMATION

V1ZBA2Order ConfirmationZBA2  Order ConfirmationORDER_CONFIRMATION

V1ZBA2Order ConfirmationZBA2  Order ConfirmationORDER_CONFIRMATION

V1ZBA2Order ConfirmationZBA2  Order ConfirmationORDER_CONFIRMATION

V1ZBA3Order confirm PDF A4ZBA3  Order confirm PDF A4ORDER_CONFIRMATION

V1ZBA5Order ConfirmationZBA5  Order ConfirmationORDER_CONFIRMATION

V1ZBA5Order ConfirmationZBA5  Order ConfirmationORDER_CONFIRMATION

V1ZBA5Order ConfirmationZBA5  Order ConfirmationORDER_CONFIRMATION

V1ZBA6Order ConfirmationZBA6  Order ConfirmationORDER_CONFIRMATION

V1ZBA6Order ConfirmationZBA6  Order ConfirmationORDER_CONFIRMATION

V1ZBA6Order ConfirmationZBA6  Order ConfirmationORDER_CONFIRMATION

V1ZBA7Order ConfirmationZBA7  Order ConfirmationORDER_CONFIRMATION

V1ZBA7Order ConfirmationZBA7  Order ConfirmationORDER_CONFIRMATION

V1ZBA8Order ConfirmationZBA8  Order ConfirmationORDER_CONFIRMATION

V1ZBA8Order ConfirmationZBA8  Order ConfirmationORDER_CONFIRMATION

V1ZBA8Order ConfirmationZBA8  Order ConfirmationORDER_CONFIRMATION

V1ZBA9Order acknoled  AsiaZBA9  Order acknoled  AsiaZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZBA9Order acknoled  AsiaZBA9  Order acknoled  AsiaZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZBA9Order acknoled  AsiaZBA9  Order acknoled  AsiaZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZBA9Order acknoled  AsiaZBA9  Order acknoled  AsiaZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZBA9Order acknoled  AsiaZBA9  Order acknoled  AsiaZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZBA9Order acknoled  AsiaZBA9  Order acknoled  AsiaZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZBACEP Contract -  AsiaZBAC  EP Contract -  AsiaSALES_CONTRACT

V1ZBACEP Contract -  AsiaZBAC  EP Contract -  AsiaSALES_CONTRACT

V1ZBACEP Contract -  AsiaZBAC  EP Contract -  AsiaSALES_CONTRACT

V1ZBACEP Contract -  AsiaZBAC  EP Contract -  AsiaSALES_CONTRACT

V1ZBACEP Contract -  AsiaZBAC  EP Contract -  AsiaSALES_CONTRACT

V1ZBARArchive Ord.Conf.ZBAR  Archive Ord.Conf.ORDER_CONFIRMATION

V1ZBARArchive Ord.Conf.ZBAR  Archive Ord.Conf.ORDER_CONFIRMATION

V1ZBARArchive Ord.Conf.ZBAR  Archive Ord.Conf.ORDER_CONFIRMATION

V1ZBDCOffer Sheet KOMCZBDC  Offer Sheet KOMC


V1ZBSCOrd.Confirmation GTCZBSC  Ord.Confirmation GTCORDER_CONFIRMATION

V1ZBSCOrd.Confirmation GTCZBSC  Ord.Confirmation GTCORDER_CONFIRMATION

V1ZBSCOrd.Confirmation GTCZBSC  Ord.Confirmation GTCORDER_CONFIRMATION

V1ZBSCOrd.Confirmation GTCZBSC  Ord.Confirmation GTCORDER_CONFIRMATION

V1ZBSCOrd.Confirmation GTCZBSC  Ord.Confirmation GTCORDER_CONFIRMATION

V1ZBSCOrd.Confirmation GTCZBSC  Ord.Confirmation GTCORDER_CONFIRMATION

V1ZBSCOrd.Confirmation GTCZBSC  Ord.Confirmation GTCORDER_CONFIRMATION

V1ZCQ1ContractZCQ1  ContractSALES_CONTRACT

V1ZCQ1ContractZCQ1  ContractSALES_CONTRACT

V1ZCQRArchive ContractZCQR  Archive ContractSALES_CONTRACT

V1ZCSCContract with GTCZCSC  Contract with GTCSALES_CONTRACT

V1ZCSCContract with GTCZCSC  Contract with GTCSALES_CONTRACT

V1ZDLBMail delivery blockaZDLB  Mail delivery blocka


V1ZDOCDocument creationZDOC  Document creation


V1ZLRGRegen DMR Conf.ZLRG  Regen DMR Conf.ORDER_CONFIRMATION

V1ZMCEMail creat cmd EDIZMCE  Mail creat cmd EDIORDER_CONFIRMATION

V1ZMRCeOrd. Conf. to Cust.ZMRC  eOrd. Conf. to Cust.ORDER_CONFIRMATION

V1ZMRCeOrd. Conf. to Cust.ZMRC  eOrd. Conf. to Cust.ORDER_CONFIRMATION

V1ZMRCeOrd. Conf. to Cust.ZMRC  eOrd. Conf. to Cust.ORDER_CONFIRMATION

V1ZMRCeOrd. Conf. to Cust.ZMRC  eOrd. Conf. to Cust.ORDER_CONFIRMATION

V1ZMRCeOrd. Conf. to Cust.ZMRC  eOrd. Conf. to Cust.ORDER_CONFIRMATION

V1ZMRCeOrd. Conf. to Cust.ZMRC  eOrd. Conf. to Cust.ORDER_CONFIRMATION

V1ZMRMeOrd. Ackn. To CustZMRM  eOrd. Ackn. To CustZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZMRMeOrd. Ackn. To CustZMRM  eOrd. Ackn. To CustZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZMRMeOrd. Ackn. To CustZMRM  eOrd. Ackn. To CustZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZMRMeOrd. Ackn. To CustZMRM  eOrd. Ackn. To CustZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZMRMeOrd. Ackn. To CustZMRM  eOrd. Ackn. To CustZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZMRMeOrd. Ackn. To CustZMRM  eOrd. Ackn. To CustZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZPI1Monitoring 1er orderZPI1  Monitoring 1er order


V1ZPL1scheduling agreementZPL1  scheduling agreementORDER_CONFIRMATION

V1ZPL1scheduling agreementZPL1  scheduling agreementORDER_CONFIRMATION

V1ZPL1scheduling agreementZPL1  scheduling agreementORDER_CONFIRMATION

V1ZRC3Ack.Ord.EDI (V2 SYC)ZRC3  Ack.Ord.EDI (V2 SYC)Z_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZRS2ORD RESP APRIS INDENZRS2  ORD RESP APRIS INDENZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZRSPAck.Ord.EDI (V2 SYC)ZRSP  Ack.Ord.EDI (V2 SYC)Z_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZRSPAck.Ord.EDI (V2 SYC)ZRSP  Ack.Ord.EDI (V2 SYC)Z_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZRSTTech.Ack.ord EDI(V2)ZRST  Tech.Ack.ord EDI(V2)Z_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZRSTTech.Ack.ord EDI(V2)ZRST  Tech.Ack.ord EDI(V2)Z_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZSTCAERO O.F reject STOZSTC  AERO O.F reject STO


V1ZSTOAERO Overf whse STOZSTO  AERO Overf whse STO


V1ZSTOAERO Overf whse STOZSTO  AERO Overf whse STO


V1ZSY2ORDRSP to PO. SYCZSY2  ORDRSP to PO. SYC


V1ZSYCORDRSP to SYCOMOREZSYC  ORDRSP to SYCOMORE


V1ZTP1TP - Mail creatZTP1  TP - Mail creat


V1BA00Order ConfirmationBA00  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC10Order ConfirmationZC10  Order ConfirmationORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC11Order Conf. (Copy C)ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION

V1ZC12Order Conf. (I.Copy)ZC12  Order Conf. (I.Copy)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC13Order Conf. (No Pr.)ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION

V1ZC14Order Conf. (T)ZC14  Order Conf. (T)ORDER_CONFIRMATION

V1ZC14Order Conf. (T)ZC14  Order Conf. (T)ORDER_CONFIRMATION

V1ZC14Order Conf. (T)ZC14  Order Conf. (T)ORDER_CONFIRMATION

V1ZC15ContractZC15  ContractSALES_CONTRACT

V1ZC15ContractZC15  ContractSALES_CONTRACT

V1ZC15ContractZC15  ContractSALES_CONTRACT

V1ZC15ContractZC15  ContractSALES_CONTRACT

V1ZC15ContractZC15  ContractSALES_CONTRACT

V1ZC16Contract (Copy Cu.)ZC16  Contract (Copy Cu.)SALES_CONTRACT

V1ZC16Contract (Copy Cu.)ZC16  Contract (Copy Cu.)SALES_CONTRACT

V1ZC17Order Conf. One TimeZC17  Order Conf. One TimeORDER_CONFIRMATION

V1ZC17Order Conf. One TimeZC17  Order Conf. One TimeORDER_CONFIRMATION

V1ZC17Order Conf. One TimeZC17  Order Conf. One TimeORDER_CONFIRMATION

V1ZC17Order Conf. One TimeZC17  Order Conf. One TimeORDER_CONFIRMATION

V1ZC17Order Conf. One TimeZC17  Order Conf. One TimeORDER_CONFIRMATION

V1ZC17Order Conf. One TimeZC17  Order Conf. One TimeORDER_CONFIRMATION

V1ZC17Order Conf. One TimeZC17  Order Conf. One TimeORDER_CONFIRMATION

V1ZC19Order Conf. ManualZC19  Order Conf. ManualORDER_CONFIRMATION

V1ZC19Order Conf. ManualZC19  Order Conf. ManualORDER_CONFIRMATION

V1ZC19Order Conf. ManualZC19  Order Conf. ManualORDER_CONFIRMATION

V1ZC19Order Conf. ManualZC19  Order Conf. ManualORDER_CONFIRMATION

V1ZC19Order Conf. ManualZC19  Order Conf. ManualORDER_CONFIRMATION

V1ZC19Order Conf. ManualZC19  Order Conf. ManualORDER_CONFIRMATION

V1ZC2BB2B MessageZC2B  B2B Message


V1ZC2BB2B MessageZC2B  B2B Message


V1ZC2BB2B MessageZC2B  B2B Message


V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCARAcknowled. ReceiptZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCERCertificate of OrigiZCER  Certificate of Origi


V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOEOrder AcknowledgmentZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZCOFOrder Ackn.ment-S2ZCOF  Order Ackn.ment-S2Z_ORDER_ACKNOWLEDGEMENT_EMAIL

V1ZTP1TP - Mail creatZTP1  TP - Mail creat


Transformation Mapping

Mapping Table NameMapping Table Description








Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible













PreLoad Validation

Project Team

Completeness

TaskAction





Accuracy

TaskAction





Business

Completeness

TaskAction





Accuracy

TaskAction





Load

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

Load Run Sheet

Item #Step DescriptionTeam Responsible













Load Phase and Dependencies

Configuration

Item #Configuration Item






Conversion Objects

Object #Preceding Object Conversion Approach

list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)




Error Handling

Error TypeError DescriptionAction Taken










PostLoad Validation

Project Team

Completeness

TaskAction





Accuracy

TaskAction





Business

Completeness

TaskAction





Accuracy

TaskAction





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.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 8) Jan 22, 2026 11:09 THOMAS-ext, Ety
v. 61 Jan 22, 2026 11:04 THOMAS-ext, Ety
v. 60 Jan 21, 2026 11:27 THOMAS-ext, Ety
v. 59 Jan 16, 2026 13:58 THOMAS-ext, Ety
v. 58 Jan 12, 2026 13:14 THOMAS-ext, Ety
v. 57 Dec 02, 2025 12:54 THOMAS-ext, Ety
v. 56 Dec 01, 2025 13:59 THOMAS-ext, Ety
v. 55 Dec 01, 2025 13:46 THOMAS-ext, Ety
v. 54 Dec 01, 2025 13:38 THOMAS-ext, Ety
v. 53 Nov 30, 2025 14:04 THOMAS-ext, Ety

Go to Page History

  • No labels