| Status | |
|---|---|
| Owner | BAJAJ-ext, Manoj |
| Stakeholders | PILLAY-ext, Lawrence |
Purpose
The purpose of this document is to define the conversion approach to create the Object 9111 - TRM - Bank guarantee in S4HANA.
A Bank Guarantee is an assurance on the part of a bank to make good an organisation's debt in the event of non-payment. Therefore, Bank Guarantee is essentially an agreement to stand as a cosigner on a transaction. In the event that the original party cannot follow through, the bank can be called upon to provide the payment. Till such time a Bank Guarantee is not revoked, it works as a contingent instrument.
In S4HANA, Bank Guarantee in Treasury module is created as an instrument under the relevant Product Type, Transaction Type (Bank Guarantee received or issued), with Treasury Business Partner and the transaction code used to create such instrument is FTR_CREATE.
For the purpose of migrating active Bank Guarantees, issued or received by Syensqo, a custom program using the BAPI "BAPI_FTR_BG_DEALCREATE" will be used as the standard LTMC (Data Migration Cockpit) only supports the direct transfer i.e. if the source system is ECC.
Conversion Scope
The scope of this document covers the approach for converting active Bank Guarantees, received or issued with information sourced manually from business as the same is not used in source Treasury system (Quantum).
The relevancy criteria is not applicable for this object as the relevant data will be provided by business in a DCT (Data Collection Template).
List of source systems and approximate number of records
Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
DCT | Active Bank Guarantees | 160 as of April'26 | S4HANA | 150 <TBC> |
Multi-language Requirement
None
Document Management
None
Legal Requirement
None
Special Requirements
As the conversion involves a source system which is non-SAP, the below area needs special handling:
- Data relevant for Bank Guarantee migration to sourced manually from Business in a Data Collection Template (DCT)
- Business team to ensure that only active and in use records for Bank Guarantees are provided in DCT
- The data as collected via DCT will be stored in the Syniti for Transformation
- Below Configuration Check Tables needs to be referenced in Syniti to validate the data in the DCT:
- Counterparty to Business Partner - BUT100 to check if the BP is assigned with Role "TR0151"
- Company Code - T001
- Product Type - TZPA
- Transaction Type - AT10
- Portfolio Code - TWPOB
- General Valuation Class - TRGC_COM_VALCL
- Bank Guarantee Type - TLCT_BG_TYPE
- Amount and date format from source system to align with S4HANA
- As the target structure in S4HANA involves dependency on various Configuration and BP Master Data objects (CNV 3040), all this data needs to be loaded before Transactions Data loads.
Target Design
For the purpose of migrating active Bank Guarantees as collected in the DCT, issued or received by Syensqo, a custom program using the BAPI "BAPI_FTR_BG_DEALCREATE" will be used as the standard LTMC (Data Migration Cockpit) only supports the direct transfer i.e. if the source system is ECC.
This section covers the list of fields that are part of the BAPI and DCT. This section will also explain field by field mapping of the BAPI structure and where the data will come from for each field for the BAPI.
The technical design of the target for this conversion approach.
There are 3 main tables involved as below
- VTBFHA
- VTBFHAZU
- VTBFHAPO
However, unlike other TRM Instruments, Bank Guarantee does not have a direct corelation of BAPI structure to Transparent Tables such as VTBFHA, VTBFHAZU, VTBFHAPO.
The table below serves as the Header (General Data) for table VTBFHA and includes Bank Guarantee data, which updates both VTBFHAZU and VTBHAPO together upon load via BAPI.
These fields are marked as Utility Fields against the table VTBHFA
| Table | Field | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|
VTBFHA | BUKRS | COMPANY_CODE | CHAR | 4 | This is a Required Field |
VTBFHA | RFHA | TRANSACTION NUMBER | CHAR | 13 | This is Internal Field |
VTBFHA | SGSART | PRODUCT_TYPE | CHAR | 3 | This is a Required Field |
VTBFHA | SFHAART | TRANSACTION_TYPE | CHAR | 3 | This is a Required Field |
VTBFHA | KONTRH | PARTNER | CHAR | 10 | This is a Required Field |
VTBFHA | DBLFZ | TERM START | DATS | 8 | This is a Required Field |
VTBFHA | DELFZ | TERM END | DATS | 8 | This is a Required Field |
VTBFHA | RPORTB | PORTFOLIO | CHAR | 10 | This is Optional Field |
VTBHFA | WGSCHFT | TRANSACTION CURRENCY | CUKY | 5 | This is a Required Field |
VTBFHA | ZUOND | ASSIGNMENT | CHAR | 18 | This is Optional Field |
VTBFHA | REFER | INTERNAL_REFERENCE | CHAR | 16 | This is Optional Field |
VTBFHA | MERKM | CHARACTERISTICS | CHAR | 25 | This is a Required Field |
VTBFHA | RCOMVALCL | VALUATION_CLASS | NUMC | 4 | This is a Required Field |
| VTBFHA | FACILITYNR | FACILITY | CHAR | 13 | This is Conditional Field, to be used if a Facility is linked to issue of a Bank Guarantee |
VTBFHA | FACILITYBUKRS | FACILITY_COMPANY_CODE | CHAR | 4 | This is Conditional Field, to be used if a Facility is linked to issue of a Bank Guarantee. The field is to be populated with Company Code for which a Facility exists. |
VTBHFA | BEHALF_OF_COMPANY | ON BEHALF OF COMPANY | CHAR | 4 | This is Optional Field |
VTBHFA | RCNTR (KOSTL) | COST CENTRE | CHAR | 10 | This is Optional Field |
VTBFHAZU | DVTRAB | CONTRACT DATE | DATS | 8 | This is a Required Field |
VTBFHAZU | RDEALER | TRADER | CHAR | 10 | This is Optional Field |
VTBFHAZU | GSPPART | CONTACT PERSON | CHAR | 19 | This is Conditional Field. To be filled up if Applicant or Beneficiary not filled |
VTBFHAZU | NOTICE_DATE | OTC Notice Date | DATS | 8 | This is Optional Field |
VTBFHAPO | BNWHR | Amount or Balance | CURR | 13 | This is a Required Field |
| Utility Field (VTBFHA) | FTR_BG_NUMBER | BANK_GUARANTEE_NUMBER | CHAR | 16 | This is a Required Field (Can be populated in VTBFHA-ZUOND) |
Utility Field | FTR_BG_TYPE | BANK_GUARANTEE_TYPE | CHAR | 4 | This is a Required Field (To be checked against table TLCT_BG_TYPE) |
Utility Field | FTR_APPLICANT | APPLICANT | CHAR | 10 | This is Conditional Field. Users to fill an applicant code if Bank Guarantee is received |
Utility Field | FTR_BENEFICIARY | BENEFICIARY | CHAR | 10 | This is Conditional Field. Users to fill a beneficiary code if Bank Guarantee is issued |
Utility Field | FTR_BUTXT | MANUAL_PARTY_COMPANY_NAME | CHAR | 25 | This is Conditional Field. Users to fill this field with the Company Name in case of no beneficiary/applicant involved |
Utility Field | FTR_XKONTRH | MANUAL_PARTY_COMPANY_ADDRESS | CHAR | 80 | This is Conditional Field. Users to fill this field with the Company Name in case of no beneficiary/applicant involved |
Utility Field | FTR_ADVISING_BANK | ADVISING BANK | CHAR | 10 | This is optional field |
Utility Field | EBELN | PURCHASE ORDER | CHAR | 10 | This is optional field |
Utility Field | VBELN_VA | SALES ORDER | CHAR | 10 | This is optional field |
The reference between the tables is a combination of Company Code and Transaction Number. This serves as the Primary Key to join the VTBF* tables.
In Addition to this, the field "Characteristics" will represent the Legacy Guarantee/Deal Number and will serve as the reference to trace back to source/legacy data.
The above was with respect to the target design and the tables that will be updated upon load via BAPI. The transformation is explained in the subsequent sections.
Data Cleansing
For the Object 9111 – TRM Bank Guarantees no specific data cleansing is applicable due to below reasons/assumptions:
- The relevant data source data will be provided/collected by/from Business in a DCT form.
Data- Pre Load Validation Report
However, for the purpose of the Object 9111 – TRM Bank Guarantees, below validations reports should be made available in Syniti so that the DCT Data for Bank Guarantees are validated before generating the pre-load file.
ID | Criticality | Error Message/Report Description | Rule | Output |
1 | High | Company Code is valid | Check if BUKRS is valid as per Company Codes created in the system in Table T001 | Invalid Company Code |
2 | High | PRODUCT_TYPE | Check if VVSART is valid as per Product Types created in the system in Table TZPA. | Invalid Product Type |
3 | High | TRANSACTION_TYPE | Check if SFHAART is valid as per Transaction Types created in the system in Table AT10 | Invalid Transaction Type |
4 | High | PARTNER | Check if KONTRH is valid as per Business Partners created in the system and has a role "TR0151" in table BUT100 | Invalid Partner |
5 | High | CONTRACT_DATE | Check if DVTRAB is valid in YYYYMMDD Format and is < or = Load Date | Contract Date greater than Load Date |
6 | High | VALUATION_CLASS | Check if TPM_COM_VAL_CLASS is valid as per Company Codes created in the system in Table TRGC_COM_VALCL | Invalid Valuation Class |
7 | High | TERM START | Check if DBLFZ is valid in YYYYMMDD Format and is < or = Contract Date | Term Start greater than or equal to Contract Date |
8 | High | TERM END | Check if DELFZ is valid in YYYYMMDD Format and is < Start Date | Term End greater than Term Start |
9 | High | FTR_BG_TYPE | Check if value provided for FTR_BG_TYPE (Bank Guarantee Type) exits in table TLCT_BG_TYPE | Invalid Bank Guarantee Type |
10 | Low | FACILITYNR | Check if Facility Number (FACILITYNR) is equal to "Blank" if Product Type (SGSART) ="BGR" AND Transaction Type ='ISS" | Facility Number not available Note: This is not a Hard error i.e. transformation can still proceed if this field is not populated |
11 | Low | FACILITYBUKRS | Check if Facility Company Code (FACILITYBUKRS) is equal to "Blank" if Product Type (SGSART) ="BGR" AND Transaction Type ='ISS" | Facility Company Code not available Note: This is not a Hard error i.e. transformation can still proceed if this field is not populated |
12 | Low | FTR_APPLICANT | Check if applicant (FTR_APPLICANT) is equal to "Blank" if Product Type (SGSART) ="BGR" AND Transaction Type ='REC' | Applicant is not available Note: This is not a Hard error i.e. transformation can still proceed if this field is not populated |
13 | Low | FTR_BENEFICIARY | Check if beneficiary (FTR_BENEFICIARY) is equal to "Blank" if Product Type (SGSART) ="BGR" AND Transaction Type ='ISS" | Beneficiary is not available Note: This is not a Hard error i.e. transformation can still proceed if this field is not populated |
14 | High | Pre Load Report | A preload report in the DCT format to be made available with all relevant errors, if any. Show the record as Ok if no error found. | Preload report in the DCT Format |
Conversion Process
The generic high-level process steps for the conversion are as below:
- Extraction:
- Extract from the source systems: Apply the selection parameters and data relevancy as mentioned in this specification, from the relevant tables
- DCT: The DCT to be prepared if the data to be transformed and is part of the load file is not available in the Source system
- Transform
- Transform fields by applying the fields and value mapping in the Syniti
- Generate and validate Pre-load files
- Load
- Load the validated Pre-load file using SAP's LTMC or the custom upload program as applicable.
However, with respect to object 9111- TRM Bank Guarantees, DCT will be used for transformation and generation of the pre-load file.
Data Privacy and Sensitivity
Not Applicable
Extraction
Extract data from a source into. There are 2 possibilities:
- The data exists. connects to the source and loads the data into. There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
- The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in. This is to be conducted using DCT (Data Collection Template) in
The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads.
However, with respect to object 9111- TRM Bank Guarantees, DCT will be used for transformation and generation of the pre-load file and hence no extraction is needed.
Selection Screen
Not applicable as the extraction is not relevant due to source data to be gathered via DCT.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.9111- TRM Bank Guarantee DCT Rules
| Field Name | Field Description | Data Type | Length | Rule |
|---|---|---|---|---|
BUKRS | COMPANY_CODE | CHAR | 4 | This is a Required field. |
SGSART | PRODUCT_TYPE | CHAR | 3 | This is a Required field. |
SFHAART | TRANSACTION_TYPE | CHAR | 3 | This is a Required field. |
KONTRH | PARTNER | CHAR | 20 | This is a Required field. |
DVTRAB | CONTRACT_DATE | DATS | 8 | This is a Required field. |
DBLFZ | Term Start | DATS | 8 | This is a Required Field |
DELFZ | Term End | DATS | 8 | This is a Required Field |
RPORTB | PORTFOLIO | DATS | 10 | This is an Optional field. It is the Portfolio Code (if relevant for Bank Guarantee) for reporting purposes. In DCT, S4HANA Portfolio Codes needs to be populated based upon the list of Portfolio's configured in the system. This list needs to be provided to the business Team by the functional team. Validation check needs to be done with check table TWPOB |
ZUOND | ASSIGNMENT | CHAR | 18 | This is an Optional field. No validations needed for this field. |
REFER | INTERNAL_REFERENCE | CHAR | 16 | This is an Optional field. No validations needed for this field. |
MERKM | CHARACTERISTICS | CHAR | 25 | This is a Required field. |
RCOMVALCL | VALUATION_CLASS | CHAR | 4 | This is a Required field. |
WGSCHFT | Transaction Currency | CUKY | 5 | This is a Required Field |
| FACILITYNR | FACILITY | CHAR | 13 | This is Conditional Field, to be used if a Facility is linked to issue of a Bank Guarantee. Note: this will be dependent upon creation of the Facilities via the object 9113- TRM - Facility |
FACILITYBUKRS | FACILITY_COMPANY_CODE | CHAR | 4 | This is Conditional Field, to be used if a Facility is linked to issue of a Bank Guarantee. The field is to be populated with Company Code for which a Facility exists. Note: this will be dependent upon creation of the Facilities via the object 9113- TRM - Facility |
BEHALF_OF_COMPANY | ON BEHALF OF COMPANY | CHAR | 4 | This is Optional Field To be populated with the S4HANA Company Code for which a Bank Guarantee is issued as "On Behalf of" |
RCNTR (KOSTL) | COST CENTRE | CHAR | 10 | This is Optional Field To be input only if needed for reporting. |
RDEALER | TRADER | CHAR | 10 | This is Optional Field. Keep Blank as Trader function is not in use. |
GSPPART | CONTACT PERSON | CHAR | 19 | This is Conditional Field. To be filled up if Applicant or Beneficiary not filled The information can be filled as Free Text up to 19 Characters. |
NOTICE_DATE | OTC Notice Date | DATS | 8 | This is Optional Field Fill with a Notice Date if applicable. |
BNWHR | Amount or Balance | CURR | 13 | This is a Required Field To be filled with the Bank Guarantee amount. |
FTR_BG_NUMBER | BANK_GUARANTEE_NUMBER | CHAR | 16 | This is a Required Field (Can be same Assignment) |
| FTR_BG_TYPE | BANK_GUARANTEE_TYPE | CHAR | 4 | This is a Required Field Enter the Bank Guarantee Type. The list of the bank guarantee type will be provided to the Business Team responsible for creating the source data. This is to be validated against table TLCT_BG_TYPE |
FTR_APPLICANT | APPLICANT | CHAR | 10 | This is Conditional Field. Users to fill an applicant code if Bank Guarantee is received The applicant code is a Partner with the Counterparty Role |
FTR_BENEFICIARY | BENEFICIARY | CHAR | 10 | This is Conditional Field. Users to fill a beneficiary code if Bank Guarantee is issued The applicant code is a Partner with the Counterparty Role |
FTR_BUTXT | MANUAL_PARTY_COMPANY_NAME | CHAR | 25 | This is Conditional Field. Users to fill this field with the Company Name (as free text) in case of no beneficiary/applicant involved |
| FTR_XKONTRH | MANUAL_PARTY_COMPANY_ADDRESS | CHAR | 80 | This is Conditional Field. Users to fill this field with the Company Address (as free text) in case of no beneficiary/applicant involved |
FTR_ADVISING_BANK | ADVISING BANK | CHAR | 10 | This is optional field Users to fill this field if advising bank information is available. |
| EBELN | PURCHASE ORDER | CHAR | 10 | This is optional field Users to fill this field if purchase order information is available against which a Bank Guarantee is received. |
VBELN_VA | SALES ORDER | CHAR | 10 | This is optional field Users to fill this field if sales order information is available against which a Bank Guarantee is issued. |
Extraction Dependencies
For object 9111 - TRM Bank Guarantees dependencies are applicable as under
| Item # | Step Description | Team Responsible |
|---|---|---|
| 01 | TRM Business Partners with role 000000 and TR0151 have been created | Data Team/Functional Treasury Team |
| 02 | Treasury Configuration as designed is available in the relevant configuration tables such as:
| Functional Treasury Team |
Transformation
The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow to make the data Target ready:
- Perform value mapping and data transformation rules.
- Legacy values are mapped to the to-be values (this could include a default value)
- Values are transformed according to the rules defined in
- Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation
Transformation Run Sheet
| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Ensure all the fields that require value mapping, as stipulated Mapping tables, have the latest signed-off mapping files imported into Syniti | Data team |
2 | Ensure that signed off value mappings have been maintained in the Syniti | Syniti team |
3 | Confirm the value mappings as maintained in the Syniti | Data team |
4 | Ensure that Signed off CONSTRUCT from business has been received and maintained in Syniti | Syniti/Data team |
5 | Execute transformation for the object | Syniti team |
6 | Monitor the transformation progress and ensure performance and completion is within allowed timeframe | Syniti/Data team |
7. | Generate Pre-Load reports. | Syniti team |
8. | Generate data load count. | Syniti team |
9. | Log errors as defects, if any and address resolutions. Close defects. | Syniti/Data team |
10. | Re-transform and re-validate the Pre-load reports if necessary. | Syniti/Data team |
11. | Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off. | Business |
12. | Analyse and resolve any pre-load defects logged by business. | Syniti/Data team |
13. | Repeat steps 5 to 11 if necessary | Syniti/Data team |
14. | 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 |
|---|---|---|---|---|---|---|---|---|---|
| 01 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | BUKRS | COMPANY_CODE | From DCT field "BUKRS” |
| 02 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | RFHA | TRANSACTION NUMBER | Internal Field generated by SAP. |
| 03 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | SGSART | PRODUCT_TYPE | From DCT field "SGSART" |
| 04 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | SFHAART | TRANSACTION_TYPE | From DCT field "SFHAART" |
| 05 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | KONTRH | PARTNER | From DCT field "KONTRH" |
| 06 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | DBLFZ | Term Start | From DCT field "DBLFZ" |
| 07 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | DELFZ | Term End | From DCT field "DELFZ" |
| 08 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | RPORTB | PORTFOLIO | From DCT field "RPORTB" |
| 09 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | WGSCHFT | Transaction Currency | From DCT field "WGSCHFT" |
| 10 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | ZUOND | ASSIGNMENT | From DCT field "ZUOND" or "FTR_BG_NUMBER" |
| 11 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | REFER | INTERNAL_REFERENCE | From DCT field "REFER" |
| 12 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | MERKM | CHARACTERISTICS | From DCT field "MERKM" |
| 13 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | RCOMVALCL | VALUATION_CLASS | From DCT field "RCOMVALCL" |
| 14 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | FACILITYNR | FACILITY | From DCT field "FACILITYNR" |
| 15 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHA | FACILITYBUKRS | FACILITY_COMPANY_CODE | From DCT field "FACILITYBUKRS” |
| 16 | NA | NA | NA | CONSTRUCT | S4HANA | VTBHFA | BEHALF_OF_COMPANY | ON BEHALF OF COMPANY | From DCT field "BEHALF_OF_COMPANY" |
| 17 | NA | NA | NA | CONSTRUCT | S4HANA | VTBHFA | RCNTR (KOSTL) | COST CENTRE | From DCT field "RCNTR" |
| 18 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAZU | DVTRAB | CONTRACT DATE | From DCT field "DVTRAB" |
| 19 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAZU | RDEALER | TRADER | From DCT field "RDEALER" or blank |
| 20 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAZU | GSPPART | CONTACT PERSON | From DCT field "GSPPART" or blank |
| 21 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAZU | NOTICE_DATE | OTC Notice Date | From DCT field "NOTICE_DATE" |
| 22 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | BNWHR | Amount or Balance | From DCT field "BNWHR" |
| 23 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | FTR_BG_NUMBER | BANK_GUARANTEE_NUMBER | From DCT Field "FTR_BG_NUMBER" |
| 24 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | FTR_BG_TYPE | BANK_GUARANTEE_TYPE | From DCT Field "FTR_BG_TYPE" |
| 25 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | FTR_APPLICANT | APPLICANT | From DCT Field "FTR_APPLICANT" or blank |
| 26 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | FTR_BENEFICIARY | BENEFICIARY | From DCT Field "FTR_BENEFICIARY" or blank |
| 27 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | FTR_BUTXT | MANUAL_PARTY_COMPANY_NAME | From DCT Field "FTR_BUTXT" or blank |
| 28 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | FTR_XKONTRH | MANUAL_PARTY_COMPANY_ADDRESS | From DCT Field "FTR_XKONTRH" or blank |
| 29 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | FTR_ADVISING_BANK | ADVISING BANK | From DCT Field "FTR_ADVISING_BANK " or blank |
| 30 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | EBELN | PURCHASE ORDER | From DCT Field "EBELN" or blank |
| 31 | NA | NA | NA | CONSTRUCT | S4HANA | VTBFHAPO | VBELN_VA | SALES ORDER | From DCT Field "VBELN_VA " or blank |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
| Business Partner | Mapping Table for Quantum counterparty/partner code to S4HANA Business Partner |
Transformation Dependencies
List the steps that need to occur before transformation can commence| 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 Syniti | Data team |
2 | Ensure that signed off value mappings have been maintained in the Syniti | Syniti team |
3 | Confirm the value mappings as maintained in the Syniti | Data team |
4 | Ensure that Signed off DCT from business has been received and maintained in Syniti | Syniti/Data team |
5 | Confirm on the extracted values | Syniti, Data and business |
Pre-Load Validation
Project Team
The Pre Load validations are performed by Project TeamCompleteness
| Task | Action |
|---|---|
Generation of | Mandatory field check.
|
Record Count | Record Count Confirm the record counts in preload summary report
|
Business Confirmation | Data team after the initial validation of pre-load validation based on the pre agreed validation checklist To send the pre-load file to the Business Representatives. Business Representatives to validate the pre-load file. Agree with data team on the next steps for erroneous records. |
Accuracy
| Task | Action |
|---|---|
Business
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Load
The load process includes:
- Execute the automated data load into target system using load tool or product the load file if the load must be done manually
- Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation
Load Run Sheet
| Item # | Step Description | Team Responsible |
|---|---|---|
Load Phase and Dependencies
Configuration
| Item # | Configuration Item |
|---|---|
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram) | |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
Post-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Business
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
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.