RetailPro ATP | Aiden services - Documentation Portal

In order to use the ATP RetailPro Service option (see Config Guide RetailPro Branch Server), adjust the Stored Procedure APD _RP_GET_ ATPDATA.

The Stored Procedure will then be updated in the Database.

An example for a SAP HANA environment using custom ATP logic:

SQL

ALTER PROCEDURE APD_RP_GET_ATPDATA(
    IN ITEMCODE NVARCHAR(50),
    IN WHSCODE NVARCHAR(8),
    IN QUANTITY INTEGER
)
AS
BEGIN

SELECT "ItemCode", "WhsCode", "NextDeliveryDateSource", "NextDeliveryDateQuantity", "CurrentAvailableQuantity"
FROM "_SYS_BIC"."NDB.sap.SBODEMONL_TEST3/ACM_CONT_CHECK_ATP"
(PLACEHOLDER."$$ITEMCODE$$" => :ITEMCODE,
    PLACEHOLDER."$$WHSCODE$$" => :WHSCODE,
    PLACEHOLDER."$$QUANTITY$$" => :QUANTITY
);
END

Query should only returns fields "ItemCode", "WhsCode", "NextDeliveryDateSource", "NextDeliveryDateQuantity" and "CurrentAvailableQuantity".