Report definitions
Report metadata from ZE_ENQ
1 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
BUYER_SALES_ENQUIRY3 |
BUYER SALES ENQUIRY | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_DELIND <> 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_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 LEFT JOIN PALL_TRANS ON SD_MARKET = PT_MARKET AND SD_AGENT = PT_OWNER AND SD_CONSIGN = PT_CONSIGN AND PT_DELDATE = SD_DATE AND PT_DEBTOR = ST_DEBTOR AND ST_DOCNO = PT_DOCNO AND ST_TRTYPE = PT_TRTYPE |