Report definitions
Report metadata from ZE_ENQ
1 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
COLD_STORAGE_BYR |
COLD STORAGE STOCK INCL OTHER DEPOSITS | LOC_TRANS | WHERE LT_TYPE = 'DP' AND (LT_PRQTY_AVAIL > '0' OR LT_PALL_QTY_AVAIL > '0') AND LT_DELIND <> 'Y' AND (NOT ISNULL(LT_DEBTOR) OR LT_DEBTOR <> '') |
LEFT JOIN STK_DETS ON LT_MARKET = SD_MARKET AND LT_AGENT = SD_AGENT AND LT_CONSIGNO = SD_CONSIGN AND LT_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO INNER JOIN LOCATION_MAST ON LM_CODE = LT_LOCA |