tables
-
TABLES关键字
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960"用tables关键字申明表的同时,也申明了同名的结构体,所以select...endselect或者select single查询时未指定into对象,但没问题."代码来源:CYAUFTR1TABLES: CAUFV, AFVC, *AFVC, AFVV, CRHD, PLAF, KBKO.SELECT * FROM AFVC WHERE AUFPL = CAUFV-AUFPLAND SUMNR = '00000000'ORDER BY VORNR.* Hauptvorgang oder Phase selektiert.IF AFVC-PHFLG IS INITIAL.ULINE.WRITE: /'Vorgang: ' COLOR 3 NO-GAP. "#EC NOTEXTELSE.WRITE: /' Phase: '. "#EC NOTEXTENDIF.SELECT SINGLE * FROM AFVV WHERE AUFPL = AFVC-AUFPLAND APLZL = AFVC-APLZL.SELECT SINGLE * FROM CRHD WHERE OBJTY = 'A'AND OBJID = AFVC-ARBID.MGVRG = AFVV-MGVRG.VGW01 = AFVV-VGW01.VGW02 = AFVV-VGW02.VGW03 = AFVV-VGW03.WRITE: AFVC-VORNR COLOR 3,' APLZL: ', AFVC-APLZL, "#EC NOTEXT' BEDZL: ', AFVC-BEDZL, "#EC NOTEXT/ ' ARBPL: ', AFVC-ARBID, CRHD-ARBPL, "#EC NOTEXT' Menge: ', MGVRG, AFVV-MEINH, "#EC NOTEXT/ ' Vorgabewerte (1-3): ', "#EC NOTEXTVGW01, AFVV-VGE01,VGW02, AFVV-VGE02,VGW03, AFVV-VGE03.* KBEDs zum HauptvorgangPERFORM WRITE_KBED USING AFVC-BEDIDAFVC-BEDZLSPACE.* Untervorgänge zum HauptvorgangSELECT * FROM AFVC INTO *AFVCWHERE AUFPL = CAUFV-AUFPLAND SUMNR = AFVC-APLZLORDER BY VORNR.* Untervorgang selektiert.SELECT SINGLE * FROM CRHD WHERE OBJTY = 'A'AND OBJID = *AFVC-ARBID.IF AFVC-PHFLG IS INITIAL.WRITE: /' ', 'Untervorgang: ' COLOR 4 NO-GAP. "#EC NOTEXTELSE.WRITE: /' ', 'Sekundaerressource: ' COLOR 4 NO-GAP. "#EC NOTEXTENDIF.WRITE: *AFVC-VORNR COLOR 4,' APLZL: ', *AFVC-APLZL, "#EC NOTEXT' BEDZL: ', *AFVC-BEDZL, "#EC NOTEXT/ ' ARBPL: ', *AFVC-ARBID, CRHD-ARBPL. "#EC NOTEXT* KBEDs zu Untervorgang/SekundärressourcePERFORM WRITE_KBED USING *AFVC-BEDID*AFVC-BEDZLSPACE.ENDSELECT.ULINE.ENDSELECT. -
SAP ECC中最重要的550张表
表名 简短描述 ADCP Person/Address Assignment (Business Address Services) ADR2 Telephone Numbers …