2 Table's different dates with one filter

hilmignc · ‎2021-01-21

Hi,

I got two tables "Sales" and "Production". I just have keyfldmaterial same.

I want to filter date, example: 2020, sales (Validfrom) and production (Postdate) in 2020 must be show.

They are seperated 2 table on screen, but i want managed those dates with one mastercalendar.

"sales" (Validfrom) not equal "production" (Postdate)

Can you help me, thanks 🙂

LOAD doctype,
docnum,
validfrom,
quantity,
grandtotal,
keyfldmaterial;

[Sales]:
SELECT "doctype",
"docnum",
"validfrom",
"quantity",
"grandtotal",
"keyfldmaterial"
FROM "SALES";

LOAD

keyfldmaterial,
potype,
prdorder,

quantity,
postdate;

[Production]:
SELECT
"keyfldmaterial",
"potype",
"prdorder",
"quantity",

"postdate"

FROM "Production";

Vegar · ‎2021-01-21

You could take a look at HICs good old blog post on Canonical Date.

hilmignc · ‎2021-01-29

Hi again, i solve my problem shoter way.

I defined one keyflddate for mastercalendar and other two tables. its worked for me.

example;

[Production]:

"postdate" as keyflddate;

[Sales]:

"validfrom" as keyflddate;