Purpose

The purpose of this document is to define the conversion approach to migrate AP open items with special GL indicator 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.

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

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

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Conversion Scope

Refer to CNV-9006 for similar design except for special GL indicator requirement.

Relevancy rule :

The extracted data from legacy system are filtered as follows :

1. 1. BSIK : 
      1. All open items with no special GL indicator UMSKZ <> blank (normal items) 
      2. Posting date BUDAT <= migration cutoff date
      3. Company code in scope (refer to link )
      4. Vendor in scope (refer to link)
      5. Profit center in scope (refer to link)
      6. BSTAT = blank only (exclude parked item and noted item)
   2. BSAK :
      1. All open items with no special GL indicator UMSKZ <> blank (normal items) 
      2. All normal items posted before migration cutoff date but cleared after migration cutoff date (clearing date AUGDT > migration cutoff date and posting date BUDAT<= migration cutoff date)
      3. Company code in scope (refer to link )
      4. Vendor in scope (refer to link)
      5. Profit center in scope (refer to link)
   3. BSET :  Refer to migration object CNV-9019 GL

1. 1. Line Items (BS - Input / Output (VAT))

Conversion Scope

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

The data from legacy system are as follows :

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

The data from legacy system excludes:

1. Parked items
2. Noted items

Source Approx No. of Records

No. of Records

Additional Information

Multi-language Requirement

Document Management

Legal Requirement

Special Requirements

1. 2. WITH_ITEM : Refer to migration object CNV-9020 GL Line Items (BS - Withholding Tax)

Note: There will not be migration of attachments / notes from open items in legacy systems

Additional Information

Multi-language Requirement

Document Management

Legal Requirement

Special Requirements

Target Design

The technical design of the target for this conversion approach. 

Target Design

The technical design of the target for this conversion approach. 

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

Rule 1: Company must be in scope;

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

Rule 3:  The Special GL Indicator field is not initial

Rule 4: ;Posting Date is 365 days or longer than current system date;

Rule 5: Due Date is prior report execution date.

Due Date calculation:

o    Credit posting to vendor account (BKPF.GLVOR = RFBU and BSIK.SHKZG = H)

Due Date = Baseline Date + Number Days as per specified in payment terms defined in line item

o    Debit posting to vendor account (BKPF.GLVOR = RFBU and BSIK.SHKZG = S)

Due Date = Baseline 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

Rule 4:  The Special GL Indicator field is not initial

Report

PF2 / PI2 / WP2

4.      

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

 Rule 4 :  The Special GL Indicator field is not initial

Report

PF2 / PI2 / WP2

5.      

Can load, but business process affected

Parked Items need to be cleanse

Rule 1: Company must be in scope;

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

Rule 3:  The Special GL Indicator field is not initial

Report

PF2 / PI2 / WP2

6.      

Can load, but business process affected

Unapproved Noted Items to cleanse

Rule 1: Company must be in scope;

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

Rule 3:  The Special GL Indicator field is not initial

Report

PF2 / PI2 / WP2

7.      

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 

 Rule 3:  The Special GL Indicator field is not initial

Report

PF2 / PI2 / WP2

Conversion Process 

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

Image Removed

Data Privacy and Sensitivity

Extraction

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

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

Selection Screen

Data Collection Template (DCT)

DCT Rules

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

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:

1. Perform value mapping and data transformation rules.
   1. Legacy values are mapped to the to-be values (this could include a default value)
   2. Values are transformed according to the rules defined in
2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool.  This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

Transformation Rules

Rule #

Source system

Source Table

Source Field

Source description

Target system

Target Table

Target Field

Target description

Transformation logic

N/A

N/A

N/A

N/A

S/4HANA

BKPF

BELNR

Document Number

Automatic determination of the Document number in target system.

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

Legacy or DCT

BKPF

BUKRS

Company Code

S/4HANA

BSIK

BUKRS  

Company Code

Map from source to target using company code mapping table

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 in DCT – post to GL account xxxxxx without any vendor.

Legacy or DCT

BSIK

XBLNR

Reference Document Number

S/4HANA

BSIK

XBLNR

Reference Document Number

Copy source value.

Legacy or DCT

BSIK

BLDAT

Document Date

S/4HANA

BSIK

BLDAT

Document Date

Copy source value

Legacy or DCT

BSIK

BUDAT

Posting Date

S/4HANA

BSIK

BUDAT

Posting Date

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

Legacy or DCT

BKPF

BKTXT

Header Text

S/4HANA

BKPF

BKTXT

Header Text

Copy source value

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

Legacy or DCT

S/4HANA

Map from source to target using Business Area mapping table

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

Legacy or DCT

BSIK

WRBTR

Amount in Document Currency

S/4HANA

BSIK

WSL

Amount in Document Currency

Copy source value, split by profit centers if required. 

Legacy or DCT

BSIK

DMBTR

Amount in Local Currency

S/4HANA

BSIK

HSL

Amount in Local Currency

Copy source value if source currency is equal to target currency, 

Legacy or DCT

S/4HANA

Copy source value if source currency is equal to target currency, 

Legacy or DCT

S/4HANA

Copy source value if source currency is equal to target currency, 

Legacy or DCT

BSIK

DMBE3

LC3 amount

S/4HANA

BSIK

KSL

Amount in Group Currency

Copy source value as the group currency does not change. 

Legacy or DCT

BSIS

VALUT

Value Date

S/4HANA

BSIK

BZDAT

Value Date

Copy source value

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

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

Legacy or DCT

BSIS

ZUONR

Assignment Number

S/4HANA

BSIK

ZUONR

Assignment Number

Copy source value

Legacy or DCT

BSIK

UMSKZ

Special G/L Indicator

S/4HANA

BSIK

UMSKZ

Special G/L Indicator

Map from source to target using Special G/L Indicator mapping table

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

Legacy or DCT

BSIK

ZLSCH

Payment method

S/4HANA

BSIK

ZLSCH

Payment method

Map from source to target using Payment method mapping table

Legacy or DCT

BSIK

 ZTERM

Payment Term

S/4HANA

BSIK

 ZTERM

Payment Term

Map from source to target using Payment term mapping table

Legacy or DCT

S/4HANA

Map from source to target using House bank mapping table

Legacy or DCT

S/4HANA

Map from source to target using Partner bank type mapping table

Legacy or DCT

S/4HANA

Leave blank

Legacy or DCT

S/4HANA

Leave blank

Legacy or DCT

BSIK

 ZFBDT

Baseline Date

S/4HANA

BSIK

 ZFBDT

Baseline Date

 Copy source value

Legacy or DCT

S/4HANA

 Legacy document number + legacy year

Legacy or DCT

S/4HANA

Map from source to target using Payment term mapping table

Legacy or DCT

S/4HANA

 Copy source value

Legacy or DCT

S/4HANA

 Copy source value

Legacy or DCT

BSIK

 KIDNO

Payment reference

S/4HANA

BSIK

 KIDNO

Payment reference

 Copy source value

Legacy or DCT

BSIK

 EBELN

Purchasing document

S/4HANA

BSIK

EBELN 

Purchasing document

Map it to PO. Open PO cross reference table is used for mapping in both cases.

Legacy or DCT

BSIK

 EBELP

Purchasing document item

S/4HANA

BSIK

 EBELN

Purchasing document item

Map it to PO item. Open PO cross reference table is used for mapping.

Legacy or DCT

S/4HANA

 Copy source value

Legacy or DCT

S/4HANA

 Copy source value

Legacy or DCT

S/4HANA

 Copy source value

Legacy or DCT

S/4HANA

Map from source to target using Payment method supplement mapping table

40

Legacy or DCT

S/4HANA

Map from source to target using Business place mapping table

41

Legacy or DCT

S/4HANA

Map from source to target using Section code mapping table

Transformation Mapping

Transformation Dependencies

Data Cleansing

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Conversion Process 

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

Image Added

Data Privacy and Sensitivity

Extraction

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Selection Screen

Data Collection Template (DCT)

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Extraction Dependencies

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Transformation

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Transformation Mapping

Transformation Dependencies

Pre-Load Validation

Project Team

Completeness

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Accuracy

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Business

Completeness

Accuracy

Load

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Load Run Sheet

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Load Phase and Dependencies

Configuration

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

 Conversion Objects

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Error Handling

Same as for CNV-9006. Exception: Special G/L indicator mandatory for every line item

Post-Load Validation

Project Team

Completeness

Accuracy

Business

Completeness

Accuracy

Pre-Load Validation

Project Team

Completeness

Task

Action

Generation of
Pre-load reports

Mandatory field check.
Based on S/4HANA target design fields, account field status groups and tax settings

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

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

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

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.

Load

The load process includes:

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

Load Run Sheet

Item

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

 Conversion Objects

Error Handling

Post-Load Validation

Project Team

Completeness

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

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

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

Accuracy

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

Workflow history