It can happen that for infrastructural reasons, SAP delivery reports cannot be printed directly from Produmex. In such cases, the SAP report needs to be converted to a Produmex report.
This only works for reports built with Crystal Reports.
SAP document reports use 2 input parameters: ObjectID@ and DocKey@. However Produmex uses only 1 input parameter for delivery note reports, so ObjectID@ should be removed and forced to the value 15.
Conversion process
-
1. First copy the .rpt file from the SAP report to a new report. Produmex will use a different rpt file than the standard SAP report.
-
2. Open the PMX report in Crystal reports designer.
-
3. Search for all references of ObjectID@, and replace it by the default value (15) at all places where it's used. Also do the same for all parameters that are not the document key. These parameters can be typically be used in formulas, in the SQL query of the report, or be found directly on the report. Examples:
-
{?ObjectID@}=15 should be replaced by true
-
{PMX_CR_HEADERS.U_ObjID}={?ObjectID@} should be replaced by {PMX_CR_HEADERS.U_ObjID}=15
-
-
4. When ObjectID@ has no reference anymore (its icon changes), remove it from the parameter fields.
-
5. Rename DocKey@ to @salesDeliveryNoteDocEntry for MSSQL, or P_SALESDELIVERYNOTEDOCENTRY for HANA
-
6. Save the report, and set it up as a normal Crystal Report in Produmex.
Comments
0 comments
Please sign in to leave a comment.