Skip to main content
Question

Data model relation for two tables which are related in 1-N relation(VBAP:1 and VBRP:N).

  • February 8, 2022
  • 2 replies
  • 20 views
R
Level 3

These two tables are related in 1-N relation(VBAP:1 and VBRP:N). 

Also in some cases there are no entries in VBRP(AUBEL and AUP) for some entries in VBAP(VBELN and POSNR).

 

I am creating an Olap to find all entries in VBAP (VBELN and POSNR) which does not have related data in VBRP(AUBEL and AUP) but they dont show up in olap. If i remove the VBRP columns from olap then they show up.

    2 replies

    B
    Level 0
    Hello Roshan, thanks for reaching out. Could you please report this issue at servicedesk@celonis.com? We can then continue our communication there. Many thanks for your understanding. Best Regards, Blenda
    M
    Level 1

    Hi Roshan, was there a solution for this? I’m facing same issue & trying to join exactly same tables & on same fields.

    Community Code of ConductAccessibility statement