ABAP-获取订单状态

 1)

SELECT vbak~vbeln AS vbeln  jsto~obtyp AS obtyp  jsto~objnr AS objnr
       tj30~stsma AS stsma  tj30~estat AS estat  tj30~stonr AS stonr
       jest~inact AS inact  tj30t~txt30 AS txt30
  FROM tj30t AS tj30t
 INNER JOIN tj30 AS tj30
    ON tj30~stsma = tj30t~stsma AND tj30~estat = tj30t~estat
 INNER JOIN jsto AS jsto
    ON tj30t~stsma = jsto~stsma
 INNER JOIN jest AS jest
    ON jest~stat = tj30t~estat
 INNER JOIN vbak AS vbak
    ON vbak~objnr = jsto~objnr AND jest~objnr = vbak~objnr
 WHERE vbak~vbeln LIKE '41%' 
   AND tj30t~spras = '1'
   AND jest~inact = ''

2)

SELECT  vbak~vbeln AS vbeln  
        vbak~auart AS auart  
        vbak~objnr
        tj30t~stsma AS stsma
        jest~stat AS stat  
        tj30t~txt04 AS txt04 
  FROM tj30t AS tj30t  INNER JOIN jsto AS jsto
                          ON tj30t~stsma = jsto~stsma
                       INNER JOIN jest AS jest
                          ON jest~stat = tj30t~estat
                       INNER JOIN vbak AS vbak
                          ON vbak~objnr = jsto~objnr AND jest~objnr = vbak~objnr
  WHERE vbak~vbeln ne ''  
    AND tj30t~spras = '1' 
    AND jest~inact = ''