Reference Fields Mapping in CGI Payment Formats
To help you better understand the structure of generic payment formats CGI_CT and CGI_DD, we have created an excel file that covers the mapping of all reference fields in the generic and country-specific CGI trees. Reference fields are used to extend the capabilities of the standard fields.
You can find the excel file in this SAP Note (2513995).
Structure of the file
The excel file lists all of the Reference fields used in FPAYHX and FPAYP structures of the CGI format.
The main sheet of the file is the GENERIC sheet which represents Reference fields mapping in CGI_CT and CGI_DD trees.
While the generic payment formats (CGI_CT and CGI_DD) cover various business scenarios, there are some country-specific requirements that are covered in the individual trees. That is why the excel file also contains other sheets which represent the mapping of reference fields in country-specific CGI trees.
Each sheet of the excel file consists of a list of Reference fields mapping in either FPAYHX or FPAYH table. The first column represents the identification of Reference field (e.g. REF01), while the second and third columns specify which part of the field is used in the table (offset + length; e. g. REF01+60(20)).
The column ‘Description’ provides further details about the information stored in the given field. The next columns describe in which tree and where in the tree you can find the mapping:
- Column ‘CT/DD’ is used to distinct between Credit Transfer and Direct Debit trees;
- column ‘Node in CGI Tree’ helps locate the given node in the tree;
- and finally column ‘Node ID’ provides unique node ID thanks to which you can easily find the given node in the tree
Do you have any further comments regarding this topic? Do not hesitate to share them in the comment section below. You are also welcome to ask any questions about SAP S4/HANA Finance in the Community Q&A section.