badda_bing
Well Known Member
Can anyone advise how they manage to join F0411 and F4311 for reporting purposes?? I thought the obvious way is to use the following joins;
F0411.RPPKCO = F4311.PDKCOO
F0411.RPPO = F4311.PDDOCO
F0411.RPPDCT = F4311.PDDCTO
F0411.RPLNID = F4311.PDLNID
F0411.RPSFXO = F4311.PDSFXO
However RPPO on the F0411 is a string and PDDOCO on the F4311 is a numeric therefore we cannot join on them. This is on 7332. Firstly can anyone tell me if this is always been the case ie RPPO has always been a string because we have a reporting tool that has some data models of JDE included that uses the joins above. Secondly, is there anyway around this issue?
TIA
Paul
F0411.RPPKCO = F4311.PDKCOO
F0411.RPPO = F4311.PDDOCO
F0411.RPPDCT = F4311.PDDCTO
F0411.RPLNID = F4311.PDLNID
F0411.RPSFXO = F4311.PDSFXO
However RPPO on the F0411 is a string and PDDOCO on the F4311 is a numeric therefore we cannot join on them. This is on 7332. Firstly can anyone tell me if this is always been the case ie RPPO has always been a string because we have a reporting tool that has some data models of JDE included that uses the joins above. Secondly, is there anyway around this issue?
TIA
Paul