SD Modülünde Hızlı Veri Okumak

YANLIS:
select from vbak where kunnr = …

DOGRU:
select from vakpa where kunde = …
select from vbak where vbeln = vakpa-vbeln.

EN DOGRU:
select from vbak where vbeln in ( select vbeln from vakpa where kunde = … )


YANLIS:
select from vbap where matnr = …

DOGRU:
select from vapma where matnr = …
select from vbap where vbeln = vapma-vbeln

EN DOGRU:
select from vbap where vbeln in ( select vbeln from vapma where matnr = … )


YANLIS:
select from likp where kunnr = …

DOGRU:
select from vlkpa where kunde = …
select from likp where vbeln = vlkpa-vbeln.

EN DOGRU:
select from likp where vbeln in ( select vbeln from vlkpa where kunde = … )


YANLIS:
select from lips where matnr = …

DOGRU:
select from vlpma where matnr = …
select from lips where vbeln = vlpma-vbeln

EN DOGRU:
select from lips where vbeln in ( select vbeln from vlpma where matnr = … )

YANLIS:
select from vbrk where kunrg = …

DOGRU:
select from vrkpa where kunde = …
select from vbrk where vbeln = vrkpa-vbeln

EN DOGRU:
select from vbrk where vbeln in ( select vbeln from vrkpa where kunde = … )


YANLIS:
select from vbrp where matnr = …

DOGRU:
select from vrpma where matnr = …
select from vbrp where vbeln = vrpma-vbeln

EN DOGRU:
select from vbrp where vbeln in ( select vbeln from vrpma where matnr = … )


YANLIS:
select from vbrp where aubel = …

DOGRU:
select from vbfa where vbtyp_n = ‘M’ and vbelv = …
select from vbrp where vbeln = vbfa-vbeln and posnr = vbfa-posnn


YANLIS:
select vbelv from vbfa where vbeln…

DOGRU:
select vgbel from lips where vbeln = … veya
select vgbel from vbrp where vbeln = … veya
select aubel from vbrp where vbeln = …


YANLIS:
select from vepo where vbtyp = ‘J’ and vbeln = i_lips-vbeln

DOGRU:
select from vbfa where vbtyp_n = ‘X’ and vbelv = i_lips-vbeln
select from vepo where venum = vbfa-vbeln

EN DOGRU:
select from vepo where venum in ( select vbeln from vbfa where vbtyp_n = ‘X’ and vbelv = i_lips-vbeln )

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s