SAP MM - 자재코드 내역 SQL
SELECT KSSK~OBJEK, "자재코드 KSSK~KLART, "자재는 모두 001 KSML~IMERK, "자재내역 종류들 KSML~POSNR, "자재내역 종류들의 번호 CABN~ATNAM, "특성이름 AUSP~ATWRT, CAWN~ATZHL, "각 특성값에 들어갈 수 있는 POSSIBLE ENTRY CAWNT~ATWTB "언어별 특성값 FROM KSSK AS KSSK INNER JOIN KLAH AS KLAH ON KSSK~CLINT = KLAH~CLINT INNER JOIN KSML AS KSML ON KSML~CLINT = KLAH~CLINT INNER JOIN CABN AS CABN ON KSML~IMERK = CABN~ATINN LEFT OUTER JOIN AUSP AS AUSP ON KSS..
SAP MM
2023. 2. 17. 14:33