How To Fix WRMA_CAT119 - Payment type &1: Column sorting group not maintained

SAP Error Message - Details

• Message type: E = Error

• Message class: WRMA_CAT - RMA cost allocation

• Message number: 119

• Message text: Payment type &1: Column sorting group not maintained

What causes this issue?

No column sorting group has been assigned to payment type &V1&.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

The columns are arranged in a generic way in the table of invoice items.
This is, in general, not reasonable for the purpose of RMA cost
allocation.

How to fix this error?

Maintain a <DS:SIMG.WLF_TMCSGR>column sorting group</>, and assign it to
the payment type. The column sorting group should contain the following
field names for control <ZH>3</> (settlement request):
<NP>KOMLFP-POSNR</>: Item Number
<NP>KOMLFP-POSNR_MAIN</>: Main Item Number
<NP>KOMLFP-DISTRIB_STATUS</>: Distribution Status
<NP>KOMLFP-EKKOL</>: Condition Group (bucket)
<NP>KOMLFP-WERKS_NAME</>: Plant
<NP>KOMLFP-IDNLF</>: Vendor Material Number (RMA object)
<NP>KOMLFP-IDNLF_TYPE</>: Type of Vendor Material Number
<NP>KOMLFP-MATNR</>: Material
<NP>KOMLFP-LTSNR</>: Vendor Sub-Range
<NP>KOMLFP-TXJCD</>: Tax Jurisdiction Code
<NP>KOMLFP-PNETWR</>: Net Item Amount
RESET N1

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message WRMA_CAT119 - Payment type &1: Column sorting group not maintained ?

  SAP Error Message:
  
  WRMA_CAT119 Payment type &1: Column sorting group not maintained
  
  Cause:
  This error occurs in SAP when processing payment types in the context of payment media or payment runs, specifically in the Payment Medium Workbench (PMW) or related payment configuration. The system expects that for the given payment type (e.g., check, bank transfer), the column sorting group is maintained in the customizing settings, but it is missing or not properly configured.
  The column sorting group is used to define how payment data is sorted and structured in the output file or payment medium. Without this setting, the system cannot correctly generate or format the payment file.
  
  Where does this happen?
  
  During payment medium generation (transaction F110, FBZP, or PMW).
  When the system tries to format the payment data for a specific payment type.
  In customizing under payment medium or payment method configuration.
  
  
  Solution:
  
  
  Maintain Column Sorting Group for the Payment Type:
  
  Go to the SAP customizing path:
  SPRO -> Financial Accounting -> Accounts Payable -> Automatic Outgoing Payments -> Payment Methods/Bank Selection -> Payment Methods in Country -> [Select your country] -> [Select your payment method] -> Assign Payment Medium Formats
  
  Alternatively, for Payment Medium Workbench:
  SPRO -> Financial Accounting -> Payment Medium Workbench -> Define Payment Medium Formats
  
  Find the payment type mentioned in the error message (the placeholder &1 will be replaced by the actual payment type code).
  Check the Column Sorting Group field and maintain the appropriate sorting group.
  
  
  
  Check the Payment Medium Format:
  
  Ensure that the payment medium format assigned to the payment type has the sorting groups defined.
  If you are using a custom payment medium format, verify that the sorting groups and columns are properly configured.
  
  
  
  Verify Payment Method Configuration:
  
  In transaction FBZP, check the payment methods for the company code and country.
  Ensure that the payment method has the correct payment medium format assigned.
  
  
  
  Transport Changes:
  
  After maintaining the sorting group, transport the changes to the relevant system if needed.
  
  
  
  
  Additional Information:
  
  The Column Sorting Group controls the order and grouping of data columns in the payment file.
  Missing or incorrect sorting group settings can cause the payment file generation to fail or produce incorrect output.
  This error is common when new payment types or custom payment formats are introduced but not fully configured.
  Refer to SAP Note or documentation related to Payment Medium Workbench (PMW) for detailed configuration steps.
  
  
  Summary:
  
  
  
  Aspect
  Details
  
  
  
  
  Error Message
  WRMA_CAT119 Payment type &1: Column sorting group not maintained
  
  
  Cause
  Missing or not maintained column sorting group for the payment type in customizing
  
  
  Solution
  Maintain the column sorting group for the payment type in SPRO under payment medium formats
  
  
  Transactions
  SPRO, FBZP, F110, Payment Medium Workbench (PMW)
  
  
  Related Areas
  Payment Medium Workbench, Automatic Outgoing Payments, Payment Method Configuration
  
  
  
  
  If you need, I can guide you step-by-step on how to maintain the column sorting group in your system.