InfoObject ZZBSTKD does not contain alpa-conforming value

[Former Member]

Hi Friends,

I have this field ZZBSTKD coming through Append Structure (VBKD-BSTKD - PO # - char 35). It is coming fine till PSA but after that while loading to ODS to a Zfield of char 35, it gives me above error. This Zfield in ODS does not have any Convers. Rout defined. Earlier it was having a conv routine and that time also it was giving the same error so I created a new one without it and changed the same in xfr rule and ODS but still it is giving me the same error.

I have gone through some threads where people were getting the same error. The suggested soln was what I did above OR writing a xfr routine which I dont want to as I want to display values of this PO # without leading zeroes only.

In case a xfr routine is really needed please suggest the parameters as I have never coded one.

DATA: ?

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = ?

IMPORTING

OUTPUT = ?.

RESULT = ?

THANKS,

BJ

[former_member181964]

Hi,

See the following program, and the same logic you can apply in Transfer Rules/Transformations. Take ABAPer help. Change the Code as per your requiremets, first copy and past this code in SE38 and see the result.

REPORT  ZALPHA_INPUT.
 
DATA: ZI(18) TYPE C,
      ZO(12) TYPE C.
 
 
DATA: ZS(12) TYPE C,
      ZR(18) TYPE C.
 
      ZI = '000000099999889925'.
      ZS = '099999889925'.
 
  CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
    EXPORTING
      INPUT         = ZI
   IMPORTING
     OUTPUT        = ZO.
 
  CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
    EXPORTING
      INPUT         = ZS
   IMPORTING
     OUTPUT        =  ZR  .
 
Write:/   ZI.
Write:/   ZO.
 
Write:/   ZS.
Write:/   ZR.

Thanks

Reddy

[Former Member]

Hi Surendra,

Your code works fine in SE38 but I don't know what's wrong, it's not giving desired results in xfr routine.

Even the value in PSA shows same '12345' with no 0s prefixed...

Some sample of values in the vbkd-bstkd are:

053 - 31/05/2006 DOA RETURN

Against SO NO - 170047565

RT S/O 140004075 DOA REPLACE

PO#879

3054 DOT INC

862

-

---

Below is the routine that I wrote...please check.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = TRAN_STRUCTURE-ZZBSTKD

IMPORTING

OUTPUT = RESULT.

RETURNCODE = 0.

ABORT = 0.

DATA:

L_S_SELECTION LIKE LINE OF C_T_SELECTION.

• An empty selection means all values

CLEAR C_T_SELECTION.

L_S_SELECTION-FIELDNM = 'ZZBSTKD'.

• ...

• Selection of all values may be not exact

E_EXACT = RS_C_FALSE.

I am gettng frustrated..please help....

[former_member181964]

Hi,

You pleas etake help of ABAper and do the things, you need to declare the variables and do it one by one. So don't worry you take ABAPer help and apply it in Transforamtions i.e. before filling Cube or in Transfer/Update Rules if it is BW 3,5.

Thanks

Reddy

[Former Member]

Any idea freinds?

[Former Member]

I got it resolved myself.

There was some problem in the Xfr routine. I declared a temp variable and moved the output into it.

Thanks to everyone who helped.

[Former Member]

Hi,

Please use,

LOOP AT SOURCE_PACKAGE ASSIGNING <SOURCE_FIELDS>.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT
EXPORTING
INPUT = <Source_fields>-ZZBSKTD
IMPORTING
OUTPUT = <Source_fields>-ZZBSKTD.
ENDLOOP.

-Vikram

[Former Member]

Hi Vikaram,

What do you mean by <Source_fields> here in <Source_fields>-ZZBSKTD?

Did you mean Data_Package-ZZBSKTD OR COMM_STRUCTURE-ZZBSKTD ?

THANKS!

[Former Member]

Hi,

yes it is COMM_STRUCTURE-ZZBSKTD in BW3.5.

In 7.0 it is source_fields-ZZBSKTD.

Regards,

Gaurav

[Former Member]

Yeah, you are right..it's called source_fields in BI7.

Anyway, my problem is still there...I took help from ABAPr also but the code pasted above remains same....

any errors that you can find which can fix my problem?

Thanks!

[Former Member]

One more thing, these records are though getting loaded in PSA but are erroneous records. The error in PSA mention the same thing.

[Former Member]

Also in one of the thread, sol is said:

rsa->infosource->locate your infosource, change transfer rules, and locate 0DOC_NUMBER, tab 'transfer rules', left side 'Communication str./Transfer r', scroll to right, to last column 'conversion', mark it, activate transfer rules again. and reload data.

I can't see a option to mark in column 'conversion' earlier (when i had the field with conv). It said ALPHA. Is it bcoz I am workin on BW 3.5?