[FUNCTION]GET_BUDAT

CREATE OR REPLACE FUNCTION SAPHEE.GET_BUDAT (IN_MANDT VARCHAR2, IN_EBELN VARCHAR2, IN_EBELP VARCHAR2 )

RETURN VARCHAR2 IS
        RT VARCHAR(30) DEFAULT '';
        P_MANDT VARCHAR(9) DEFAULT ''; 
        P_EBELN VARCHAR(30) DEFAULT '';
        P_EBELP VARCHAR(30) DEFAULT '';

        BEGIN
             P_MANDT := RTRIM(IN_MANDT);
             P_EBELN := RTRIM(IN_EBELN);
             P_EBELP := RTRIM(IN_EBELP);
            
             SELECT     MAX(SAPHEE.GET_ZERODATE(BUDAT)) AS BUDAT
             INTO       RT
                          FROM       SAPHEE.ZMMT017
                          WHERE      MANDT  = P_MANDT
                          AND        EBELN  = P_EBELN
                          AND        EBELP  = P_EBELP
                          AND        PRO_F >= '1'
                          GROUP BY   MANDT, EBELN, EBELP;
             RETURN RT;
         END;