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

Compare with Current View Page History

« Previous Version 43 Next »

Status

  Revision in Progress

OwnerBernard Ng
Stakeholders

NAIDU-ext, Prasad PILLAY-ext, Lawrence GARCIA-ext, Angel Luis 

Purpose

The purpose of this document is to define the conversion approach to migrate AP open items without special GL indicator (normal items) in S/4 HANA.

AP open items are related to vendor line items that have not been cleared and remains as open status during migration cut-off date. Vendors comprise of the following types :

  • 3rd party vendors
  • Intercompany vendors
  • Employees
  • Others
  • One time vendor should be excluded and not supported



Conversion Scope

The scope of this document covers the approach for converting active AP open items from Legacy Source Systems into S/4HANA following the AP open items Master Data Design Standard. 


The data from legacy system are as follows :

    1. All open items with no special GL indicator (normal items) at migration cutoff date (Posting date <= migration cutoff date in BSIK table)
    2. All normal items posted before migration cutoff date but cleared after migration cutoff date (clearing date > migration cutoff date and posting date <= migration cutoff date in BSAK table)

The data from legacy system excludes the following, which do not contribute to financial balances :

    1. Parked item
    2. Noted item
    3. Attachments / notes


List of source systems and approximate number of records 
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2AP open item7000S47000
WP2AP open item16000S416000
PI2AP open item5000S45000





Amounts in legacy involve document currency, local currency and group currency. All currencies will be loaded accordingly unless there is a change in company design where local / group currency changes. Rates are as per the historical postings unless specific requirement calls for a fixed rate eg. group currency rate for consolidation purposes. Offsetting GL accounts in legacy documents will not be considered in this migration scope, they will be migrated in other objects scope eg. GL open item or GL balances. Migration takeover GL accounts will be offsetting the AP open items with respective profit center (if available in legacy).

Deferred tax in legacy AP documents will be included during migration. Reference to object 9019 (GL Line Items (BS - Input /Output (VAT)) for logic.

Withholding tax in legacy AP documents will be included during migration if withholding tax was not posted in legacy to avoid double posting. Reference to object 9020 (GL Line Items (BS - Withholding Tax)) for logic.

Offsetting GL line item(s) will be derived from legacy document if AP item does not have profit center (BSIK-PRCTR = blank). This will enable profit center derivation and splitting in S4. The offsetting GL account in migration loads will remain as migration clearing GL account but posted with the derived profit center which can be one line item or multiple line items depending on legacy open item document. If no profit center in legacy, a default profit center will be used based on mapping table by company code / GL account.

Legacy OAP

Load OAP
DrExpense1PC1--- (transform) --->DrOAP clearing GLPC1a
DrExpense2PC2--- (transform) --->DrOAP clearing GLPC2a
DrBalance sheet1<blank>--- (transform) --->DrOAP clearing GL<default PC>
CrVendor<blank>--- (transform) --->CrVendor<blank>



Additional Information

Multi-language Requirement

Document Management

Legal Requirement

Special Requirements




Target Design

The technical design of the target for this conversion approach. 


Table

Field

Data Element

Field Description

Data Type

Length (Decimals)

Requirement

BSEG

BUKRS

BUKRS

Company Code

CHAR

4

Mandatory

BSEG

XBLNR

XBLNR1

Reference Document Number

CHAR

16

Mandatory

BSEG

BUZEI

BUZEI

Line item number

NUMC

3

Mandatory

BSEG

LIFNR

LIFNR

Vendor

CHAR

16

Mandatory

BSEG

SAKNR

SAKNR

Alternative Reconciliation Account

NUMC

10

Optional

BSEG

BLART

H_BLART

Document type

NUMC

2

Mandatory with mapping

BSEG

UMSKZ

UMSKZ

Special G/L Indicator

CHAR

1

N/A in this object. Refer to 9007 (AP Special GL Open Items)

BKPF

BLDAT

BLDAT

Document Date

DATE

10

Mandatory

BKPF

BUDAT

BUDAT

Posting Date

DATE

10

Mandatory (migration cutoff date)

BKPF

BKTXT

BKTXT

Header Text

CHAR

50

Optional

BSEG

SGTXT

SGTXT

Item Text

CHAR

50

Optional

BSEG

GSBER

GSBER

Business Area

CHAR

4

Optional

BSEG

WAERS

WAERS

Document Currency

CHAR

4

Mandatory

BSEG/ACDOCA

WRBTR/WSL

WRBTR/WSL

Amount in Document Currency

CURR

23(2)

Mandatory

BSEG/ACDOCA

DMBTR/HSL

DMBTR/HSL

Amount in Local Currency

CURR

23(2)

Mandatory

BSEG/ACDOCA

DMBE2/OSL

DMBE2/OSL

Amount in LC2

CURR

23(2)

Optional

BSEG/ACDOCA

DMBE3/KSL

DMBE3/KSL

Amount in LC3

CURR

23(2)

Optional

BSEG

BUPLA

BUPLA

Business place

CHAR

4

Optional

BSEG

SECCO

SECCO

Section code

CHAR

4

Optional

BSEG

ZTERM

ZTERM

Payment Term

CHAR

4

Optional

BSEG

ZLSCH

DZLSCH

Payment Method

CHAR

1

Optional

BSEG

UZAWE

UZAWE

Payment method supplement

CHAR

2

Optional

BSEG

ZLSPR

DZLSPR

Payment Block Key

CHAR

1

Optional

BSEG

KIDNO

KIDNO

Payment reference

CHAR

30

Optional

BSEG

BZDAT

BZDAT

Value Date

DATE

8

Optional

BSEG

HBKID / HKTID

HBKID / HKTID

House bank

CHAR

5

Optional

BSEG

BVTYP

BVTYP

Partner bank type

CHAR

4

Optional

BSEG

REBZG

REBZG

Invoice reference

CHAR

10

Optional

BSEG

REBZJ

REBZJ

Invoice reference fiscal year

NUMC

4

Optional

BSEG

VBUND

VBUND

Trading Partner

CHAR

6

Optional

BSEG

LZBKZ

LZBKZ

SCB Indicator

CHAR

3

Optional

BSEG

XREF1_HD

XREF1_HD

Reference field 1 (header)

CHAR

20

Optional

BSEG

XREF2_HD

XREF2_HD

Reference field 2 (header)

CHAR

20

Optional

BSEG

XREF1

XREF1

Reference key 1

CHAR

12

Optional

BSEG

XREF2

XREF2

Reference key 2

CHAR

12

Optional

BSEG

XREF3

XREF3

Reference key 3

CHAR

12

Optional

BSEG

ZUONR

DZUONR

Assignment Number

CHAR

18

Optional

BSEG

EBELN

EBELN

Purchasing document

CHAR

10

Optional

BSEG

EBELP

EBELP

Purchasing document item

NUMC

5

Optional

BSEG

PRCTR

PRCTR

Profit center

CHAR

10

Optional

BSEG

PPRCTR

PPRCTR

Partner Profit Centre

CHAR

10

Optional

BSEG

BEWAR

BEWAR

Transaction type

CHAR

3

Optional

BSET

*

*

*

*

*

Refer to data object # 9019 (GL Line Items (BS - Input /Output (VAT))

WITH_ITEM

*

*

*

*

*

Refer to data object # 9020 (GL Line Items (BS - Withholding Tax))


Offset GL acccount line (single or multiple based on legacy document) : if vendor item has profit center, one offsetting line item is derived. Else check legacy document for offsetting line items (exclude tax line items and withholding tax items based on gl account mapping).

BSEG

BUKRS

BUKRS

Company Code

CHAR

4

Mandatory

BSEG

XBLNR

XBLNR1

Reference Document Number

CHAR

16

Mandatory

BSEG

BUZEI

BUZEI

Line item number

NUMC

3

Mandatory

BSEG

HKONT

HKONT

Offset GL account

NUMC

10

Mandatory (Migration GL account for OAP)

BSEG

WAERS

WAERS

Document Currency

CHAR

4

Mandatory

BSEG

WRBTR

WRBTR

Amount in Document Currency

CURR

23(2)

Mandatory

BSEG

DMBTR

DMBTR

Amount in Local Currency

CURR

23(2)

Mandatory

BSEG

DMBE2

DMBE2

Amount in LC2

CURR

23(2)

Optional

BSEG

DMBE3

DMBE3

Amount in LC3

CURR

23(2)

Optional

BSEG

SGTXT

SGTXT

Item Text

CHAR

50

Optional

BSEG

XREF1

XREF1

Reference key 1

CHAR

12

Optional

BSEG

XREF2

XREF2

Reference key 2

CHAR

12

Optional

BSEG

XREF3

XREF3

Reference key 3

CHAR

12

Optional

BSEG

ZUONR

DZUONR

Assignment Number

CHAR

18

Optional

BSEG

PRCTR

PRCTR

Profit Centre

CHAR

10

Mandatory. Based on BUKRS / BELNR / GJAHR of BSIK, extract line items in BSEG with PRCTR <> blank.  

BSEG

PPRCTR

PPRCTR

Partner Profit Centre

CHAR

10

Optional. Based on BUKRS / BELNR / GJAHR of BSIK, extract line items in BSEG with PPRCTR <> blank

BSEG

BEWAR

BEWAR

Transaction type

CHAR

3

Optional




Data Cleansing


ID

Criticality


Error Message/Report Description

Rule

Output

Source System

1

Can load, but business process affected

Open Item is overdue and aged > 1 year

Rule 1: Company must be in scope;

Rule 2: Line item is not having a clearing date;

Rule 3: Current system date > 1 year posting date;


Report


PF2 / PI2 / WP2

2

Can load, but business process affected

Open Items for Employees Vendors

 

Rule 1: Company must be in scope;

Rule 2: Line item is not having a clearing date;

Rule 3:  Vendors is with Employee Vendor Account (account group Z012 in WP2 / account group ZZPE in PF2)


Report

PF2 / PI2 / WP2

3

Cannot load

Open Items posted for One-Time Vendor

Rule 1: Company must be in scope;

Rule 2: Line item is not having a clearing date;

Rule 3:  Vendors is with One-time Vendor account

 


Report

PF2 / PI2 / WP2

4

Cannot load

Parked Items to be checked

Rule 1: Company must be in scope;

Rule 2: Document is parked (document status = “V”)



Report

PF2 / PI2 / WP2

5

Cannot load

Noted Items to be checked

Rule 1: Company must be in scope;

Rule 2: Document is noted (document status = “S”)


Report

PF2 / PI2 / WP2

6

Can load, but business process affected

Monitor documents without payment terms and payment method

Rule 1: Company must be in scope;

Rule 2: Document is missing payment terms and / or payment method 

 


Report

PF2 / PI2 / WP2












Conversion Process 

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

Data Privacy and Sensitivity


Extraction

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

  1. The data exists. ETL Tool connects to the source and loads the data into ETL Tool. 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 ETL Tool; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
  2. The data does not exist (or cannot be converted from its current state).  The data is manually collected by the business directly in ETL Tool. This is to be conducted using DCT (Data Collection Template) in ETL Tool

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.      

Ensure source tables BKPF, BSEG, BSIK, BSAK are extracted in tool according to the agreed cut-off date in the project plan

Data team

2.      

Perform preliminary completeness check

Data team

3.      

Raise issues as defects if Req # 1 to 2 are not met

Data team

4.      

Repeat Req # 1 to 3 if required

Data team

5.      

Report extraction result to person in charge of AP OI conversion

Data team


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















Data Collection Template (DCT)

Data Collection Template will be created with legacy data which require transformation as mentioned in the transformation rule. It can also be used for data that are not automatically extracted from legacy and require direct load to target system.

Field Name

Field description

Rule

BSIK-BUKRS

Company Code

Drop down value from T001-BUKRS company code DCT (only with active for finance indicator)

BSIK-LIFNR

Vendor Account

Drop down value from LFB1-LIFNR Business Partner DCT as FI Vendor on required company code level

BSIK-XBLNR

Reference Document Number

Business to enter content as per data type and length permitted

BSIK-BLDAT

Document Date

Business to enter content as per data type and length permitted

BSIK-BUDAT

Posting Date

Default to Conversion date

BKPF-BKTXT

Header Text

Business to enter content as per data type and length permitted

BSIK-SGTXT

Item Text

Business to enter content as per data type and length permitted

BSIK-UMSKZ

Special G/L Indicator

N/A - Refer to 9007 Special GL Open Items specs

BSIK-GSBER

Business area

Drop down value. (TGSB-GSBER)

BKPF-WAERS

Document Currency Key

Drop down value. Exist as valid S4 Currency Key (TCURT.WAERS)

BSIK-WRBTR/ ACDOCA-WSL

Amount in Document Currency

Business to enter content. Values should be checked with decimal points for Local currency (TCURX-CURDEC)

BSIK-DMBTR/ ACDOCA-HSL

Amount in Local Currency

Business to enter content. Values should be checked with decimal points for Local currency (TCURX-CURDEC)

BSIK-DMBE2 /ACDOC-OSL

Amount in LC2

Business to enter content. Values should be checked with decimal points for Local currency (TCURX-CURDEC)

BSIK-DMBE3/ ACDOCA-KSL

Amount in LC3

Business to enter content. Values should be checked with decimal points for Local currency (TCURX-CURDEC)

BSIK-BZDAT

Value Date

Business to enter content as per data type and length permitted

BSIK-PRCTR

Profit Centre

Drop down value. Exist in Profit Centre DCT and assigned with the same company code

BSIK-ZLSPR

Payment Block Key

Drop down value (T008-ZAHLS)

BSIK-ZLSCH

Payment Method

Drop down value. Exist as valid S4 Payment Method (T042Z-ZLSCH where T042Z-LAND1 = T001-LAND1)

BSIK-ZTERM

Payment Term

Drop down value. Exist as valid S4 Payment Term (T052-ZTERM where T052-KOART = Blank or ‘K’)

BSIK-HBKID / HKTIDHouse bank

Drop down value (HBKID-HBKID / HKTID based on BUKRS)

BSIK-BVTYPPartner bank type

Drop down value (LFBK-BVTYP based on LIFNR)

BSIK-ZFBDTBaseline Date

Business to enter content as per data type and length permitted

BSIK-VBUNDTrading Partner

Drop down value (T001-BUKRS)

BSIK.ZFBDT

Baseline Date

Business to enter content as per data type and length permitted as per section 3. The Baseline Date will determine the calculation of Payment Due Date (Days in Payment Term + Baseline Date = Payment Due Date)

BSIK-RASSC

Company ID of Trading Partner

Drop down value. Exist as valid S4 Trading Partner (T880-RCOMP)

BSIK-PPRCT

Partner Profit Centre

Drop down value. Exist in Profit Centre DCT and assigned with the same company code

BSIK-ZUONR

Assignment Number

Business to enter content as per data type and length permitted

BSIK-LZBKZ

SCB Indicator

Drop down value (T015L-LZBKZ)

BKPF- XREF1_HD

Reference field 1 (header)

Business to enter content as per data type and length permitted

BKPF- XREF2_HD

Reference field 2 (header)

Business to enter content as per data type and length permitted

BSIK – KIDNO

Payment reference

Business to enter content as per data type and length permitted

BSIK –EBELNPurchasing document

Drop down value (EKPO-EBELN or PO DCT )

BSIK –EBELPPurchasing document item

Drop down value (EKPO-EBELP based on EKPO-EBELN or PO DCT)

BSIK –XREF1Reference key1

Business to enter content as per data type and length permitted

BSIK –XREF2Reference key1

Business to enter content as per data type and length permitted

BSIK –XREF3Reference key1

Business to enter content as per data type and length permitted

BSIK –UZAWEPayment method supplement

Drop down value (T042F-UZAWE)

BSIK –BUPLABusiness place

Drop down value. (J_1BBRANCV-BRANCH based on BSIK-BUKRS)

BSIK –SECCOSection code

Drop down value (SECCODE-SECCODE based on BSIK-BUKRS)

BSIK-BEWARTransaction type

Drop down value (T856-BEWAR)


Suggestion to add:

Decimal validation - Check table TCURX for the document currency key and if Decimals (TCURX-CURRDEC) is ‘0’, validate that no decimal value is populated.


Extraction Dependencies


Item #

Step description

Team responsible

1.      

Any period / year end close activities have been fully completed

Business

2.      

Reconciliation for intercompany payables have been completed, and adjustment made in legacy SAP system

Business

3.      

Reconciliation of migrated Purchase Order is completed before the extraction of Accounts Payable Open Items

Business and Data



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 ETL TOOL 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 ETL TOOL
  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 Pre-load Data Validation

Transformation Run Sheet


Item #

Step description

Team responsible

1.      

Ensure all the fields that require value mapping, as stipulated in Mapping tables, have the latest signed-off mapping files imported into ETL Tool.

Data team

2.      

In tool, select the AP Open Items object.

Data team

3.      

Process the Object - AP Open Items - R3 AP Open Items.

Data team

4.      

Launch transformation.

Data team

5.      

Monitor the transformation progress and ensure performance and completion is within allowed timeframe

Data team

6.      

Generate Pre-Load reports .

Data team

7.      

Generate data load count.

Data team

8.      

Log errors as defects, if any and address resolutions. Close defects.

Data team

9.      

Re-transform and re-validate the Pre-load reports if necessary.

Data team

10.   

Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off.

Business

11.   

Analyse and resolve any pre-load defects logged by business.

Data team

12.   

Repeat steps 6 to 11 if necessary

Data team

13.   

Proceed to pre-load validations

Data team

Transformation Rules


Rule #

Source system

Source Table

Source Field

Source description

Target system

Target Table

Target Field

Target description

Transformation logic


1

N/A

N/A

N/A

N/A

S/4HANA

BKPF

BELNR

Document Number

Automatic determination of the Document number in target system.

Document number from source system is migrated into field SGTXT – see transformation rule for Line Item text field below.

2

Legacy or DCT

BKPF

BUKRS

Company Code

S/4HANA

BSIK

BUKRS  

Company Code

Map from source to target using company code mapping table

3

Legacy or DCT

BSIK

LIFNR

Vendor Account

S/4HANA

BSIK

LIFNR

Vendor Account

Map from source to target using Business Partner mapping table.  For exceptions, to use DCT eg post to GL account xxxxxx without any vendor via GL open item DCT.

4

Legacy or DCT

BSIK

XBLNR

Reference Document Number

S/4HANA

BSIK

XBLNR

Reference Document Number

Copy source value.

5

Legacy or DCT

BSIK

BLDAT

Document Date

S/4HANA

BSIK

BLDAT

Document Date

Copy source value

6

Legacy or DCT

BSIK

BUDAT

Posting Date

S/4HANA

BSIK

BUDAT

Posting Date

Posting date = Conversion date (last day of month prior go-live)

7

Legacy or DCT

BKPF

BKTXT

Header Text

S/4HANA

BKPF

BKTXT

Header Text

Copy source value

8

Legacy or DCT

BSIK

SGTXT

Item Text (For offset posting to conversion take-on G/L account)

S/4HANA

BSIK

SGTXT

Item Text

FY+CoCode+DocNumber+source value (example – 2018ECAU3001102743) will be used as Prefix (SGTXT). If source SGTXT is longer than 32 chars, it’ll be cut to fit.

Example in S4 will be posted with SGTXT= “2018ECAU3001102743MILLER”. 

9

Legacy or DCT

BSIKGSBERBusiness Area

S/4HANA

BSIKGSBERBusiness Area

Map from source to target using Business Area mapping table

10

Legacy or DCT

BKPF

WAERS

Document Currency

S/4HANA

BSIK

WAERS

Document Currency

Mapping table - When conversion from ‘old’ Local currency to ‘new’ Local currency applies

11

Legacy or DCT

BSIK

WRBTR

Amount in Document Currency

S/4HANA

BSIK/ACDOCA

WRBTR/WSL

Amount in Document Currency

Copy source value, split by profit centers will via S4 splitting based on offsetting GL items. 

12

Legacy or DCT

BSIK

DMBTR

Amount in Local Currency

S/4HANA

BSIK/ACDOCA

DMBTR/HSL

Amount in Local Currency

Copy source value if source currency is equal to target currency, If different, to use DCT 

14

Legacy or DCT

BSIKDMBE2LC2 amount

S/4HANA

BSIK/ACDOCADMBE2/OSLLC2 amount

Copy source value if source currency is equal to target currency. If blank or 0 , this is to be auto calculated based on Local currency amount (DMBE2) converted to hard currency (T005-CURHA) with exchange rate of migration cutoff date (rate is hardcoded by company or derived from exchange rate table TCURR-UKURS with specific rate type KURST / from date GDATU / FCURR / TCURR). If different source vs target currency, to use DCT

15

Legacy or DCT

BSIK

DMBE3

LC3 amount

S/4HANA

BSIK / ACDOCA

DMBE3 /KSL

Amount in LC3

Copy source value as the group currency does not change. If blank or 0 , this is to be auto calculated based on Local currency amount (DMBE2) converted to group currency (T000-MWAER) with exchange rate of migration cutoff date (rate is hardcoded or derived from exchange rate table TCURR-UKURS with specific rate type KURST / from date GDATU / FCURR / TCURR)

16

Legacy or DCT

BSIS

VALUT

Value Date

S/4HANA

BSIK

BZDAT

Value Date

Copy source value

17

Legacy or DCT

BSIS

PRCTR

Profit Centre

S/4HANA

BSIK

PRCTR

Profit Centre

Profit centers should be populated on the offset item - conversion take-on G/L account

18

Legacy or DCT

BSIS

VBUND

Company ID of Trading Partner

S/4HANA

BSIK

RASSC

Company ID of Trading Partner

Map from source to target using Trading Partner mapping table

19

Legacy or DCT

BSIS

ZUONR

Assignment Number

S/4HANA

BSIK

ZUONR

Assignment Number

Copy source value

20

Legacy or DCT

BSIK

UMSKZ

Special G/L Indicator

S/4HANA

BSIK

UMSKZ

Special G/L Indicator

N/A

21

Legacy or DCT

BSIK

 ZLSPR

Payment Block Key

S/4HANA

BSIK

 ZLSPR

Payment Block Key

Map from source to target using Payment Block Key mapping table

22

Legacy or DCT

BSIK

ZLSCH

Payment method

S/4HANA

BSIK

ZLSCH

Payment method

Map from source to target using Payment method mapping table

23

Legacy or DCT

BSIK

 ZTERM

Payment Term

S/4HANA

BSIK

 ZTERM

Payment Term

Map from source to target using Payment term mapping table

24

Legacy or DCT

BSIKHBKID / HKTIDHouse bank

S/4HANA

BSIKHBKID / HKTIDHouse bank

Map from source to target using House bank mapping table

25

Legacy or DCT

BSIKBVTYPPartner bank type

S/4HANA

BSIKBVTYPPartner bank type

Map from source to target using Partner bank type mapping table

26

Legacy or DCT

BSIKREBZGInvoice reference

S/4HANA

BSIKREBZGInvoice reference

Leave blank

27

Legacy or DCT

BSIKREBZJInvoice reference fiscal year

S/4HANA

BSIKREBZJInvoice reference fiscal year

Leave blank

28

Legacy or DCT

BSIK

 ZFBDT

Baseline Date

S/4HANA

BSIK

 ZFBDT

Baseline Date

 Copy source value



29

Legacy or DCT

BSIKZUONRAssignment Number

S/4HANA

BSIKZUONRAssignment Number

 Legacy document number + legacy year

30

Legacy or DCT

BSIKLZBKZSCB Indicator

S/4HANA

BSIKLZBKZSCB Indicator

Map from source to target using Payment term mapping table

31

Legacy or DCT

BKPFXREF1_HDReference field 1 (header)

S/4HANA

BKPFXREF1_HDReference field 1 (header)

 Copy source value

32

Legacy or DCT

BKPFXREF2_HDReference field 2 (header)

S/4HANA

BKPFXREF2_HDReference field 2 (header)

 Copy source value

33

Legacy or DCT

BSIK

 KIDNO

Payment reference

S/4HANA

BSIK

 KIDNO

Payment reference

 Copy source value

34

Legacy or DCT

BSIK

 EBELN

Purchasing document

S/4HANA

BSIK

EBELN 

Purchasing document

Map it to PO. Purchase order mapping table is used for mapping in both cases.

35

Legacy or DCT

BSIK

 EBELP

Purchasing document item

S/4HANA

BSIK

 EBELN

Purchasing document item

Map it to PO item. Purchase order mapping table is used for mapping.

36

Legacy or DCT

BSIKXREF1Reference key1

S/4HANA

BSIKXREF1Reference key1

 Copy source value

37

Legacy or DCT

BSIKXREF2Reference key2

S/4HANA

BSIKXREF2Reference key2

 Copy source value

38

Legacy or DCT

BSIKXREF3Reference key3

S/4HANA

BSIKXREF3Reference key3

 Copy source value

39

Legacy or DCT

BSIKUZAWEPayment method supplement

S/4HANA

BSIKUZAWEPayment method supplement

Map from source to target using Payment method supplement mapping table

40

Legacy or DCT

BSIKBUPLABusiness place

S/4HANA

BSIKBUPLABusiness place

Map from source to target using Business place mapping table

41

Legacy or DCT

BSIKSECCOSection code

S/4HANA

BSIKSECCOSection code

Map from source to target using Section code mapping table

42

Legacy or DCT

BSIKBEWARTransaction type

S/4HANA

BSIKBEWARTransaction type

Map from source to target using Transaction type mapping table

43

Legacy or DCT

BSIK

PPRCTR

Partner Profit Centre

S/4HANA

BSIK

PPRCTR

Partner Profit Centre

Profit centers should be populated on the offset item - conversion take-on G/L account

Offsetting GL line item

 1Legacy or DCTBSEGBUKRSCompany CodeS/4HANABSEGBUKRSCompany CodeMap from source to target using company code mapping table
 2Legacy or DCTBSEGXBLNRReference Document NumberS/4HANABSEGXBLNRReference Document NumberCopy source value.
 3Legacy or DCTBSEGBUZEILine item numberS/4HANABSEGBUZEILine item numberCopy source value.
 4Legacy or DCTBSEGHKONTOffset GL accountS/4HANABSEGHKONTOffset GL accountMap from source to target using GL account mapping table
 5Legacy or DCTBSEGWAERSDocument CurrencyS/4HANABSEGWAERSDocument CurrencyMap from source to target using Currency mapping table
 6Legacy or DCTBSEGWRBTRAmount in Document CurrencyS/4HANABSEGWRBTRAmount in Document CurrencyCopy source value.
 8Legacy or DCTBSEGDMBTRAmount in Local CurrencyS/4HANABSEGDMBTRAmount in Local CurrencyCopy source value.
9Legacy or DCTBSEGDMBE2Amount in LC2S/4HANABSEGDMBTRAmount in LC2Copy source value.
 10Legacy or DCTBSEGDMBE3Amount in LC3S/4HANABSEGDMBE3Amount in LC3Copy source value. If blank or 0 , this is to be auto calculated based on Local currency amount (DMBE2) converted to group currency (T000-MWAER) with exchange rate of migration cutoff date (rate is hardcoded or derived from exchange rate table TCURR-UKURS with specific rate type KURST / from date GDATU / FCURR / TCURR)
 11Legacy or DCTBSEGSGTXTItem TextS/4HANABSEGSGTXTItem TextCopy source value.
 12Legacy or DCTBSEGXREF1Reference key 1S/4HANABSEGXREF1Reference key 1Copy source value.
 13Legacy or DCTBSEGXREF2Reference key 2S/4HANABSEGXREF2Reference key 2Copy source value.
 14Legacy or DCTBSEGXREF3Reference key 3S/4HANABSEGXREF3Reference key 3Copy source value.
 15Legacy or DCTBSEGZUONRAssignment NumberS/4HANABSEGZUONRAssignment NumberCopy source value.
 16Legacy or DCTBSEGPRCTRProfit CentreS/4HANABSEGPRCTRProfit CentreMap from source to target using Profit center mapping table. If not available, derive profit center from BUSINESS AREA mapping and if not available, derive from default profit center by company indicated in Profit center mapping table
 17Legacy or DCTBSEGPPRCTRPartner Profit CentreS/4HANABSEGPPRCTRPartner Profit CentreMap from source to target using Profit center mapping table. If not available, derive profit center from BUSINESS AREA mapping and if not available, derive from default profit center by company indicated in Profit center mapping table
 18Legacy or DCTBSEGBEWARTransaction typeS/4HANABSEGBEWARTransaction typeMap from source to target using Transaction type mapping table. If not available, derive from default transaction type by company /doc type indicated in transaction type mapping table

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


Transformation Mapping

Mapping Table Name

Mapping Table Description

Company Code

Mapping of legacy company codes to target system value

GL Account

Default offsetting GL account each open AP item

Profit Centre

Mapping of legacy Profit Center to target system value

Default profit center for blank legacy profit center line items

Business Partner

Mapping of legacy vendor accounts to target system value

Trading Partner

Mapping of legacy trading partners to target system value

Business AreaMapping of legacy Business Area to target system value

Currency

Mapping of legacy currency keys to target system value

Payment Block

Mapping of legacy payment block key to target system value

Payment Method

Mapping of legacy payment method to target system value

Payment TermMapping of legacy Payment Term to target system value

Purchase order Number

Mapping of legacy PO to target system value

Payment method supplementMapping of legacy Payment method supplement to target system value
Business placeMapping of legacy Business place to target system value
Section codeMapping of legacy Section code to target system value
SCB IndicatorMapping of legacy SCB Indicator to target system value
House bankMapping of legacy House bank & account ID to target system value
Partner bank typeMapping of legacy Partner bank type to target system value
Special G/L IndicatorMapping of legacy Special G/L Indicator to target system value
Document typeDefault doc type for this object OPEN AP
Transaction typeMapping of legacy Transaction type to target system value

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Ensure all the fields that require value mapping, as stipulated. Mapping tables, have the correct values mapped and imported into tool.Data team




Pre-Load Validation

Project Team

Completeness


Task

Action

Generation of
Pre-load reports

Mandatory field check.
Based on S/4HANA target design fields, check if records have all mandatory fields filled and mapped, otherwise they should be flagged as error.


Check Business Partners are extended to required company code

Check if all mapped business partners exists in S/4HANA LFB1-LIFNR (Vendor) and LFB1-BUKRS (Company Code), and LFB1-LOEVM
(Deletion Flag) must not be X


Check signage of amount.

Check whether source data (including DCT) has debit and credit entries in the same line. If sign is the same in all the three currency fields, then no action needed.

If the sign in the document currency and company code currency field are different, then the document needs to be corrected in the source system or DCT.

Ensure all transactions have values in Document Currency and Local Currency
(i.e. no 0.00 allowed) 

Reconciliation of total

Record Count

Check the sum of record count of the AP open items in the load file is the same as source. The record count for AP Open Items will be done on the group basis. The fields in the group are consist of: Company Code, Vendor


Check Amount in Document Currency and Local Currency

Check the sum of the amount in Document Currency and Local Currency in load file is the same as source. If any of the sum is different, flag the record as error.


Accuracy


Task

Action

Mandatory field mapping and transformation

Obtain a list of the fields to be populated with values from mapping files and ensure all these fields contain S/4HANA values. 
Review the data report to ensure mapping value is not missing in tool.
Capture errors in the Data Error report.




Business

Completeness

TaskAction
Verify record count in Pre-load reports by region

In legacy system, execute report AP Line Item Display (t/code: FBL1N) with selection parameters. 

Group the output of the report by Company Code and Vendor Account using subtotal function and compare the count in this report against the AP open items count in the pre-load file.

The record count for AP Open Items may also be done on the more granular level. The recommended granular level or the subtotal fields can consist of: Company Code, Vendor, Profit Centre, Document Currency Key, Company ID for Trading Partner.

If any of the count is different, raise defect and flag the relevant record as error.


Accuracy

TaskAction
Conversion accuracy

Verify AP open items are transformed accurately as per endorsed transformation/mapping rules.

Review error reports in tool for any mismatch or missing transformed values.

In legacy system, execute report AP Line Item Display (t/code: FBL1N) with selection parameters.

If any of the sum is different, raise defect and flag the relevant record as error.
Business partner balance on Company code and profit center levelCheck the total open item amount on Business partner at Company Code and Profit center level, against the total in legacy by Document, Local and Group currency. Apply currency rules where applicable


Load

Loading will be done through migration cockpit and therefore, data from the transformation export view to be exported into the load file format.

Export views to be prepared based on the field list from the load template attached. 

 Source data for FI - Accounts payable open item.xml


The load process includes:

  1. Execute the automated data load into target system using load tool
  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 description


Team responsible

1

Ensure the load tools are transported into the correct tool instance.

Data team

2

Ensure DCTs and all required mappings are submitted and complete

Data team

3

Ensure Pre-load sign-offs are obtained.

Data team

4

Execute tool for AP Open items

Data team

5

Generate the post load reports in tool.

Data team

6

Log errors as defects, if any and address resolutions. Close defects.

Data team

7

Resolve defects by reupload and re-generate post load reports if necessary.

Data team

8

Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.

Business

9

Repeat steps 5 to 7 if necessary.

Data team



Load Phase and Dependencies

Configuration

Item #

Configuration item

1.      

Company code-related configurations (posting period variant).

2.      

Finance posting (document types, document number ranges)

3.      

Currencies (currency keys, decimal places in currencies)

4.      

Accounts Payable specific (payment term, payment method, payment block keys)

 Conversion Objects

Object #Preceding Object Conversion Approach
1067GL Account Operational CoA (incl. secondary CE)
3018Business Partners - FI Vendor (FLVN00)
1073Profit center
9045Open purchase order

Error Handling


Error type

Error description

Action taken

Posting Period Error

Posting period is blocked for posting

Review project / cutover plan and ensure posting periods can be opened for postings

Business partner does not exist

Business Partner record for the line item doesn’t exist

Create the relevant Business Partner in the S/4HANA System

Profit Centre does not exist

Profit centre does not exist in company code

Ensure the profit centre mapping is correct and or create the profit centre if it is valid

GL account does not exist

GL account does not exist in company code

Ensure the GL account mapping is correct and or create the GL account if it is valid


Post-Load Validation

Project Team

Completeness

TaskAction
Reconciliation of Record Count

Total number of records loaded for AP Open Items will be generated in the Post-load reports in tool based on the target table and fields mentioned.

The reconciliation needs to be executed on the total number of ‘valid’ records and currency amount per company code in the source compared to total number of records and currency amount in S/4HANA

Record Count

Check the sum of record count of the open items in the load file is the same as S/4HANA. The record count for AP Open Items will be done on the group basis. The fields in the group are consist of: Company Code, Vendor Account

Check Amount in Document Currency and Local Currency

Check on line item level that the sum of the amount in Document Currency and Local Currency in the load file is the same as posted in S/4HANA. If any of the sum is different, flag the record as error.


Accuracy

TaskAction
Check values in key fields for accuracy

Post-load reports will have the same structure as the load file and some additional columns as required to facilitate the post load validation.

Leverage on tool to create a Post Load report that reports S/4HANA loaded records along with the legacy values side-by-side to allow for 100% check of all these fields in the shortest possible time.

Any mismatch will be reported under the Post Load - Error report.




Business

Completeness

TaskAction
Record Count Check

Review the record count report from the Data Team and ensure it is correct by cross-checking with the record count confirmed during Pre-load Business Validations


Business may also run transaction code FBL1N – Vendor Line Item Display or equivalent report in Fiori App to display loaded AP Open Items in S/4HANA and compare results against the pre-load reports generated from tool.

Accuracy

TaskAction
Open items totalsCheck business partner open item totals by Business partner, Company code, profit centre. Totals should be checked in Document, Local and Group currency.
Spot checkBusiness should choose some business partners and perform comprehensive check of open items, payment terms etc Such partners should have huge number of open items or be critical for payment runs in S4 or have certain complexity in conversion.


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 Comment
CURRENT (v. 43) Apr 08, 2026 15:01 NG-ext, Bernard
v. 81 Apr 06, 2026 11:42 NG-ext, Bernard
v. 80 Mar 18, 2026 08:24 NG-ext, Bernard
v. 79 Jan 23, 2026 11:36 NG-ext, Bernard
v. 78 Dec 18, 2025 07:46 NG-ext, Bernard Reverted from v. 76
v. 77 Dec 18, 2025 07:23 NG-ext, Bernard
v. 76 Dec 04, 2025 07:23 NG-ext, Bernard
v. 75 Dec 04, 2025 07:21 NG-ext, Bernard
v. 74 Dec 04, 2025 07:15 NG-ext, Bernard
v. 73 Dec 04, 2025 02:06 NG-ext, Bernard

Go to Page History

Workflow history

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

  • No labels