DTP Terminated

[Former Member]

Guys,

Please Help me to Solve the below Issue.

Because of this all got Data package got terminated.

[Former Member · Accepted solution]

Hi Rgi,

From you message, the data of 0MATERIAL contains special characters or spaces.

In the screen shot, 'Conveyance Allowan' contains  the Space.

Please remove the space and load and then check.

Also, Please check that your 0MATERIAL  infoobject is checked for lowercase or not.

If it is not selected, then small letters are not allowed to load.

Thanks,

Jai Ganesh J

[Former Member · Accepted solution]

Ganesh,

From you message, the data of 0MATERIAL contains special characters or spaces.
In the screen shot, 'Conveyance Allowan' contains  the Space.
Please remove the space and load and then check.

I checked in the PSA for Particular Datapackage 450 and I could not find the Column Name as "Conveyance Allowance"

Also, Please check that your 0MATERIAL  infoobject is checked for lowercase or not.
If it is not selected, then small letters are not allowed to load.

0Material Ifnoobject Does not Checked With Lower Case.

My Worry is its a Standard and more over i m working in production .So suggest me the best idea

[EduardoR · Accepted solution]

Hi,

Please, check the Material field (MATNR) in the PSA. I think there may be some record with 'Conveyance Allowan' value in that field.

MATNR field of the data source contains the material code, so it seems that for some materials its code is the same that its description.

As the 0MATERIAL infoobject doesn't accept Lowercase letters, you can use the TOUPPER formula in the transformation.

Best regards,

Eduardo

[Former Member · Accepted solution]

Hi Rgi,

"Conveyance Allowance" is the record(content) of MATNR. Search in PSA  content for 'Conveyance Allowance' and correct the record and then load.

If lower case not selected in 0material, then the record should be like 'CONVEYANCE ALLOWANCE'.

First, Check all the errors records in the DTP and collect the errorneous records.

Then check the content of  PSA for such error records and correct it in PSA for time being and then load.

Please check the lower case select box and it will fix the error.

Thanks,

Jai Ganesh J

[Former Member · Accepted solution]

Please, check the Material field (MATNR) in the PSA. I think there may be some record with 'Conveyance Allowan' value in that field. 

I Checked in the PSA for Data Package 450

SO just confirm me whether that Dot is the problem??

[Former Member · Accepted solution]

yes, please  just delete if have any dot and try load.

[EduardoR]

Hi Rgi,

Please, review the transformation to ensure that 0MATERIAL is being loaded from MATNR Source field.

If so, you can change Direct Assignment by the following routine:

    DATA: v_txt TYPE /BI0/OIMATERIAL.

    v_txt = SOURCE_FIELDS-MATNR.

    CALL FUNCTION 'SCP_REPLACE_STRANGE_CHARS'

        EXPORTING

          INTEXT                  = v_txt

*  INTEXT_LG              = 0

*  INTER_CP                = '0000'

*  INTER_BASE_CP          = '0000'

*  IN_CP                  = '0000'

*  REPLACEMENT            = 46

      IMPORTING

        OUTTEXT                = RESULT

*  OUTUSED                =

*  OUTOVERFLOW            =

* EXCEPTIONS

*  INVALID_CODEPAGE        = 1

*  CODEPAGE_MISMATCH      = 2

*  INTERNAL_ERROR          = 3

*  CANNOT_CONVERT          = 4

*  FIELDS_NOT_TYPE_C      = 5

*  OTHERS                  = 6

                .

    IF SY-SUBRC = 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

*        WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    TRANSLATE v_txt TO UPPER CASE.

    REPLACE ' ' with '' into v_txt.

    RESULT = v_txt.

[RamanKorrapati]

Hi Rgi,

its lower case or special char issue.

if you observer your text message 'Conveyance Allowan ' - After n, we have space mean there will be an junk(#) char and even it will be lower case issue.

so please delete filed request from cube.

go to psa, ddisplay psa data, keep filter on 0material/Matnr.

try to search for Allowan* and find your record.

open you record in edit mode and see.

if there is no junk char then retype same text in capital and save it.

like that you may need to do for all other text which are lower case.

if your doing at dev system, please use TOUPPER formula at tranformations mappings to 0material.

Thanks.

[Former Member]

Hi RGI SAP,

Go to the detailed error description by clicking on the logn text, and see the screenshot.

Regards,

FM.