Versions Compared

Old Version 10

changes.mady.by.user NG-ext, Bernard

Saved on

compared with

New Version Current

changes.mady.by.user NG-ext, Bernard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Status

pagestatus
Percentage Progress | Vectors (Formerly: SP Percentage progress bar)
backgroundColor0052CC
percentage100

OwnerBernard Ng
Stakeholders

NAIDU-ext, Prasad GARCIA-ext, Angel Luis 

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

Conversion Scope

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

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 filtered as follows :

    1. BSIK : 
      1. All open items with no special GL indicator
    2. at migration cutoff date (
      1. 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
    3. posted
      1. 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
    4. <
      1. BUDAT<= migration cutoff date)

The data from legacy system excludes:

  1. Parked items
  2. Noted items
  3. Attachment / notes
List of source systems
      1. Company code in scope (refer to link )
      2. Vendor in scope (refer to link)
      3. Profit center in scope (refer to link)
    2. BSET :  Refer to migration object CNV-9019 GL Line Items (BS - Input / Output (VAT))
    3. 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


List of source systems and approximate number of records 
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2AP special GL open item500700500
800
WP2AP special GL open item10008001000
800
PI2AP special GL open item500500

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

Legacy OAPLoad OAPDrExpense1PC1--- (transform) --->DrOAP clearing GLPC1aDrExpense2PC2--- (transform) --->DrOAP clearing GLPC2aDrBalance sheet1--- (transform) --->DrOAP clearing GL<default PC>CrVendor--- (transform) --->CrVendor

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

BSIK

BUKRS

BUKRS

Company Code

CHAR

4

Mandatory with mapping

BSIK

XBLNR

XBLNR1

Reference Document Number

CHAR

16

Mandatory

BSIK

BUZEI

BUZEI

Line item number

NUMC

3

Mandatory

BSIK

LIFNR

LIFNR

Vendor

CHAR

16

Mandatory with mapping

BSIK

SAKNR

SAKNR

Alternative Reconciliation Account

NUMC

10

Conditional Based on Source Data

BSIK

BLART

H_BLART

Document type

NUMC

2

Mandatory with mapping

BSIK

UMSKZ

UMSKZ

Special G/L Indicator

CHAR

1

Mandatory with mapping

BSIK

BLDAT

BLDAT

Document Date

DATE

10

Mandatory

BSIK

BUDAT

BUDAT

Posting Date

DATE

10

Mandatory (migration cutoff date)

BKPF

BKTXT

BKTXT

Header Text

CHAR

50

Conditional Based on Source Data

BSIK

SGTXT

SGTXT

Item Text

CHAR

50

Conditional Based on Source Data

BSIK

GSBER

GSBER

Business Area

CHAR

4

Conditional Based on Source Data with mapping

BSIK

WAERS

WAERS

Document Currency

CHAR

4

Mandatory

BSIK

WSL

WSL

Amount in Document Currency

CURR

23(2)

Mandatory

BSIK

WMWST

WMWST

Tax amount in document currency

CURR

23(2)

Conditional Based on Source Data

BSIK

WAERS

WAERS

Local Currency

CHAR

4

Mandatory

BSIK

HSL

HSL

Amount in Local Currency

CURR

23(2)

Mandatory

BSIK

DMBTR

DMBTR

Tax amount in local currency

CURR

23(2)

Conditional Based on Source Data

BSIK

WAERS

WAERS

Group Currency

CHAR

4

Mandatory

BSIK

KSL

KSL

Amount in Group Currency

CURR

23(2)

Conditional Based on Source Data

BSIK

WMWST

WMWST

Tax amount in group currency

CURR

23(2)

Conditional Based on Source Data

BSIK

DMBE2

DMBE2

LC2 amount

CURR

23(2)

Conditional Based on Source Data

BSIK

WMWST

WMWST

Tax amount in LC2 currency

CURR

23(2)

Conditional Based on Source Data

BSIK

DMBE3

DMBE3

LC3 amount

CURR

23(2)

Conditional Based on Source Data

BSIK

WMWST

WMWST

Tax amount in LC3 currency

CURR

23(2)

Conditional Based on Source Data

BSIK

MWSKZ

MWSKZ

Tax code

CHAR

2

Tax code

BSIK

BUPLA

BUPLA

Business place

CHAR

4

Conditional Based on Source Data with mapping

BSIK

SECCO

SECCO

Section code

CHAR

4

Conditional Based on Source Data with mapping

BSIK

ZTERM

ZTERM

Payment Term

CHAR

4

Conditional Based on Source Data with mapping

BSIK

ZLSCH

DZLSCH

Payment Method

CHAR

1

Conditional Based on Source Data with mapping

BSIK

UZAWE

UZAWE

Payment method supplement

CHAR

2

Conditional Based on Source Data with mapping

BSIK

ZLSPR

DZLSPR

Payment Block Key

CHAR

1

Conditional Based on Source Data with mapping

BSIK

KIDNO

KIDNO

Payment reference

CHAR

30

Conditional Based on Source Data

BSIK

BZDAT

BZDAT

Value Date

DATE

8

Conditional Based on Source Data

BSIK

HBKID

HBKID

House bank

CHAR

5

Conditional Based on Source Data with mapping

BSIK

BVTYP

BVTYP

Partner bank type

CHAR

4

Conditional Based on Source Data with mapping

BSIK

REBZG

REBZG

Invoice reference

CHAR

10

Conditional Based on Source Data with mapping

BSIK

REBZJ

REBZJ

Invoice reference fiscal year

NUMC

4

Conditional Based on Source Data

BSIK

VBUND

VBUND

Trading Partner

CHAR

6

Conditional based on Intercompany account used in source and mapping

BSIK

LZBKZ

LZBKZ

SCB Indicator

CHAR

3

Conditional Based on Source Data with mapping

BKPF

XREF1_HD

XREF1_HD

Reference field 1 (header)

CHAR

20

Conditional Based on Source Data

BKPF

XREF2_HD

XREF2_HD

Reference field 2 (header)

CHAR

20

Conditional Based on Source Data

BSIK

XREF1

XREF1

Reference key 1

CHAR

12

Conditional Based on Source Data

BSIK

XREF2

XREF2

Reference key 2

CHAR

12

Conditional Based on Source Data

BSIK

XREF3

XREF3

Reference key 3

CHAR

12

Conditional Based on Source Data

BSIK

ZUONR

DZUONR

Assignment Number

CHAR

18

Conditional Based on Source Data

BSIK

EBELN

EBELN

Purchasing document

CHAR

10

Conditional Based on Source Data with mapping

BSIK

EBELP

EBELP

Purchasing document item

NUMC

5

Conditional Based on Source Data with mapping

BSIK

PRCTR

PRCTR

Profit center

CHAR

10

Conditional Based on Source Data with mapping

BSIK

BEWAR

BEWAR

Transaction type

CHAR

3

Conditional Based on Source Data with mapping

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)

BSIK

BUKRS

BUKRS

Company Code

CHAR

4

Mandatory with mapping

BSIK

XBLNR

XBLNR1

Reference Document Number

CHAR

16

Mandatory

BSIK

BUZEI

BUZEI

Line item number

NUMC

3

Mandatory

BSIK

LIFNR

LIFNR

Vendor

CHAR

16

Mandatory with mapping

BSEG

HKONT

HKONT

Offset GL account

NUMC

10

Mandatory with mapping

BSIK

WAERS

WAERS

Document Currency

CHAR

4

Mandatory

BSIK

WSL

WSL

Amount in Document Currency

CURR

23(2)

Mandatory

BSIK

WAERS

WAERS

Local Currency

CHAR

4

Mandatory

BSIK

HSL

HSL

Amount in Local Currency

CURR

23(2)

Mandatory

BSIK

WAERS

WAERS

Group Currency

CHAR

4

Mandatory

BSIK

KSL

KSL

Amount in Group Currency

CURR

23(2)

Conditional Based on Source Data

BSIK

SGTXT

SGTXT

Item Text

CHAR

50

Conditional Based on Source Data

BSIK

XREF1

XREF1

Reference key 1

CHAR

12

Conditional Based on Source Data

BSIK

XREF2

XREF2

Reference key 2

CHAR

12

Conditional Based on Source Data

BSIK

XREF3

XREF3

Reference key 3

CHAR

12

Conditional Based on Source Data

BSIK

ZUONR

DZUONR

Assignment Number

CHAR

18

Conditional Based on Source Data

BSEG

PRCTR

PRCTR

Profit Centre

CHAR

10

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

BSEG

PPRCTR

PPRCTR

Partner Profit Centre

CHAR

10

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

BSEG

BEWAR

BEWAR

Transaction type

CHAR

3

Conditional Based on Source Data with mapping

Data Cleansing

ID

Criticality

Error Message/Report Description

Rule

Output

Source System

10
10






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 

BSEG

UMSKZ

UMSKZ

Special G/L Indicator

CHAR

1

Mandatory with mapping

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

5

Mandatory

BSEG/ACDOCA

WRBTR/WSL

WRBTR/WSL

Amount in Document Currency

CURR

23(2)

Mandatory

BSEG

H_HWAER

H_HWAER

Local currency

CURR

5

Mandatory

BSEG/ACDOCA

DMBTR/HSL

DMBTR/HSL

Amount in Local Currency

CURR

23(2)

Mandatory

BSEG

H_HWAE2

H_HWAE2

LC2

CURR

5

Optional

BSEG/ACDOCA

DMBE2/OSL

DMBE2/OSL

Amount in LC2

CURR

23(2)

Optional

BSEG

H_HWAE3

H_HWAE3

LC3

CURR

5

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

Mandatory 

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

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 center

CHAR

10

Optional

BSEG

PPRCTR

PPRCTR

Partner Profit Centre

CHAR

10

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

BSEG

GKONT

HKONT

Offset GL account

NUMC

10

Mandatory (Migration GL account for OAP refer link)



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

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















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

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

Transformation Dependencies

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


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

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


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

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

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 item1

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: ;Posting Date is 365 days or longer than current system date;

Rule 4: 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

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:

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

Req #

Requirement description

Team responsible

1.      

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

Data team

2.      

Perform preliminary completeness check documented

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 APOI conversion

Data team

Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set

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

Drop down value (T074-UMSKZ)

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

Amount in Document Currency

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

BSIK-HSL

Amount in Local Currency

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

BSIK-KDL

Amount in Group Currency

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

BSIK-DMBE2

LC2 amount

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

BSIK-DMBE3

LC3 amount

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-HBKIDHouse bank

Drop down value (HBKID-HBKID 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-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 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

Item #

Step description

Team responsible

1.      

Ensure all the fields that require value mapping, as stipulated  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 Date 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 in DCT – post to GL account xxxxxx without any vendor.

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

WSL

Amount in Document Currency

Copy source value, split by profit centers if required. 

12

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, 

13

Legacy or DCT

BSIKKSLAmount in Group Currency

S/4HANA

BSIKKSLAmount in Group Currency

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

14

Legacy or DCT

BSIKDMBE2LC2 amount

S/4HANA

BSIKDMBE2LC2 amount

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

15

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. 

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

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

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

BSIKHBKIDHouse bank

S/4HANA

BSIKHBKIDHouse 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. Open PO cross reference 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. Open PO cross reference 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

Transformation Mapping

Mapping Table Name

Mapping Table Description

Company Code

Mapping of legacy company codes to target system value

GL Account

Mapping of legacy GL accounts to target system value

Profit Centre

Mapping of legacy Profit Center to target system value

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 Key

Mapping of legacy currency keys to target system value

Special G/L Indicator

Mapping of legacy special GL indicator to target system value

Payment Block Key

Mapping of legacy payment block key to target system value

Payment Method

Mapping of legacy payment method to target system value

Open Purchase order cross references

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 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 commenceItem #Step DescriptionTeam Responsible1Ensure 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, 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

TaskActionVerify record count in Pre-load reports by region

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

TaskActionConversion 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

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

Item #

Configuration item

1.      

Company code-related configuration (posting period variant).

2.      

Finance posting (document types, document number ranges, special gl indicator)

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 Approach1067GL Account Operational CoA (incl. secondary CE)3018Business Partners - FI Vendor (FLVN00)1073Profit center9045Open 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

Post-Load Validation

Project Team

Completeness

TaskActionReconciliation 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

TaskActionCheck 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

TaskActionRecord 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

TaskActionOpen 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

Change History
limit10

Workflow history

Workflow Report
parent@self
hideheadertrue
typeapprovals