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