cancel
Showing results for 
Search instead for 
Did you mean: 

errorr in data loading

Former Member
0 Kudos

Hi experts,

I written the routine where the calday is converted to quarter but there is no syntax error. when i try to  loading the below error message displaying so can any one suggest this issue.

@5C@InfoObject ZQUARTER does not fulfill ref. integrity in record 1 in value 04RSAR192@35@@3R@

below the code

data:p1(02).

     p1 = SOURCE_FIELDS-calday+4(2).

     if p1 = 01 or p1 = 02 or p1 = 03.

       move '04' to p1.

     elseif p1 = 04 or p1 = 05 or p1 = 06.

       move '01' to p1.

     elseif p1 = 07 or p1 = 08 or p1 = 09.

       move '02' to p1.

     elseif p1 = 10 or p1 = 11 or p1 = 12.

       move '03' to p1.

     endif.

     RESULT =    p1 .

Regards

RK

Accepted Solutions (1)

Accepted Solutions (1)

RamanKorrapati
Active Contributor
0 Kudos

Hi Ram,

As my guess you may be selected ref. integrity check box  for your info object ZQUARTER mappings at transformations.

Please recheck your mappings of ZQuarter--> rule details--> if you selected ref.integrity, untick and activate your transformations and try to load data.

better to do the test rule once.


Thanks

Answers (1)

Answers (1)

MGrob
Active Contributor
0 Kudos

Hi

Why do you write a routine when you have calday? You can just assign calday to quarter and the time derive is automatically.

hope that helps

Martin