Skip to end of metadata
Go to start of metadata

When editing the downloaded CSV file using Excel, it can happen that excel removes the leading zeros. This can lead to issues, when uploading the file.

As a solution, you can implement BAdI /SCA/FTR_FIELD_SERVICE_CSV method CHANGE_RAW_FIELD_VALUE_INPUT where you can extend the data with leading zeros.

You can find a sample implementation below.

 iv_column_name contains the master datas parameter, cv_value contains the value.

 

  • You can change the following fields depending on the process: CARRIER_SCAC, ORDERID, ITMID, SDLID
  • ASNID, PRODUCT_NO, ASN_QTY, UNIT, SHIP_DATE, SHIP_TIME, DELV_DATE, DELV_TIME
  • CUST_LOC_NO, SHIPFROM_LOC_NO, PRTBATCHID, TTYPE, MYCUST_LOC_NO, MYPROD_NO
  • ORTYPE, WAYBILL_ID, CARRIER_PARTY
  • Sample implementation for profile type ORDFCST, only numerical values are updated in this case

DATA: lv_cus_locno TYPE /SCF/LOCNO,
            lv_prod_no TYPE /SCF/PROD_ID.

IF iv_column_name = 'SHIPFROM_LOC_NO' AND cv_value CO '0123456789'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
input = cv_value
IMPORTING
OUTPUT = lv_cus_locno
.

cv_value = lv_cus_locno.

ENDIF.

IF iv_column_name = 'CUST_LOC_NO' AND cv_value CO '0123456789'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
input = cv_value
IMPORTING
OUTPUT = lv_cus_locno
.

cv_value = lv_cus_locno.

ENDIF.

IF iv_column_name = 'PRODUCT_NO' AND cv_value CO '0123456789'.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
input = cv_value
IMPORTING
OUTPUT = lv_prod_no
.
cv_value = lv_prod_no.

ENDIF.

 

 

 

Related SAP Notes/KBAs

Insert links to any related SAP Notes/KBAs that support your topic or are related. Please hyperlink ONLY SAP Note or KBA number.
Example:

SAP Note 83020: What is consulting, what is support

SAP KBA 12345: This is an example KBA link

(Use the following Hyperlink with SAP Note/KBA number at end: https://service.sap.com/sap/support/notes/123456)
__________________________________________________________________________________________________________

Use this structure to help you compose your contributions for WIKI and at the same time will ensure spelling and grammar.