Status	Revision in Progress
Owner	CHAN-ext, Beng Chee MADHOK-ext, Jasleen
Stakeholders

Purpose

The purpose of the document is to define the data conversion approach to create Business Partners – 3^rd Party Suppliers through FLVN01 Supplier Role including partner function/bank/tax view in S/4 HANA.

Conversion Scope

The scope of this document covers the approach for converting active Vendor Master purchasing attributes records from Legacy Source Systems into Business Partner – Supplier Role FLVN001 in S/4 HANA following the Vendor Master Data Design Standard.

The data from legacy system includes:

Vendors’ relevant purchasing data with potential duplicate records
Vendors’ relevant purchasing data with potential missing information such as partner function, bank, tax, etc related fields

The data from legacy system excludes:

Vendors blocked or marked for deletion.
Purchasing organization not in scope
Inactive vendors with no transactions for the past 2 years
Employee Vendor where account group LFA1-KTOKK is ('ZZPE' in PF2, 'Z012' in WP2)
Commission Agent where account group LFA1-KTOKK is 'ZXAG'
Catalog Supplier where Attribute 6 LFA1-ZZLATR6 is not BLANK
Intercompany Vendor Class LFA1-ZZR_SEGT_ATTR is 'G'

List of source systems and approximate number of records

Source

Scope

Source Approx No. of Records

Target System

Target Approx

No. of Records

PF1, WP1

Supplier role is applicable only for legally registered entities and strictly adheres to Master Data Standards (MDS) which elaborates out these criteria and other requirements such as Partner Function, Bank and Tax details being mandatory information used across Business Partner.

Identified relevant suppliers from the Global level relevancy. Relevant suppliers with valid purchasing organization extensions in source systems will be in-scope for deduplication analysis.

Deduplication exercise will check duplicates at purchasing organization level and business will choose the source of supplier role attributes to be used for migration. Otherwise, if record has no duplicates, it automatically becomes the source for supplier master data transformation.

(for further relevancy scope, refer to Business Partner – General DCS)

40,000

S/4 HANA

40,000

Additional Information

Multi-language Requirement

Will follow multi-language allowed and created in Business Partner - General.

Document Management

N/A

Legal Requirement

N/A

Special Requirements

TBD

Target Design

The Business Partner - Supplier master data strictly adheres to Master Data Standards as specified below.

The technical design of the target for this conversion approach.

Table	Field	Field Description	Requirement
LFM1	LIFNR	SUPPLIER NUMBER	R
LFM1	EKORG	PURCHASING ORGANISATION	R
LFM1	EKGRP	PURCHASING GROUP	O
LFM1	WAERS	ORDER CURRENCY	C
LFM1	VERKF	SALESPERSON	O
LFM1	TELF1	TELEPHONE	O
LFM1	MINBW	MINIMUM ORDER VALUE	O
LFM1	ZTERM	PAYMENT TERMS	C
LFM1	INCOV	INCO VERSION	O
LFM1	INCO1	INCOTERMS	C
LFM1	INCO2_L	INCOTERMS LOCATION 1	O
LFM1	INCO3_L	INCOTERMS LOCATION 2	O
LFM1	KALSK	SCHEMA GROUP SUPPLIER	O
LFM1	PLIFZ	PLANNED DELIVERY TIME	O
LFM1	LFABC	ABC INDICATOR	O
LFM1	VSBED	SHIPPING CONDITIONS	C
LFM1	WEBRE	GR-BASED INVOICE VERIFICATION	C
LFM1	KZAUT	AUTOMATIC PURCHASE ORDER	O
LFM1	MEPRF	PRICING DATE CONTROL	O
LFM1	BSTAE	CONFIRMATION CONTROL KEY	O
LFM1	KZRET	RETURNS SUPPLIER	O
LFM1	AUBEL	AUTOMATIC DEBIT	O
LFM1	VALID_PRO	SETTLEMENT PROFILE	O
LFM1	HSCABS	ABSOLUTE HANDLING SURCHARGE	O
LFM1	HSCPE	PERCENTAGE HANDLING SURCHARGE	O
LFM1	HSCMIN	MINIMUM HANDLING SURCHARGE	O
LFM1	HSCMAX	MAXIMUM HANDLING SURCHARGE	O
LFM1	XERSY	AUTOM EVALUATED RECEIPT SETTLEMENT (ERS)	C
LFM1	XERSR	AUTOM EVALUATED GR SETTLEMENT RETURN	C
LFM1	KZABS	ORDER ACKNOWLEDGMENT REQUIREMENT	C
WYT3	LIFNR	SUPPLIER	R
WYT3	EKORG	PURCHASING ORG	R
WYT3	PARVW	PARTNER FUNCTION	R
WYT3	LIFN2	REF TO VENDOR	C
WYT3	PERNR	PERSONAL NO	O
WYT3	PARNR	CONTACT PERSON	O
WYT3	DEFPA	DEFAULT PARTNER	O
Function - READ_TEXT (STHX header table)	LIFNR	SUPPLIER	R
Function - READ_TEXT (STHX header table)	EKORG	PURCHASING ORGANIZATION	R
Function - READ_TEXT (STHX header table)	TDID	TEXT ID	R
Function - READ_TEXT (STHX header table)	TEXT_TDSPRAS	LANGUAGE KEY	R
Function - READ_TEXT (STHX header table)	TEXT_LINES	TEXT	R
ADRC_NATION LENG (IAV)	LIFNR	SUPPLIER	R
ADRC_NATION LENG (IAV)	PARNR	CONTACT ID	R
ADRC_NATION		Version ID for International Addresses	R
ADRC_NATION LENG (IAV)	VNAME	FIRST NAME	O
ADRC_NATION LENG (IAV)-LNAME	LNAME	LAST NAME	O
ADRC_NATION LENG (IAV)	MIDDLE	MIDDLE NAME or SECOND FORENAME	O
ADRC_NATION LENG (IAV)-BIRTH	BIRTH	BIRTH NAME	O
ADRC_NATION LENG (IAV)	BUILDING_B	BUILDING B	O
ADRC_NATION LENG (IAV)	ROOM_B	ROOM B	O
ADRC_NATION LENG (IAV)	FLOOR_B	FLOOR B	O
ADRC_NATION LENG (IAV)	CITY	CITY	O
ADRC_NATION LENG (IAV)	STREET	STREET	O
ADRC_NATION LENG (IAV)	HOUSE_NO	HOUSE NUMBER	O
ADRC_NATION LENG (IAV)	BUILDING	BUILDING	O
ADRC_NATION LENG (IAV)	ROOM	ROOM	O
ADRC_NATION LENG (IAV)	FLOOR	FLOOR	O
FIWTIN_TAN_EXEM	ACCNO	SUPPLIER	R
FIWTIN_TAN_EXEM	BUKRS	COMPANY CODE	R
FIWTIN_TAN_EXEM	SECCODE	SECTION CODE / SECTION CODE GROUP	R
FIWTIN_TAN_EXEM	WT_EXDF	EXEMPTION FROM	O
FIWTIN_TAN_EXEM	WT_EXDT	EXEMPTION TO	O
FIWTIN_TAN_EXEM	WT_EXNR	EXEMPTION NUMBER	R
FIWTIN_TAN_EXEM	WT_EXRT	EXEMPTION RATE	O
FIWTIN_TAN_EXEM	WT-WT_EXRS	EXEMPTION REASON	O
FIWTIN_TAN_EXEM	THR	EXEMPTION THRESHOLD AMOUNT	O
FIWTIN_TAN_EXEM	WAERS	EXEMPTION CURRENCY	O
WYT3	LIFNR	VENDOR	R
WYT3	EKORG	PURCHASING ORGANIZATION	R
WYT3	LTSNR	SUPPLIER SUBRANGE	O
WYT3	WERKS	PLANT	O
LMF1	WEBRE	INDICATOR : GR-BASED INVOICE VERIFICATION	O
LFM1	EXPVZ	MODE OF TRANSPORT AT BORDER	O
LMF1	XERSR	AUTOMATIC EVALUATED RECEIPT SETTLEMENT	O
LMF1	WAERS	PURCHASE ORDER CURRENCY	O
LFM1	EKGRP	PURCHASING GROUP	O
LFM1	PLIFZDAT	PLANNED DELIVERY TIME	O
LFM1	INCO1	INCOTERMS (PART 1)	O
LFM1	INCO2_L	INCOTERMS LOCATION 1	O
LFM1	ZTERMDAT	TERMS OF PAYMENT KEY	O
LFBK	HBKID	SHORT KEY FOR HOUSE BANK	O
LFBK	BANKS	BANK COUNTRY / REGION KEY	R
LFBK	BANKL	BANK KEYS	C
LFBK	BKONT	BANK CONTROL KEY	O
LFBK	BKREF	REFERENCE SPECIFICATIONS FOR BANK DETAIL	O

Data Cleansing

ID	Criticality	Error Message/Report Description	Rule	Output	Source System
3026-001	C1	Deduplication	Deduplication of supplier records with parent and child approach. Vendors with same name, VAT ID, bank details, etc., should be unified to avoid redundant BP creation. Criteria: Same or similar name Same or similar address, phone number, city. VAT/TAX registration number (where applicable)		PF1/WP1
3026-002	C2	Vendor General Bank - Missing or Incorrect Bank details	1) Bank account numbers and IBANs must be in the correct format. For countries outside the EU, the appropriate format must be validated. 2) SWIFT/BIC codes must be present and valid to ensure proper international transactions. 3) Banks assigned to Vendors (BP) must be validated in Bank Master table (BNKA). If BANK details are not found then after confirmation from Business get missing BANK details configured in System	Vendor, Name, Country, Description, Region, Comment, Baseline	PF1/WP1
3026-003	C2	Vendor General - Missing or Incorrect Address details	1) The address info is mandatory, check if source data is updated. 2) For Business Partners (vendors), ensure the 'City' is populated in the Vendor General Data.		PF1/WP1
3026-004	C2	VAT Number / Tax Number	1) VAT numbers, tax codes, and tax jurisdictions must be valid and correctly formatted 2) International vendors must comply with tax rules of their respective countries 3) Generally all records should have at least one of the fields VAT numbers, tax codes, and tax jurisdictions, CNPJ updated 4) International vendors must comply with tax rules of their respective countries		PF1/WP1
3026-005	C2	Missing Emails	Check if correct 'Email' is not populated for Purchasing Organization		PF1/WP1
3026-006	C2	Not Approved Payment Terms	Check the Payment Terms assigned to the vendor and verify if it exists in the mapping table		PF1/WP1

Conversion Process

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

Deduplication

Business Partner – General deduplication will include cleansing activity to remove vendor duplicates. The golden record selected will be referenced for global data info (general data) in migration.

Vendor records without duplicates will automatically selected as golden record on its own.

The next step is to determine Purchasing Organization extensions from Vendors identified in global relevancy and will undergo a deduplication exercise to determine record source of purchasing data for Business Partner – 3^rd Party Suppliers.

This is where business needs to select which record to use as valid source of Purchasing Organization data.

Scenario 1: Non-Duplicate Vendor (Global) having multiple active Purchasing Organization extensions

Vendor has no duplicates at global level. However, vendor has multiple Purchasing Organization data within same name, country, etc.

Scenario 2: Duplicate Vendors (Global) having multiple active Purchasing Organizations

Duplication of vendor exist in Vendor Global duplicate group and extended to same purchasing organization.

Data Privacy and Sensitivity

Extraction

Extract data from a source into . There are 2 possibilities:

The data exists. connects to the source and loads the data into . There are 3 methods:
1. Perform full data extraction from relevant tables in the source system(s).
2. Perform extraction through the application layer.
3. Only if ; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in . This is to be conducted using DCT (Data Collection Template) in

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

Extraction Run Sheet

Req #	Requirement Description	Team Responsible
1	Refresh LFA1, LFM1, LFBK tables via Syniti Tool (Vendor data)	Data

Selection Screen

Selection Ref Screen	Parameter Name	Selection Type	Requirement	Value to be entered/set
N/A

Data Collection Template (DCT)

Target Ready Data Collection Template will be created for data with exception of some fields which require transformation as mentioned in the transformation rule.

DCT Rules

Field Name	Field Description	Rule

Extraction Dependencies

Item #	Step Description	Team Responsible
1	Ensure that the necessary cleansing activities in legacy sources (PF1,WP1) are complete	Data/Business
2	Ensure that create, change and deletion of master data is freeze in PF1, WP1 Production system	SyWay IT team

Transformation

The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow to make the data Target ready:

Perform value mapping and data transformation rules.
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
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 Pre-load Data Validation

Transformation Run Sheet

Item #	Step Description	Team Responsible
1	Run LFA1 Relevancy in Syniti	Data
2	Run LFM1 Relevancy in Syniti	Data
3	Run BP Relevancy in Syniti	Data
4	Run Business Partner Supplier execution in Syniti	Data

Transformation Rules

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	PF1/WP1	LFA1	LIFNR	VENDOR NUMBER	S/4 HANA	BUT000	PARTNER	SUPPLIER NUMBER	Derive via legacy to SyWay S4 Business Partner mapping
2	PF1/WP1	LFA1	KTOKK	ACCOUNT GROUP	S/4 HANA	BUT000	BU_GROUP	BP GROUPING
3	PF1/WP1	LFA1	SPERQ	BLOCK FUNCTION	S/4 HANA	LFA1	SPERQ	BLOCK FUNCTION
4	PF1/WP1	LFA1	WERKS	PLANT	S/4 HANA	LFA1	WERKS	PLANT
5	PF1/WP1	LFA1	WERKR	PLANT RELEVANT	S/4 HANA	LFA1	WERKR	PLANT RELEVANT
6	PF1/WP1	LFA1	SPERZ	PAYMENT BLOCK	S/4 HANA	LFA1	SPERZ	PAYMENT BLOCK
7	PF1/WP1	LFA1	NODEL	GENERAL DATA BLOCK	S/4 HANA	LFA1	NODEL	GENERAL DATA BLOCK
8	PF1/WP1		SPRAS	PROPOSED LANGUAGE	S/4 HANA		SPRAS	PROPOSED LANGUAGE	Default to "English"
9	PF1/WP1	LFM1	LIFNR	VENDOR NUMBER	S/4 HANA	LFM1	LIFNR	SUPPLIER NUMBER	Derive via legacy to SyWay S4 Business Partner mapping
10	PF1/WP1	LFM1	EKORG	PURCHASING ORGANISATION	S/4 HANA	LFM1	EKORG	PURCHASING ORGANISATION	Derive via legacy to SyWay S4 Purchasing Organisation mapping
11	PF1/WP1	LFM1	EKGRP	PURCHASING GROUP	S/4 HANA	LFM1	EKGRP	PURCHASING GROUP	Derive via legacy to SyWay S4 Purchasing Group mapping
12	PF1/WP1	LFM1	WAERS	ORDER CURRENCY	S/4 HANA	LFM1	WAERS	ORDER CURRENCY	*Derive via legacy to SyWay S4 Purchasing Currency code mapping
13	PF1/WP1	LFM1	VERKF	SALESPERSON	S/4 HANA	LFM1	VERKF	SALESPERSON
14	PF1/WP1	LFM1	TELF1	TELEPHONE	S/4 HANA	LFM1	TELF1	TELEPHONE
15	PF1/WP1	LFM1	MINBW	MINIMUM ORDER VALUE	S/4 HANA	LFM1	MINBW	MINIMUM ORDER VALUE
16	PF1/WP1	LFM1	ZTERM	PAYMENT TERMS	S/4 HANA	LFM1	ZTERM	PAYMENT TERMS
17	PF1/WP1	LFM1	INCOV	INCO VERSION	S/4 HANA	LFM1	INCOV	INCO VERSION
18	PF1/WP1	LFM1	INCO1	INCOTERMS	S/4 HANA	LFM1	INCO1	INCOTERMS	Derive via legacy to SyWay S4 Incoterms mapping
19	PF1/WP1	LFM1	INCO2_L	INCOTERMS LOCATION 1	S/4 HANA	LFM1	INCO2_L	INCOTERMS LOCATION 1	*Derive via legacy to SyWay S4 Incoterms Location mapping
20	PF1/WP1	LFM1	INCO3_L	INCOTERMS LOCATION 2	S/4 HANA	LFM1	INCO3_L	INCOTERMS LOCATION 2
21	PF1/WP1	LFM1	KALSK	SCHEMA GROUP SUPPLIER	S/4 HANA	LFM1	KALSK	SCHEMA GROUP SUPPLIER
22	PF1/WP1	LFM1	PLIFZ	PLANNED DELIVERY TIME	S/4 HANA	LFM1	PLIFZ	PLANNED DELIVERY TIME
23
24	PF1/WP1	LFM1	LFABC	ABC INDICATOR	S/4 HANA	LFM1	LFABC	ABC INDICATOR
25	PF1/WP1	LFM1	VSBED	SHIPPING CONDITIONS	S/4 HANA	LFM1	VSBED	SHIPPING CONDITIONS
26	PF1/WP1	LFM1	WEBRE	GR-BASED INVOICE VERIFICATION	S/4 HANA	LFM1	WEBRE	GR-BASED INVOICE VERIFICATION
27	PF1/WP1	LFM1	KZAUT	AUTOMATIC PURCHASE ORDER	S/4 HANA	LFM1	KZAUT	AUTOMATIC PURCHASE ORDER
28	PF1/WP1	LFM1	MEPRF	PRICING DATE CONTROL	S/4 HANA	LFM1	MEPRF	PRICING DATE CONTROL
29	PF1/WP1	LFM1	BSTAE	CONFIRMATION CONTROL KEY	S/4 HANA	LFM1	BSTAE	CONFIRMATION CONTROL KEY
30	PF1/WP1	LFM1	KZRET	RETURNS SUPPLIER	S/4 HANA	LFM1	KZRET	RETURNS SUPPLIER
31	PF1/WP1	LFM1	AUBEL	AUTOMATIC DEBIT	S/4 HANA	LFM1	AUBEL	AUTOMATIC DEBIT
32	PF1/WP1	LFM1	VALID_PRO	SETTLEMENT PROFILE	S/4 HANA	LFM1	VALID_PRO	SETTLEMENT PROFILE
33	PF1/WP1	LFM1	HSCABS	ABSOLUTE HANDLING SURCHARGE	S/4 HANA	LFM1	HSCABS	ABSOLUTE HANDLING SURCHARGE
34	PF1/WP1	LFM1	HSCPE	PERCENTAGE HANDLING SURCHARGE	S/4 HANA	LFM1	HSCPE	PERCENTAGE HANDLING SURCHARGE
35	PF1/WP1	LFM1	HSCMIN	MINIMUM HANDLING SURCHARGE	S/4 HANA	LFM1	HSCMIN	MINIMUM HANDLING SURCHARGE
36	PF1/WP1	LFM1	HSCMAX	MAXIMUM HANDLING SURCHARGE	S/4 HANA	LFM1	HSCMAX	MAXIMUM HANDLING SURCHARGE
37	PF1/WP1	LFM1	XERSY	AUTOM EVALUATED RECEIPT SETTLEMENT (ERS)	S/4 HANA	LFM1	XERSY	AUTOM EVALUATED RECEIPT SETTLEMENT (ERS)
38	PF1/WP1	LFM1	XERSR	AUTOM EVALUATED GR SETTLEMENT RETURN	S/4 HANA	LFM1	XERSR	AUTOM EVALUATED GR SETTLEMENT RETURN
39	PF1/WP1	LFM1	KZABS	ORDER ACKNOWLEDGMENT REQUIREMENT	S/4 HANA	LFM1	KZABS	ORDER ACKNOWLEDGMENT REQUIREMENT
40	PF1/WP1	WYT3	LIFNR	VENDOR	S/4 HANA	WYT3	LIFNR	SUPPLIER
41	PF1/WP1	WYT3	EKORG	PURCHASING ORG	S/4 HANA	WYT3	EKORG	PURCHASING ORG
42	PF1/WP1	WYT3	PARVW	PARTNER FUNCTION	S/4 HANA	WYT3	PARVW	PARTNER FUNCTION
43	PF1/WP1	WYT3	LIFN2	REF TO VENDOR	S/4 HANA	WYT3	LIFN2	REF TO VENDOR
44	PF1/WP1	WYT3	PERNR	PERSONAL NO	S/4 HANA	WYT3	PERNR	PERSONAL NO
45	PF1/WP1	WYT3	PARNR	CONTACT PERSON	S/4 HANA	WYT3	PARNR	CONTACT PERSON
46	PF1/WP1	WYT3	DEFPA	DEFAULT PARTNER	S/4 HANA	WYT3	DEFPA	DEFAULT PARTNER
47	PF1/WP1	STXL	TDNAME	VENDOR	S/4 HANA	Function - READ_TEXT (STHX header table)	LIFNR	SUPPLIER
48	PF1/WP1	STXL	EKORG	PURCHASING ORGRNIZATION	S/4 HANA	Function - READ_TEXT (STHX header table)	EKORG	PURCHASING ORGANIZATION
49	PF1/WP1	STXL	TDID	TEXT ID	S/4 HANA	Function - READ_TEXT (STHX header table)	TDID	TEXT ID
50	PF1/WP1	STXL	TDSPRAS	LANGUAGE	S/4 HANA	Function - READ_TEXT (STHX header table)	TEXT_TDSPRAS	LANGUAGE KEY
51	PF1/WP1	STXL	CLUSTD	DATA	S/4 HANA	Function - READ_TEXT (STHX header table)	TEXT_LINES	TEXT
52	PF1/WP1	KNVK	LIFNR	VENDOR	S/4 HANA	ADRC_NATION LENG (IAV)-LIFNR	LIFNR	SUPPLIER
53	PF1/WP1	KNVK	PARNR	CONTACT PERSON ID	S/4 HANA	ADRC_NATION LENG (IAV)-PARNR	PARNR	CONTACT PERSON ID
54	PF1/WP1	ADRC	NATION	ADDRESS VERSION	S/4 HANA	ADRC_NATION LENG (IAV)-PARNR	NATION	ADDRESS VERSION
55	PF1/WP1	ADRC	NAME1	NAME 1	S/4 HANA	ADRC_NATION	VNAME	FIRST NAME
56	PF1/WP1	ADRC	NAME2	NAME 2	S/4 HANA	ADRC_NATION LENG (IAV)-VNAME	LNAME	LAST NAME
57	PF1/WP1	ADRC	NAME3	NAME 3	S/4 HANA	ADRC_NATION LENG (IAV)-LNAME	NAME_MIDDLE	MIDDLE NAME
58	PF1/WP1	ADRC	NAME4	NAME 4	S/4 HANA	ADRC_NATION LENG (IAV)-MIDDLE	NAME_BIRTH	BIRTH NAME
59	PF1/WP1				S/4 HANA	ADRC_NATION LENG (IAV)-BIRTH	BUILDING_B	BUILDING CODE
60	PF1/WP1				S/4 HANA	ADRC_NATION LENG (IAV)-BUILDING_B	ROOM_B	ROOM NUMBER
61	PF1/WP1				S/4 HANA	ADRC_NATION LENG (IAV)-ROOM_B	FLOOR_B	FLOOR
62	PF1/WP1	ADRC	CITY	CITY1	S/4 HANA	ADRC_NATION LENG (IAV)-FLOOR_B	CITY	CITY
63	PF1/WP1	ADRC	STREET	STREET	S/4 HANA	ADRC_NATION LENG (IAV)-CITY	STREET	STREET
64	PF1/WP1	ADRC	HOUSE_NUM1	HOUSE NUMBER	S/4 HANA	ADRC_NATION LENG (IAV)-STREET	HOUSE_NO	HOUSE NUMBER
65	PF1/WP1	ADRC	BUILDING	BUILDING CODE	S/4 HANA	ADRC_NATION LENG (IAV)-HOUSE_NO	BUILDING	BUILDING CODE
66	PF1/WP1	ADRC	ROOMNUMBER	ROOM NUMBER	S/4 HANA	ADRC_NATION LENG (IAV)--BUILDING	ROOM	ROOM NUMBER
67	PF1/WP1	ADRC	FLOOR	FLOOR	S/4 HANA	ADRC_NATION LENG (IAV)-ROOM	FLOOR	FLOOR
68	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	ACCNO	SUPPLIER
69	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	BUKRS	COMPANY CODE
70	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	SECCODE	SECTION CODE / SECTION CODE GROUP
71	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	WT_EXDF	EXEMPTION FROM
72	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	WT_EXDT	EXEMPTION TO
73	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	WT_EXNR	EXEMPTION NUMBER
74	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	WT_EXRT	EXEMPTION RATE
75	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	WT-WT_EXRS	EXEMPTION REASON
76	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	THR	EXEMPTION THRESHOLD AMOUNT
77	PF1/WP1				S/4 HANA	FIWTIN_TAN_EXEM	WAERS	EXEMPTION CURRENCY
78	PF1/WP1	WYT3	LIFNR	VENDOR	S/4 HANA	WYT3	LIFNR	VENDOR
79	PF1/WP1	WYT3	EKORG	PURCHASING ORGANIZATION	S/4 HANA	WYT3	EKORG	PURCHASING ORGANIZATION
80	PF1/WP1	WYT3	LTSNR	SUPPLIER SUBRANGE	S/4 HANA	WYT3	LTSNR	SUPPLIER SUBRANGE
81	PF1/WP1	WYT3	WERKS	PLANT	S/4 HANA	WYT3	WERKS	PLANT
82	PF1/WP1	LMF1	WEBRE	INDICATOR : GR-BASED INVOICE VERIFICATION	S/4 HANA	LMF1	WEBRE	INDICATOR : GR-BASED INVOICE VERIFICATION
83	PF1/WP1	LFM1	EXPVZ	MODE OF TRANSPORT AT BORDER	S/4 HANA	LFM1	EXPVZ	MODE OF TRANSPORT AT BORDER
84	PF1/WP1	LMF1	XERSR	AUTOMATIC EVALUATED RECEIPT SETTLEMENT	S/4 HANA	LMF1	XERSR	AUTOMATIC EVALUATED RECEIPT SETTLEMENT
85	PF1/WP1	LMF1	WAERS	PURCHASE ORDER CURRENCY	S/4 HANA	LMF1	WAERS	PURCHASE ORDER CURRENCY
86	PF1/WP1	LFM1	EKGRP	PURCHASING GROUP	S/4 HANA	LFM1	EKGRP	PURCHASING GROUP
87	PF1/WP1	LFM1	PLIFZDAT	PLANNED DELIVERY TIME	S/4 HANA	LFM1	PLIFZDAT	PLANNED DELIVERY TIME
88	PF1/WP1	LFM1	INCO1	INCOTERMS (PART 1)	S/4 HANA	LFM1	INCO1	INCOTERMS (PART 1)
89	PF1/WP1	LFM1	INCO2_L	INCOTERMS LOCATION 1	S/4 HANA	LFM1	INCO2_L	INCOTERMS LOCATION 1
90	PF1/WP1	LFM1	ZTERMDAT	TERMS OF PAYMENT KEY	S/4 HANA	LFM1	ZTERMDAT	TERMS OF PAYMENT KEY
91	PF1/WP1	LFBK	HBKID	SHORT KEY FOR HOUSE BANK	S/4 HANA	LFBK	HBKID	SHORT KEY FOR HOUSE BANK
92	PF1/WP1	LFBK	BANKS	BANK COUNTRY / REGION KEY	S/4 HANA	LFBK	BANKS	BANK COUNTRY / REGION KEY
93	PF1/WP1	LFBK	BANKL	BANK KEYS	S/4 HANA	LFBK	BANKL	BANK KEYS
94	PF1/WP1	LFBK	BKONT	BANK CONTROL KEY	S/4 HANA	LFBK	BKONT	BANK CONTROL KEY
95	PF1/WP1	LFBK	BKREF	REFERENCE SPECIFICATIONS FOR BANK DETAIL	S/4 HANA	LFBK	BKREF	REFERENCE SPECIFICATIONS FOR BANK DETAIL

Transformation Mapping

Mapping Table Name	Mapping Table Description
Legacy Vendor-BP Master Mapping	Legacy to SyWay S4 Business Partner mapping
Purchasing Organization Mapping	Legacy to SyWay S4 Purchasing Organization Mapping
Business Partner deDupe mapping (Global Data)	Dedupe Golden-Child (Global) mapping
Payment Terms Mapping	Legacy to SyWay S4 Payment Terms Mapping
Incoterms Mapping	Legacy to SyWay S4 Incoterms Mapping
Purchasing Group Mapping	Legacy to SyWay S4 Purchasing Group Mapping
Partner Function Mapping	*Legacy to SyWay S4 Partner Function Mapping
Purchasing Currency Code Mapping	*Legacy to SyWay S4 Purchasing Currency code mapping
Vendor deDupe mapping (Purchasing Organization Data)	Dedupe Golden-Child (Purchasing Organization) Mapping
*TBD

Transformation Dependencies

List the steps that need to occur before transformation can commence

Item #	Step Description	Team Responsible
1	Extract PF1,WP1 source tables – LFA1, LFM1, LFBK	Data
2	Ensure all vendor master data collection templates, deduplication and cleansing completeness and no errors	Data
3	Ensure that Business Partner – General is loaded	Data
4	Ensure that all required Configurations are in S/4 HANA	Data

Pre-Load Validation

Project Team

Completeness

Task	Action
Verify Count for External Vendor Purchasing Organization extensions/BP Supplier Role	Verify that the record count in the pre-load file is the same as the record count based on the relevancy (including deduplication) results
Verify Count (Others)	Pre-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved.

Accuracy

Task	Action
Data Accuracy	Data team to verify that all the data in the load table/file is accurate as per signed-off transformation rules and DCT contents
Error Reports	Verify that all necessary error reports have been validated and that errors have been addressed.

Business

Completeness

Task	Action
Verify Count for External Vendor Purchasing Organization extensions/BP Supplier Role	Verify that the record count in the pre-load file is the same as the record count based on the relevancy (including deduplication) results
Verify Count (Others)	Pre-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved.
Verify Relevancy Rules	Verify that the relevancy rules were correctly applied

Accuracy

Task	Action
Verify Data Accuracy	Verify that all the data in the load table/file is accurate as per signed-off transformation rules and DCT contents
Review Error Reports	Verify that all necessary error reports have been validated, and that errors have been addressed.
Verify Transformation Rules	Verify that the transformation rules are correct and have been carried out correctly

Load

The load process includes:

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

Load Run Sheet

Item #	Step Description	Team Responsible
1	Load Sample Vendors Default Partner	Data
2	Validate sample Vendors Default Partner	Data
3	Load remaining Vendors Default Partner	Data
4	Validate data loaded for Vendors Default Partner	Data

Load Phase and Dependencies

Configuration

Item #	Configuration Item
1	Obtain the approved upload USER ID’s to be used (e.g. Firefighter ID)
2	SAP USER profile (SU3) Date and Decimal Notation Formats are in sync with the load format
3	Purchasing Organisation Configuration
4	Purchasing Group Configuration
5	Incoterms Configuration
6	Authorization Group Configuration
7	Plant Configuration
8	Confirmation Control Configuration
9	Payment Terms Configuration

Conversion Objects

Object #	Preceding Object Conversion Approach
3007	Business Partners - General
3018	Business Partners – FI Vendor

Error Handling

Error Type	Error Description	Action Taken
Configuration	<configuration> is not valid/missing	If it is a missing configuration item then engage Functional team to expedite and fix the error in the system.
Invalid Data	<parameter> is not valid.	The parameter entry needs to be reviewed (ex. invalid payment terms). If it is an invalid data, business needs to review and correct the source of the data either in PF1/WP1 or if it’s mapped in DCT.
Technical Setup	Interface / Connection issue within target system’s landscape	N/A – the data will be loaded directly to S/4HANA environment
Authorization Error	<USER ID> is not authorized to access Business Partner create	Contact Basis to obtain Fire Fighter ID (or SyWay S4 approved data loading ID) or fix the authorization setup

Post-Load Validation

Project Team

Completeness

Task	Action
Verify Count for External Vendor Purchasing Organization extensions/BP Supplier Role	Verify that the record count in the post-load report is the same as the record count based on the relevancy (including deduplication) results
Verify Count (Others)	Post-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved.

Accuracy

Task	Action
Data Accuracy	Data team to verify that all the data in the target tables is accurate as per signed-off transformation rules and DCT contents
Post Load Error Reports	Verify that all necessary post-load error reports have been validated, and that errors have been addressed.

Business

Completeness

Task	Action
Verify Count for External Vendor Purchasing Organization extensions/BP Supplier Role	Verify that the record count in the post-load file is the same as the record count based on the relevancy (including deduplication) results
Verify Count (Others)	Post-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved.
Validate Loaded Data	Validate, as per the loads files signed-off, that all records are in the target system

Accuracy

Task	Action
Verify Data Accuracy	Verify that all the data in the target tables is accurate as per signed-off transformation rules and DCT contents
Review Post Load Error Reports	Verify that all necessary post load error reports have been validated, and that errors have been addressed.
Validate Loaded Data	Validate, as per the loads files signed-off, that all records are in the target system

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.

Change log

Version	Published	Changed By
CURRENT (v. 5)	Apr 21, 2026 13:43	BATTINI-ext, Srinivasarao
v. 61	Apr 09, 2026 06:48	BATTINI-ext, Srinivasarao
v. 60	Apr 09, 2026 06:41	BATTINI-ext, Srinivasarao
v. 59	Apr 09, 2026 06:28	BATTINI-ext, Srinivasarao
v. 58	Apr 09, 2026 06:19	BATTINI-ext, Srinivasarao
v. 57	Apr 09, 2026 06:02	BATTINI-ext, Srinivasarao
v. 56	Apr 08, 2026 12:47	BATTINI-ext, Srinivasarao
v. 55	Apr 02, 2026 11:16	BATTINI-ext, Srinivasarao
v. 54	Apr 02, 2026 09:42	BATTINI-ext, Srinivasarao
v. 53	Mar 31, 2026 14:36	BATTINI-ext, Srinivasarao

Go to Page History

Workflow history

Title	Last Updated By	Updated	Status
There are no pages at the moment.

From Apr 08, 2026 to Apr 21, 2026	Actor	Type	Activity	Version
Revision in Progress	BATTINI-ext, Srinivasarao	Edit	updated the page at 12:47 pm
Apr 06, 2026
	CHITNEEDI-ext, Nagesh	Comment	commented 5:04 pm WEORA Field not present in ECC
	CHITNEEDI-ext, Nagesh	Comment	commented 10:35 am KTOKK=ZICP
Apr 03, 2026
	CHITNEEDI-ext, Nagesh	Comment	commented 7:17 pm account group field name and How to identify whether the STO is created automatically from STR or not?
		Comment	commented 7:15 pm Required and Blank?
		Comment	commented 7:14 pm J_1NBOESL field is not present in Legacy Table
		Comment	commented 7:12 pm WERKS field is missing in DCT.
		Comment	commented 7:06 pm INCO2_ID field is not in S/4 Hana Target Table Structure as per SE11.
		Comment	commented 7:05 pm INCO2_ID field is not in S/4 Hana Target Table Structure as per SE11.
		Comment	commented 7:03 pm ZDGID field is not in S/4 Hana Target Table Structure as per SE11.
From Mar 30, 2026 to Apr 02, 2026
	BATTINI-ext, Srinivasarao	Edit	updated the page at 11:55 pm
	BATTINI-ext, Srinivasarao	State	changed state to Revision in Progress at 9:55 pm	v49

Workflow history

Space shortcuts

Page tree

CNV-3026 Business Partners – 3rd Party Suppliers (FLVN001)

Purpose

Conversion Scope

Additional Information

Multi-language Requirement

Document Management

Legal Requirement

Special Requirements

Target Design

Data Cleansing

Conversion Process

Data Privacy and Sensitivity

Extraction

Extraction Run Sheet

Selection Screen

Data Collection Template (DCT)

Extraction Dependencies

Transformation

Transformation Run Sheet

Transformation Mapping

Transformation Dependencies

Pre-Load Validation

Project Team

Completeness

Accuracy

Business

Completeness

Accuracy

Load

Load Run Sheet

Conversion Objects

Error Handling

Post-Load Validation

Project Team

Completeness

Accuracy

Business

Completeness

Accuracy

Key Assumptions

See also

Change log

Workflow history