Max time & date in SAP query

[former_member637207]

Hi,

I'm trying to make a SAP query for table LTAP with the following fields:

LTAP-LGNUM (Warehouse Number)

LTAP-MATNR (Material Number)

LTAP-WERKS (Plant)

LTAP-NLTYP (Destination Storage Type)

LTAP-NLPLA (Destination Storage Bin)

LTAP-PQUIT (Indicator: confirmation complete)

LTAP-QDATU (Date of confirmation)

LTAP-QZEIT (Time of confirmation)

The idea here is, by entering with warehouse number, plant, storage type and with some materials. Get the last storage bin where the material was stored.

Is it possible to create a  Z field with code in the coding area of the info-set (one for max LTAP-QDATU and one for max LTAP-QZEIT)?

Can some one provide it?

Thanks in advance.

[Former Member]

Yes this is possible create a z field and write the required code form featching the data in SQ02.

and this very easy to make, prove on which basis you want to calculate the field so that we may provide you the code.

regards,

Abdul Rahim

[former_member637207]

Hi Shaik,

As an example, with the data below (table 1), by entering in the query with fields LGNUM, MATNR, WERKS, NLTYP, VLTYP and PQUIT (Indicator: confirmation complete), I want to get for material A and material B the storage bins with last confirmation date and confimation time. After process the query, the result should be as shown in table 2.

As I understant, QDATU and QZEIT, should be ZQDATU an ZQZEIT so we can insert the coding.

In which one of the code sections should the code be inserted?

Table 1:

LGNUM	NLTYP	MATNR	MAKTX	NLPLA	QDATU	QZEIT
XXX	YYY	MAT A	AAAAA	CC-YY-ZZ	17-09-2013	15:34:52
XXX	YYY	MAT A	AAAAA	DD-YY-ZZ	07-10-2013	17:04:19
XXX	YYY	MAT A	AAAAA	EE-YY-ZZ	07-10-2013	17:04:22
XXX	YYY	MAT A	AAAAA	FF-YY-ZZ	09-10-2013	10:12:58
XXX	YYY	MAT B	BBBBB	GG-AF-02	17-09-2013	15:34:52
XXX	YYY	MAT B	BBBBB	HH-AF-03	17-09-2013	15:34:53
XXX	YYY	MAT B	BBBBB	II-AF-02	07-10-2013	17:04:19

Table 2:

LGNUM	NLTYP	MATNR	MAKTX	NLPLA	QDATU	QZEIT
XXX	YYY	MAT A	AAAAA	FF-YY-ZZ	09-10-2013	10:12:58
XXX	YYY	MAT B	BBBBB	II-AF-02	07-10-2013	17:04:19

Thanks in advance.

[Former Member]

Dear,

what is your exact requirement let me know so that i can guide you accordingly, what is once of MAX

LTAP-QDATU and one for max LTAP-QZEIT)?

when LTAP is having the field you can fetch them directly, if the field is not available or the field is external field. then we can write the code and populate it then the infoset.

Regards,

Abdul Rahim

[former_member637207]

Hi,

The result shown should be, by selecting MAX LATAP-QDATU and then by MAX LTAP-QZEIT, having just one line for each material.

Is a direct read to table LTAP, if it's not needed a Z field better.

Regards,

[former_member637207]

Hi Shaik Abdul,

Can you please provide de code for the above issue?

Regards,

[JL23]

Have a look into this document, it explains the usage of user defined fields: Infoset Query: User Defined Fields

You can find more documents/blogs/wikis  in SCN if you use the search term: query infoset own field