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

Compare with Current View Page History

« Previous Version 54 Next »

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 and transformation (by Syniti), functional transformation (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 output 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.

  • The tables referenced in this document are intended to illustrate the rationale behind the BRF+ decision tables.

  • Similarly, the legacy tables extracted from ECC will not be migrated as-is. Instead, they will serve as a reference to support the migration and transformation of the relevant objects into the S/4HANA target design.


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, 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);
  • Migration of outputs no longer managed in S/4: Quotations and Contracts (Managed in Salesforce)
  • Migration of output no longer in scope of Sales (V1): SDB outputs (managed in Delivery)
  • 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, 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. Active records where the deletion indicator (LOEKZ) is initial.
  4. 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. Output condition records for customers not in scope of the  CNV-3003 Business Partners - Customer (Sales and Service) - FLCU01 
  3. Output condition records  for Sales areas not in scope.
  4. Output types not used in the current or target S/4HANA sales processes
  5. Records with incomplete or invalid communication data (e.g., missing email for email output medium)
  6. Condition records belonging to applications other than sales (e.g., LE, MM, FI outputs)


Data Profiling

The table below based on the entries in the table NAST outlines the legacy configuration values and numbers. Its purpose is to demonstrate how these values inform the design and logic of the BRF+ decision tables. 

In addition, the table figures highlight the data that needs to be extracted from ECC systems, even though it will not be migrated into the target S/4HANA target .


SystemApplicationScope

Source Approx No. of NAST 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)


SystemApplicationTable

Table Description

Output Types

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

WP2 V1 SALES OUTPUTS
WP2V1B001Sales Organization/Customer NumberBA00/SDB/ZMCE/ZRC3/ZRS2/ZRSP/ZRST/ZSY2/ZSYC534S4/OPD
WP2V1B005Sales 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

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

WP2V1B502Sales 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

WP2V1B503Sales 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

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

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

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

WP2V1B701Ship Point/SalesDocTyZDOC/1

WP2V1B933Sales org./PO typeZARM/ZAWA/91

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

WP2 V3 INVOICE OUTPUTS
WP2V3B001Sales Organization/Customer NumberFUPI/RD00/RD02/RD04/ZFC1/ZINV/ZRD3/ZRD7
/ZRDA/ZRDB/
952

WP2V3B008Billing TypeZLO1/ZLOT/ZPI3/ZQBC/ZQCA/ZRAR/ZREJ/39

WP2V3B011Sales Organization/Billing TypeZBA1/ZEID/ZEIG/ZEII/ZGST/ZPLD/ZRAC/ZRAR/ZRB0/ZRB1/ZRD0/ZRD1
/ZRD2/ZRD8/ZRDE/ZRDP/ZRDQ/ZRLA/ZRLR/ZRS1/ZRS2/ZRSC/ZRUP/
411

WP2V3B013Sales Org.RD04/ZFMX/ZRAR/ZRD3/ZRD5/ZRD7/ZRMX/ZRS5/9

WP2V3B504Sales organization/ Shipping pointZRD4/ZRD5/ZRD6/ZRDD/ZRN5/ZRN6/ZRS5/ZRS6/1

WP2V3B505Sales organization/Shipping point/Bill-to partyZRD6/ZRN6/ZRS6/3

WP2V3B507Sales organization/Sales office/Bill-to partyZGST/ZLIF/ZLIP/ZRAR/ZRB0/ZRD0/ZRD1/ZRD2/ZRD8/ZRDE/ZRDP/ZREJ/ZRS1/ZRS2/ZRSC/163

WP2V3B511Sales organization/Sales officeZLIF/ZLIP/ZRAR/ZRB0/ZRD0/ZRD1/ZRD2/ZRD8/ZRDE/ZRDP/ZRDQ/ZRS1/ZRS2/ZRSC/53

WP2V3B512Sales organization/Sales office/Commercial assistantZCOR/ZPLD/ZRB0/ZRB1/ZRD0/ZRD1/ZRD2/ZRD5/ZRDE/
ZRDP/ZRDQ/ZRS1/ZRS2/ZRS5/ZRSC/
47

WP2V3B533Sales Org/Distribution Channel/Sales OfficeZRD6/ZRN6/ZRS6/5

WP2V3B539Sales org./Sales Off./Created/Bill. TypeZPLD/ZRB0/ZRB1/ZRD0/ZRD1/ZRD2/ZRD8/ZRDE/ZRS1/ZRSC/1

WP2V3B551Sales org./Doc.cat./Sales Off./Bill toZINV/ZRDC/ZREI/ZRWF/79

WP2V3B552Sales org./Sales Off./Doc.cat./SalesDocTy/e-inv. flagZRDC/ZRWF/788

WP2V3B553Sales Off./Doc.cat./e-inv. flagZREI/ZRWF/85

WP2V3B554Sales org./Sales Off./Doc.cat./e-inv. flagZRDC/ZREI/ZRWF/673

WP2V3B558Sales Organization/Sales Office/Billing TypeZRAC/ZRB0/ZRDE/ZRSC/106

WP2V3B560Sales Off./e-inv. flagZRDC/ZREI/6

WP2V3B569Sales org./Currency/Plant/Bill. TypeZRAR/ZRB0/ZRD0/ZRD3/ZRDE/ZREJ/ZRLA/ZRN5/ZRS2/ZRSC/11

WP2V3B570Sales org./Currency/Bill. TypeZGSU/ZPLD/ZRAR/ZRD5/ZRD8/ZRDE/ZREJ/6

WP2V3B572Sales org./Distr. Chl/Bill. Type/Sold-To PtZGST/ZRB0/ZRDE/ZRSC/21

WP2V3B889Sales org./Sold-to ptZRDC/ZRWF/27

WP2V3B910Interco. billing: Org.comm./Bill-toZGST/ZRB0/ZRD0/ZRD1/ZRD5/ZRD8/ZRDE/ZRDQ/ZRLA/ZRLR/ZRN5/ZRS5/ZRSC/37

WP2V3B923Sales Organization/Distribution Channel/Bill-to partyZGST/ZLIF/ZRB0/ZRD0/ZRD5/ZRDE/ZRS1/ZRS5/ZRSC/51

WP2V3B953Sales org./Bill.type/PayerZRDA/ZRGE/84

WP2V3B955Sales org./Ship.point/Bill.type/RecipCntryZRM6/6541

WP2V3B957Sales organization/Billing type/Bill-to partyZINV/ZRD5/ZRDA/ZRDB/ZRS5/7326

WP2V3B960e-invoicingZRAR/ZREJ/ZRS2/1

WP2V3B962Sales Organization/Distribution Channel/Billing Type/Ship-toZLIF/ZRB0/ZRD0/ZRDE/ZRGE/ZRS1/ZRSC/72

WP2V3B995Sales Org/Sales Office/Billing Type/Dest countryZRDE/ZRS2/44

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

PF2V1B005Sales 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

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

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

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

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

PF2V1B913Sales officeZC10/ZC11/ZC13/ZC15/ZCAR/31

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

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

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

PF2V1B938Sales organization/Purchase order type/CustomerZC2B/24

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

PF2V1B956Sales office/Shipping conditions/PlantZC30/ZC32/34

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

PF2V1B972Sales office/Shipping conditions/Contact AgentZC31/1

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

PF2V1B989Sales Organization/Customer/Sales Document TypeZC2B/4

PF2 V3 INVOICE OUTPUTS
PF2

V3

B001Sales Organization/Customer NumberFUPI/RD00/RD02/RD04/ZFC1/ZINV/ZRD3/ZRD7/ZRDA/ZRDB/2966

PF2V3B006SOrg./Distrib.Ch/Division/CustomerRD04387

PF2V3B008Billing TypeZQBC2

PF2V3B011Sales 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

PF2V3B013Sales Org.RD04/ZFMX/ZRAR/ZRD3/ZRD5/ZRD7/ZRMX/ZRS5/63

PF2V3B840Sales office / Sold-to Doc type / Billing TypeZF00/35

PF2V3B841Sales office / Sold-to Doc typeZF00/ZF0R/ZF1R/122

PF2V3B913Sales officeZF00/ZF01/ZF05/ZFCF/110

PF2V3B916Bill-to partyZF01/2

PF2V3B919Sales office/Bill-to party/Billing typeZF00/ZF01/ZF30/1332

PF2V3B920Bill.type/Sales org./RecipCntryZF00/ZF01/14

PF2V3B921Sales office/Bill-to partyZF00/ZF01/ZF05/ZF10/14365

PF2V3B927Billing type/Bill-to partyRD06/ZF06/ZF17/72

PF2V3B932PayerZF00/192

PF2V3B935Sales organization/Shipping point/Billing typeZF15/ZF16/69

PF2V3B937Payer/Billing typeZF00/ZF01/986

PF2V3B939Sales office/Manual invoice maintenanceZF00/ZF01/ZF05/28

PF2V3B940Sales office/Bill-to party/Manual invoice maintenanceZF01/46

PF2V3B942Sales office/Country (Bill-to party)ZF00/ZF01/ZF05/ZF10/271

PF2V3B953Sales office/Sales groupZF00/ZF01/72

PF2V3B958Sales off./Sales org./Bill.typeZF00/71

PF2V3B963Sales org./Contact agent/Bill.typeZFCA/1056

PF2V3B966Sales org./Payer/Bill.typeZF00/ZF01/ZF02/ZFCF/ZFMX/32553

PF2V3B967Sales Organization/PO type/Sold-to partyZF2B/1

PF2V3B973Bill.type/Sales org./RecipCntry/PayerZF01/ZF99/96

PF2V3B974Sales organization/Billing type/Bill-to partyRD06/ZF15/ZF16/ZF17/ZFIL/ZFIM/1882

PF2V3B975Sales organization/Billing type/Delivering countryZF15/23

PF2V3B985Sales organization/Sold-to party
11

PF2V3B993Sales Organization/Billing Type/Destination CountryZF15/16

PF2V3B998Sales organization/PayerZFIL/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 DT Templates will be version-controlled in Confluence and Jira.

Legal Requirement

N/A

Special Requirements

N/A





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 (Email, Print, EDI, IDoc)
  3. Form Template (Adobe Form)
  4. Receiver (Partner Function)
  5. 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 will change once the final design  has been confirmed.

SALES DECISION TABLES:

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

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
DT_FORM_TEMPLATEOutput TypeSales OrgDistribution ChannelDivisionSales OfficeRoleChannelSender Ctry/RegReceiver Ctry/RegReceiver LanguageForm templateForm Language


BILLING DECISION TABLES:
Decision Table NameInput Parameter 1Input Parameter 2Input Parameter 3Input Parameter 4Input Parameter 5Input Parameter 6Input Parameter 7Input Parameter 8Input Parameter 9Input Parameter 10ResultResult
DT_OUTPUT_TYPEDocument Cat.Billing TypeSales Org.Distr. ChannelDivisionSales OfficeSales GroupBill to party

Output TypeDispatch Time
DT_RECEIVEROutput Type








Partner RoleExclusive Indicator
DT_CHANNELOutput TypePartner RoleSales Org.Distr. ChannelDivisionSales OfficeRecipientCustomer Group 5

Channel
DT_PRINTEROutput TypeSales Org.Distribution ChannelDivisionSales OfficeBilling Type



Print QueueNumber of Copies
DT_EMAIL_SETTINGOutput TypePartner RoleSales Org.Distr. ChannelDivisionSales OfficeBilling Type


Sender EmailEmail Template
DT_EMAIL_RECEIVEROutput TypePartner Role







Email Type CodeE-Mail Address
DT_FORM_TEMPLATEOutput TypeSales Org.Sender Ctry/Reg.Recipient Ctry/Reg.Recipient LanguageDocument Cat.Billing Type


Form TemplateForm Language
DT_OUTPUT_RELEVANCEOutput TypeDocument CategoryPosting StatusBilling TypeSales Org.Bill to PartyReceiver Ctry/Reg


Relevance Indicator

Data Cleansing

N/A

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 SQL-based queries executed directly on the source database.

The extraction process is required to join those B* condition tables—which contain a link to a business partner (KUNNR, KUNAG, KUNRE, KUNRG) or  contain a large number of entries for a single output type—to the NACH table. This approach enables identification of the output medium and the output language and ensures that all relevant configuration records are captured.

The extracted data will not be migrated directly; instead, it will be used to:

  • Update the business partner attributes that determine the appropriate outputs and channels. 
  • Populate the data collection files based on the BRF+ decision table setup.

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

There will therefore be 2 different sets of Data collection templates (DCT)

  • An initial set  based on the legacy BXXX tables that will include all relevant information to facilitate the subsequent uploads. It will be referred to "RT_OUTPUT_CONDITIONS"
  • A subsequent set of OPD DCT tables, referred to as DCT_OPD_DECISION_TABLES

Source Tables to be extracted:

Following Bxxx tables relate to output conditions linked to business partners as well as tables with  multiple entries. The whole table needs to be extracted:


BXXX TABLES

System AppTable-NameDescriptionField 1Field 2Field 3Field 4Field 5Field 6Comment
PF2V1/V3B001Sales Organization/Customer NumberKAPPLKSCHLVKORGKNDNR


PF2V1/V3B006SOrg./Distrib.Ch/Division/CustomerKAPPLKSCHLVKORGVTWEGSPARTKNDNR
PF2V3B866Sales Organization/Division/CustomerKAPPLKSCHLVKORGSPARTKNDNR

PF2V3B867Sales Organization/Division/Customer/Quality codeKAPPLKSCHLVKORGSPARTKNDNRMVGR3
PF2V1B891Sales Office/Customer/SalesDocTypeKAPPLKSCHLVKBURKNDNRAUART
No Sales org
PF2V1B918Sales Office/Sold-to PartyKAPPLKSCHLVKBURKUNNR

No Sales org
PF2V3B919Sales Office/Bill-to Party/Billing TypeKAPPLKSCHLVKBURKUNREFKART
No Sales org
PF2V3B921Sales Office/Bill-to PartyKAPPLKSCHLVKBURKUNRE

No Sales org
PF2V3B927Billing type/Bill-to partyKAPPLKSCHLFKARTKUNRE

No Sales org
PF2V3B932PayerKAPPLKSCHLKUNRE


No Sales org
PF2V3B937Payer/Billing typeKAPPLKSCHLKUNRGFKART

No Sales org
PF2V1B938Sales organization/Purchase order type/CustomerKAPPLKSCHLVKORGBSARKKNDNR

PF2V3B940Sales office/Bill-to party/Manual invoice maintenanceKAPPLKSCHLVKBURKUNREMRNKZ
No Sales org
PF2V3B966Sales Org/Payer/Billing TypeKAPPLKSCHLVKORGKUNRGFKART

PF2V3B973Bill.type/Sales org./RecipCntry/PayerKAPPLKSCHLFKARTVKORGLAND1KUNRG
PF2V3B974Sales Org/Billing Type/Bill-to PartyKAPPLKSCHLVKORGFKARTKUNRE

PF2V1B989Sales Organization/Customer/Sales Document TypeKAPPLKSCHLVKORGKNDNRAUART

PF2V3B998Sales organization/PayerKAPPLKSCHLVKORGKUNRG













WP2V1/V3B001Sales Organization/Customer NumberKAPPLKSCHLVKORGKNDNR


WP2V1B005Sales Organization/Order TypeKAPPLKSCHLVKORGAUART

No customer, 2441 entries
WP2V3B505Sales organization/Shipping point/Bill-to partyKAPPLKSCHLVKORGZZVSTELKUNRE

WP2V3B507Sales organization/Sales office/Bill-to partyKAPPLKSCHLVKORGZZVKBURKUNRE

WP2V3B551Sales org./Doc.cat./Sales Off./Bill toKAPPLKSCHLVKORGVBTYPZZVKBURKUNRE
WP2V3B572Sales org./Distr. Chl/Bill. Type/Sold-To PtKAPPLKSCHLVKORGVTWEGFKARTKUNAG
WP2V3B889Sales org./Sold-to ptKAPPLKSCHLVKORGKUNAG


WP2V3B910Interco. billing: Org.comm./Bill-toKAPPLKSCHLVKORGKUNRE


WP2V3B923Sales Organization/Distribution Channel/Bill-to partyKAPPLKSCHLVKORGVTWEGKUNRE

WP2V3B924Sales org./Distr. Chl/Bill to/Del. typeKAPPLKSCHLVKORGVTWEGKUNRELFART
WP2V1B934Sales org./PO type/Sold-to ptKAPPLKSCHLVKORGBSARKKUNNR

WP2V3B953Sales org./Bill.type/PayerKAPPLKSCHLVKORGVTWEGFKARTKUNWE
WP2V3B955Sales org./Ship.point/Bill.type/RecipCntryKAPPLKSCHLVKORGZZVSTELFKARTLAND1No customer, 6541 entries
WP2V3B957Sales organization/Billing type/Bill-to partyKAPPLKSCHLVKORGFKARTKUNRE

WP2V3B962Sales Organization/Distribution Channel/Billing Type/Ship-toKAPPLKSCHLVKORGVTWEGFKARTKUNWE
WP2V3B964Sales org./Ship Point/Bill. Type/Ship-toKAPPLKSCHLVKORGZZVSTELFKARTKUNWE












The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads (relevant sales Organisation

NACH TABLE

 TableFieldFieldData TypeLengthShort DescriptionRequirement
1NACHMANDTMANDTCLNT3ClientMandatory
5NACHKVEWEKVEWECHAR1Usage of the condition tableMandatory
6NACHKOTABNRKOTABNRCHAR3Condition tableMandatory
7NACHKAPPLKAPPLCHAR2ApplicationMandatory
8NACHKSCHLKSCHL_OCCHAR4Condition TypeMandatory
13NACHPARVWPARVWCHAR2Partner FunctionMandatory
14NACHPARNRNA_PARNR_OCCHAR10Message partnerMandatory
15NACHNACHANA_NACHACHAR1Message transmission mediumMandatory
17NACHVSZTPNA_VSZTPCHAR1Dispatch timeMandatory
18NACHSPRASSPRASLANG1Language KeyOptional


Extraction Run Sheet


001 WP2 V1 /V3

NACH

NACH-KVEWE = 'B' (Usage Output)

NACH-KAPPL = 'V1' (Application Sales Order)  OR 'V3' (Application Billing)

NACH-KOTABNR    ( Tables: above )     

NACH-KSCHL    (Output types)

NACH-NACHA (Transmission Medium)

NACH-PARVW (Partner)

NACH-SPRAS ((Language)


001 PF2 V1 /V3

NACH

NACH-KVEWE 'B' (Usage Output)

NACH-KAPPL = 'V1' (Application Sales Order)  OR 'V3' (Application Billing)

NACH-KOTABNR    ( Tables: above )     

NACH-KSCHL    (Output types)

NACH-NACHA (Transmission Medium)

NACH-PARVW (Partner)

NACH-SPRAS (Language)


001 WP2 V1/V3

B TABLES

 


001 PF2 V1/V3

B TABLES

 




Selection Screen


Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
Not applicable




Report Tables (RT):

RT_OUTPUT_CONDITIONS

The legacy output conditions from the B table will be combined with their  corresponding medium / partner and language from table NACH  in a report Table called RT_OUPUT_CONDITIONS.   An additional column will be added to cater for following exceptions:

  • a table / table entry without a Sales organisation
  • a table / table entry without a customer 
  • A duplicate (or more) entry for a customer number 

As  we are dealing with multiple tables with different number of fields, the customer number can be in different positions, and have a  different field  name: 

 The customer  in the BXXX table can be 

  • KUNNR
  • KNDNR
  • KUNAG
  • KUNRE
  • KUNRG
  • KUNWE


The customer number field will be referred to at CUSTNO and depending on the B table will be mapped as follows: (eg. B_TABLE-CUSTNO = B_TABLE-KNDNR if table = B001, B006 etc..)

PF2
WP2
KNDNRB001B006B866B867B876B891B938B989
B001





KUNNRB918







B934





KUNREB919B921B927B932B940B974


B505B507B551B910B923B924B957
KUNRGB937B966B973B998











KUNAG








B572B889




KUNWE








B953B962B964




Data Transformation:


RT_OUTPUT_CONDITIONS

The target audience for the Output Conditions DCT is:

  • the L2C functional team responsible for uploading the various OPD decision tables. These tables will be reviewed by the business.
  • the L2C data team as the L2C functional team responsible for uploading the Business Partners sales view.
    • Each BP's default Medium will be held in Customer Group 4 (sales) and 5 (billing)  rather than being an entry in the Decision table  (TBC)
    • The extraction will allow the following:

      • a table entry that leads to multiple  output Mediums in NACH for the same partner  
      • a table entry that leads to multiple  output Mediums in NACH and partner depending on the condition type
    • New rules need to be agreed by the business and added to manage multiple table entries 


Field NameField DescriptionSourceRuleTarget Table
Target FieldTransformation Logic

TRANSFORMATION LOGIC:

There are 3 types of B tables

  • B* tables without Sales Org                                                                                                        EXCEPTION = "MISSING ORG"  - entry added to report
  • B* tables with Sales Org: (they will only be included if they belong to a relevant sales org) 
    • B* tables without Customer number  (with many entries)                                                    EXCEPTION = "NO CUSTOMER" -  entry added to report
    • B* table with Customer number                                                                                            

B* Tables and NACH table  are linked via field KNUMH. The purpose of the transformation is to obtain the NACH table entry or entries that contains the customer number. The customer number information is contained in NACH-VAKEY and can be the last field (RIGHT,10) or the  2nd field (MID,4,10) for B919,B940,B940 , B924. 

The NACH table entry will also contain the output partner (NACH-PARVW) and medium (NACH-NACHA) 

It is possible to find multiple entries for a given customer, all the entries will be added to the RT_OUTPUT_CONDITIONS and a rule defined by the business will select the relevant one.

As the material number is not available, the sales org transformation should assign all relevant target sales orgs and add them.


B* tables where there is no Sales organisation:

IF TABLE-NAME IN B891,B918,B919,B921,B927,B932,B937,B938 THEN

  • EXCEPTION = "MISSING SORG"

ELSE

 (exclude entries from not relevant Sales Organisation or Customer)

  SELECT  from WP2-BXXX  where  VKORG is in scope and KUNNR is in scope

  SELECT from PF2-BXXX where  VKORG is in scope and KUNNR is in scope

IF TABLE-NAME IN B005 , B995

  • EXCEPTION = "NO CUSTOMER"

IF TABLE-NAME IN B891,B918,B919,B921,B927,B932,B937,B938 THEN

READ NACH (using KNUMH number) where

     NACH-KVEWE                   = 'B'

     NACH-KAPPL                    = B_TABLE-KAPPL 

     NACH-KNUMH                 = B_TABLE_KNUMH

     NACH-KOTABNR               = B_TABLE-NAME   


      RIGHT(NACH-VAKEY,10)   = B_TABLE-CUSTNO    IF TABLE-NAME  <> B919 OR B940 OR B940 OR B924

      ELSE (second field)                                 MID (NACH-VAKEY,4,10)    = B_TABLE-CUSTNO  


  RT_OUTPUT-CUSTNO = B-TABLE-CUSTNO

  RT_OUTPUT-PARVW     = NACH-PARVW 

  RT_OUTPUT-CHANNEL   = NACH-NACHA

  RT-OUTPUT-LANGUAGE = NACH-SPRAS


ADD ENTRY TO TABLE


 SYSTEMSystem PF2/WP2B*
RT_OUTPUT_CONDITIONS
SYSTEMCopy 1:1
APPV1 or V3B*
RT_OUTPUT_CONDITIONS
APPCopy 1:1
TABLE
B*
RT_OUTPUT_CONDITIONS
TABLECopy 1:1
VKORGSales orgB*

If Mapping is 1:N  

Exception = "LEGACY"



RT_OUTPUT_CONDITIONS
SALES ORG

If mapping is 1:1

  • MAP-VKORG 

Else

  • Copy 1:1 (keep Legacy)


VTWEGDistr ChannelB*

If Mapping is 1:N  

Exception = "LEGACY"

RT_OUTPUT_CONDITIONS
DIST CHANNEL

If mapping is 1:1

  • MAP-VTWEG

Else

  • Copy 1:1 (keep Legacy)


SPARTDivisionB*

If Mapping is 1:N  

Exception = "LEGACY"

RT_OUTPUT_CONDITIONS
DIVISION

If mapping is 1:1

  • MAP-SPART

Else

  • Copy 1:1 (keep Legacy)


AUARTSales order TypeB*
RT_OUTPUT_CONDITIONS
ORDER TYPEMAP-AUART
FKARTBilling TypeB*
RT_OUTPUT_CONDITIONS
BILLING TYPEMAP-FKART
VKBURSales officeB*

If Mapping is 1:N  

Exception = "LEGACY"

RT_OUTPUT_CONDITIONS
SALES OFICE

If mapping is 1:1

  • MAP-VKBUR

Else

  • Copy 1:1 (keep Legacy)
LAND1CountryB*
RT_OUTPUT_CONDITIONS
COUNTRYMAP-LAND
BSARKPurchase order typeB*
RT_OUTPUT_CONDITIONS
PO TYPEMAP-BSARK
VKGRPSales groupB*
RT_OUTPUT_CONDITIONS
SALES GROUPMAP-VKGRP
CUSTNO Customer numberB*


RT_OUTPUT_CONDITIONS
CUSTOMER NOCustomer-XREF
CUSTNAMECustomer nameADRCRead customer name from ADRV-NAME1RT_OUTPUT_CONDITIONS
CUSTOMER NAMECOPY 1:1
PARVWPartner typeNACH
RT_OUTPUT_CONDITIONS
PARTNER TYPECOPY 1:1
NACHAOutput MediumNACH
RT_OUTPUT_CONDITIONS
MEDIUMCOPY 1:1
SPRACHLanguageNACH
RT_OUTPUT_CONDITIONS
LANGUAGECOPY 1:1




RT_OUTPUT_CONDITIONS EXCEPTION CODE 



RT_OPD_DECISION_TABLES

The L2C functional team is responsible for uploading the information in the OPD decision tables. Some tables are mainly replacing the legacy condition configuration, and will be populated with predefined values first for business review and update

BRF+ provides a built-in feature to download and upload decision tables as Excel files. 

Steps:

  1. Go to BRF+ application in transaction BRF+ 

  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 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 .
  1. DT_OUTPUT_TYPE
  2. DT_RECEIVER
  3. DT_OUTPUT_CHANNEL
  4. DT_EMAIL_SETTING
  5. DT_EMAIL_RECEIVER
  6. DT_OUTPUT_RELEVANCE
  7. DT_FORM_TEMPLATE


SALES DECISION TABLES

DT_OUTPUT_TYPE: 

DT 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


DT 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: (Partner)

DT Rules:

DT_RECEIVER 

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

ROLE NameRoleXElement (Text )APOC_ROLE_CODE20
X

EXCLUSIVE_INDExclusive IndicatorXElement (Text )APOC_EXCLUSIVE_INDICATOR10
X


DT Template:

Output TypeRoleExclusive Indicator
=Z_ORDER_ACKNOWLEDGEMENT_EMAILAP-
=ORDER_CONFIRMATIONAP-
=ORDER_CONFIRMATIONAG-
=ORDER_CONFIRMATION_CHANGEAG-
=CASH_SALERE-
=CASH_SALE_CHANGERE-
=CUSTOMER_RETURNAG-
=CUSTOMER_RETURN_CHANGEAG-
=DEBIT_MEMO_REQUESTZM-
=DEBIT_MEMO_REQUEST_CHANGEZM-
=CREDIT_MEMO_REQUESTZM-


DT__CHANNEL:     (Medium)

DT 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


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

DT 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




DT Template:

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


DT__EMAIL_SETTING:

DT 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

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

DT 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 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-
=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


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




DT__FORM_TEMPLATE:

DCT_Rules

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

SALESORGANIZATIONSales Org
Element (Text )
10
X

DISTRIBUTIONCHANNELDistribution Channel
Element (Text )
10
X

DIVISIONDivision
Element (Text )
10
X

SALESOFFICESales Office
Element (Text )
20
X

ROLERole
Element (Text )
20
X

CHANNELChannel
Element (Text )
10
X

SENDER_COUNTRYSender Ctry/Reg
Element (Text )
20
X

RECEIVER_COUNTRYReceiver Ctry/Reg
Element (Text )
20
X

RECEIVER_LANGUAGEReceiver Language
Element (Text )
20
X

FORM_TEMPLATE_NAMEForm template NameXElement (Text )

0
X

FORM_TEMPLATE_LANGUAGEForm template LanguageXElement (Text )







DT Template:

Output TypeSales OrgDistribution ChannelDivisionSales OfficeRoleChannelSender Ctry/RegReceiver Ctry/RegReceiver LanguageForm template NameForm Template Language
=Z_ORDER_ACKNOWLEDGEMENT_EMAIL=" "




" "

XX


BILLING DECISION TABLES

DT_OUTPUT_TYPE: 

DT Rules:

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



BILLINGDOCUMENTTYPEBilling Type
Element (Text )FKART40
X

SALESORGANIZATIONSales Org.
Element (Text )VKORG40
X

DISTRIBUTIONCHANNELDistr. Channel
Element (Text )VTWEG20
X

DIVISIONDivision
Element (Text )SPART20
X

SALESOFFICESales Office
Element (Text )VKGRP20
X

SALESGROUPSales Group
Element (Text )VKBUR40
X

Bill to partyBill to party
Element (Text )KUNNR100
X

OUTPUT_TYPEOutput TypeXElement (Text )APOC_OUTPUT_TYPE300
X

DISPATCH_TIMEDispatch TimeXElement (Text )APOC_OR_DISPATCH_TIME10
X

DT Template: 


Document categoryBilling Doc TypeSales OrgDistribution ChannelDivisionSales OfficeSales GroupBill-to PartnerOutput TypeDispatch Time








XX


DT_RECEIVER: (Partner)

DT Rules:

DT_RECEIVER 

Description(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


DT Template:

Output TypeRoleExclusive Indicator








DT_CHANNEL: (Medium)

DT Rules:


Description(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

DIVISIONDivision
Element (Text )SPART20
X

SALESOFFICESales Office
Element (Text )
20
X

BUSINESS_PARTNER_IDRecipient
Element (Text )APOC_RECEIVER_ID100
X

CUSTOMERGROUP5Customer Group 5
Element (Text )KDGRP20
X

CHANNELChannelXElement (Text )APOC_CHANNEL50
X

EXCLUSIVE_INDExclusive IndicatorXElement (Text )APOC_EXCLUSIVE_INDICATOR10
X


DT_PRINTER

DT Rules:


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

SALESORGANIZATIONSales Org.
Element (Text )VKORG40
X

DISTRIBUTIONCHANNELDistr. Channel
Element (Text )VTWEG20
X

DIVISIONDivision
Element (Text )SPART20
X

SALESOFFICESales Office
Element (Text )
20
X

BILLINGDOCUMENTTYPEBilling Type
Element (Text )FKART40
X

PRINT_QUEUE_NAMEPrint QueueXElement (Text )APOC_PRINT_QUEUE320
X

NUMBER_OF_COPIESNumber of CopiesXElement (Number )APOC_NUMBER_OF_COPIES50X



DT_EMAIL_SETTING

DT Rules:


Description(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

DIVISIONDivision
Element (Text )SPART20
X

SALESOFFICESales Office
Element (Text )
20
X

BILLINGDOCUMENTTYPEBilling Type
Element (Text )FKART40
X

EMAIL_FROMSender EmailXElement (Text )APOC_SENDER_EMAIL_ADDR2410



EMAIL_TEMPLATE_IDEmail TemplateXElement (Text )APOC_EMAIL_TEMPLATE300
X


DT_EMAIL_RECEIVER

DT Rules:


Description(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




DT_FORM_TEMPLATE: ()

DT Rules:


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

SALESORGANIZATIONSales Org.
Element (Text )VKORG40
X

SENDER_COUNTRY

Sender Ctry/Reg.


Element (Text )APOC_SENDER_COUNTRY30
X

RECEIVER_COUNTRY

Recipient Ctry/Reg.


Element (Text )APOC_RECEIVER_COUNTRY30
X

RECEIVER_LANGUAGE

Recipient Language


Element (Text )APOC_RECEIVER_LANGUAGE10



SDDOCUMENTCATEGORYDocument Cat.
Element (Text )VBTYPL40



BILLINGDOCUMENTTYPEBilling Type
Element (Text )FKART40
X

FORM_TEMPLATE_NAMEForm TemplateXElement (Text )APOC_FORM_TEMPLATE_ID300
X

FORM_TEMPLATE_LANGUAGEForm LanguageXElement (Text )APOC_FORM_TEMPLATE_LANGUAGE10




DT Template:

Output TypeSales OrgSender Country/RegRecipient Ctry/Reg.Recipient LanguageDocument Cat.Billing TypeForm template NameForm Template Language

=" "




XX


DT_OUTPUT_RELEVANCE: ()

DT Rules:


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

SDDOCUMENTCATEGORYDocument Cat.
Element (Text )VBTYPL40



ACCOUNTINGTRANSFERSTATUSPosting Status
Element (Text )RFBSK10
X

BILLINGDOCUMENTTYPEBilling Type
Element (Text )FKART40
X

SALESORGANIZATIONSales Org.
Element (Text )VKORG40
X

Bill to partyBill to party
Element (Text )KUNNR100
X

RECEIVER_COUNTRY

Recipient Ctry/Reg.


Element (Text )APOC_RECEIVER_COUNTRY30
X

RELEVANCE_INDRelevance IndicatorXElement (Text )APOC_RELEVANCE_INDICATOR10
X


DT Template:

Output TypeDocument Cat.Posting statusBilling Typesales OrgBill-to partnerRecipient Ctry/Reg.Relevance IndicatorAll ItemsChannelExclusive Indicator

=" "




" "
EMAIL-




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.
Syniti
3

Referential Integrity

  • Ensure dependent records are extracted together.
Syniti
4

Extraction Methodology

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

Performance and Scalability Considerations

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

Security and Compliance

  • Adhere to regulatory standards for sensitive information if applicable
Syniti


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 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.



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:

ApplicationMEDIUMCHANNEL
V1/V3ALE
V1/V3EDIEDI
V1/V3EXTERNAL SENDIDOC / PRINT / EMAIL
V1/V3PRINTPRINT
V1/V3MAILMAIL
V1/V3SPECIAL FUNCTIONIDOC / PRINT / EMAIL



The table below contains  the list of legacy output conditions that were triggered between 1st and 15th Nov 2025. Please also note that conditions no longer associated to V1 have been excluded.  

 SystemApplicationOutput TypeCondition type NameBRF+ Output Type

Print output

1

Fax

2

External Send 5

EDI

6

Simple Mail

7

Special function 8

Distribution (ALE)    A

PF2V1BA00BA00  Order ConfirmationORDER_CONFIRMATION






PF2V1ZC10ZC10  Order ConfirmationORDER_CONFIRMATION2401
685



PF2V1ZC11ZC11  Order Conf. (Copy C)ORDER_CONFIRMATION24
17



PF2V1ZC13ZC13  Order Conf. (No Pr.)ORDER_CONFIRMATION40
34



PF2V1ZC17ZC17  Order Conf. One TimeORDER_CONFIRMATION2304
2116



PF2V1ZC19ZC19  Order Conf. ManualORDER_CONFIRMATION2130
 1895



PF2V1ZC2BZC2B  B2B MessageORDER_CONFIRMATION2





PQF2V1ZC35ZC35  Transmission LetterORDER_CONFIRMATION18





PQF2V1ZC36ZC36  Trans. Letter (C)ORDER_CONFIRMATION17





PQF2V1ZTP1ZTP1  TP - Mail creatORDER_CONFIRMATION






PQF2V1ZCARZCAR  Acknowled. ReceiptZ_ORDER_ACKNOWLEDGEMENT

1163



PQF2V1ZCOEZCOE  Order AcknowledgmentZ_ORDER_ACKNOWLEDGEMENT

477















WP2V1ZAARArchive Ord Con AeroORDER_CONFIRMATION3236





WP2V1ZAN0QuotationORDER_CONFIRMATION




148
WP2V1ZAN1QuotationORDER_CONFIRMATION84



 
WP2V1ZARCPDF by mailORDER_CONFIRMATION




3831
WP2V1ZARDPDF by mailORDER_CONFIRMATION




3278
WP2V1ZAREOrder Confirm AeroORDER_CONFIRMATION682





WP2V1ZARMOrder creation EmailORDER_CONFIRMATION




1520
WP2V1ZAWAEMail to AssistantORDER_CONFIRMATION




125
WP2V1ZBA1Order ConfirmationORDER_CONFIRMATION85





WP2V1ZBA2Order ConfirmationORDER_CONFIRMATION702





WP2V1ZBA5Order ConfirmationORDER_CONFIRMATION
1




WP2V1ZBA8Order ConfirmationORDER_CONFIRMATION
6




WP2V1ZBA9Order acknoled  AsiaZ_ORDER_ACKNOWLEGEMENT331





WP2V1ZBACEP Contract -  AsiaCONTRACT22





WP2V1ZBARArchive Ord.Conf.ORDER_CONFIRMATION1328





WP2V1ZBSCOrd.Confirmation GTCORDER_CONFIRMATION688





WP2V1ZDOCDocument creationORDER_CONFIRMATION




1
WP2V1ZMRCeOrd. Conf. to Cust.ORDER_CONFIRMATION




873
WP2V1ZMRMeOrd. Ackn. To CustORDER_CONFIRMATION


1
517
WP2V1ZPI1Monitoring 1er orderORDER_CONFIRMATION




26690
WP2V1ZRSPAck.Ord.EDI (V2 SYC)ORDER_CONFIRMATION





565
WP2V1ZRSTTech.Ack.ord EDI(V2)ORDER_CONFIRMATION





2
WP2V1ZSTCAERO O.F reject STOORDER_CONFIRMATION


1
6957
WP2V1ZTP1TP - Mail creatORDER_CONFIRMATION




156












PF2V3RD04RD04  InvoiceReceipt FI IV






2997
PF2V3RD06RD06  Inv. Bridge ERP/RCS







PF2V3ZF00ZF00  Invoice
1025
1053



PF2V3ZF01ZF01  Invoice (C. Cust.)
204
168



PF2V3ZF02ZF02  Invoice (C. Acc.Dep)
2100





PF2V3ZF06ZF06  Invoice (C.Loc.cur.)
5





PF2V3ZF0RZF0R  Invoice archive
443





PF2V3ZF15ZF15  Customs/Prof Invoice
64579
232



PF2V3ZF16ZF16  Export document







PF2V3ZF17ZF17  Customs Invoice (C)


296



PF2V3ZF1RZF1R  Inv. archive w/o T&C







PF2V3ZF99ZF99  Invoice (Copy BG)







PF2V3ZFCFZFCF  Invoice (C. Frwd)
27





PF2V3ZFEIZFEI  Excise Invoice IN
29





PF2V3ZFILZFIL  Invoice list
66





PF2V3ZFIMZFIM  Invoice list(C.Cust)


25





PF2V3ZFMXZFMX  Invoice (MX)







PF2V3ZQBCZQBC  Batch cert for India



















WP2V3RD04Invoice Receipt MM



191


WP2V3ZCORCert of Origin(Asia)
21





WP2V3ZEIDIN Excise inv depot
105





WP2V3ZEIGIN Form 403 gujarat
225





WP2V3ZEIIIN Excise invoice
225





WP2V3ZFMXXML invoice (MX)





108
WP2V3ZGSCIN GST Credit Memo
1





WP2V3ZGSEIN GST Exportinvoice
17





WP2V3ZGSTIN GST invoice
112


14

WP2V3ZGSUIN GST Subcontractin
18





WP2V3ZINVEDI: Invoice






86
WP2V3ZLOTBatch number recov.





5
WP2V3ZPI3Pilotage





4492
WP2V3ZPLDPack List (Dropship)
84





WP2V3ZQBCBatch cert for India
18





WP2V3ZQCACOA for deliveries





153
WP2V3ZRACOriginal Inv Aero
1163





WP2V3ZRARInvoice archive
22166





WP2V3ZRB0Original Asian Inv
1447





WP2V3ZRB1duplicata Asian Inv
46





WP2V3ZRBIAsian Pro-forma INV
4





WP2V3ZRD0Original Invoice
221





WP2V3ZRD1Invoice
215





WP2V3ZRD2Invoice comm. assit
1





WP2V3ZRD3Invoice for accounti
125





WP2V3ZRD5Export Invoice
172





WP2V3ZRD6Plant Invoice
277





WP2V3ZRD7Inv for plant abroad
1





WP2V3ZRD8Orig Inv Letter
40





WP2V3ZRDAInvoice Direct Ship.



328


WP2V3ZRDBIntercoBridg RCS/ERP



78


WP2V3ZRDCeInvoice PDF by mail





1522
WP2V3ZRDDInvoice Customs Mono
4





WP2V3ZRDEInv by mail to ZI





829
WP2V3ZRDFProforma Inv.RE
5





WP2V3ZREITrad revers ex inv






417
WP2V3ZRLALetter of Auth. CN
199





WP2V3ZRLRInvoice List
29





WP2V3ZRM6PDF Invoice by email




141

WP2V3ZRMXInvoice mexico
129





WP2V3ZRN5Export Invoice Lett
38





WP2V3ZRN6Plant Invoice Letter
195





WP2
ZRS1Invoice Cust. copy
4





WP2
ZRS2ORD RESP APRIS INDEN
2001





WP2
ZRS5Export Invoice
165





WP2
ZRS6Plant Invoice
39





WP2
ZRSCOriginal Invoice GTC
219





WP2
ZRWFWorkflow





48


List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.

Transformation Mapping


Mapping Table NameMapping Table Description
Not Applicable






Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Decision Tables are completeFunctional Team (L2C) + Data Team (L2C)
2OPD configuration is completeFunctional Team (L2C) + Data Team (L2C)
3Org structure configuration is completeFunctional Team (L2C) + Data Team (L2C)
4Dependent Master Data records for Customer and Material are loadedFunctional Team (L2C) + Data Team (L2C)


PreLoad Validation

Project Team

Completeness

TaskAction
Configuration

Ensure necessary configurations are in place in target system 

Check ValuesValidate the pre-load data confirming the values are aligned with BRF+ configuration
Validate template structure and required field populationEnsure mandatory fields as per the definition table are available

Accuracy

TaskAction
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

TaskAction
CompletenessReview and confirm if the extraction contain all the relevant DT and DT entries





Accuracy

TaskAction
CompletenessReview and confirm if the extraction contain all the accurate DT and DT entries





Load

The load process includes:

  1. 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
  2. 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:

  1. Go to BRF+ application in transaction BRF+ 

  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 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 DescriptionTeam 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+ configurationsEnsure configurations are complete for the target system and mapping tables are updated accordingly
Organization DataEnsure configurations for all the organization units are imported into the target system

Conversion Objects

Object #Preceding Object Conversion Approach
Material MasterMaterial Master Basic and Sales View
Business PartnerBusiness Partner Basic and Sales View


Error Handling


Error TypeError DescriptionAction Taken
Authorization ErrorsLack of access to execute load in target client/systemRaised access request; obtained necessary authorizations
Obsolete Master DataCustomer or material master data no longer exists in target systemReplaced or removed based on business input
Technical Load FailureFile not processed due to syntax/format error or system issueReviewed logs; regenerated file; re-executed load after resolving issue
Missing  DependenciesDependent records (Order types, business partners, Email Addresses) not availableReviewed config dependencies; coordinated with config team for correction


PostLoad Validation

Project Team


Completeness

TaskAction
Download DT in target as described before





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. 54) 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