Sales Items

SQL-Vorlage aus der reybex-Standardbibliothek – für BAS23-Exportjobs und Ad-hoc-Tests.

← Alle Beispiel-SQLs

Abfrage

SELECT
salesDocType.name,
salesHead.doc_number,
salesHead.order_description,
marktplace.name,
supportedMarketplace.name,
material.mat_code,
material.sku,
material.name
FROM sales_head salesHead
JOIN ltt_sales_doc_type as salesDocType on salesDocType.id = salesHead.doc_type_id
LEFT JOIN sales_item as salesItem on salesItem.sales_head_id = salesHead.id
LEFT JOIN material as material on material.id = salesItem.material_id
LEFT JOIN ltt_marktplace as marktplace on marktplace.id = salesHead.marktplace_id
LEFT JOIN lt_supported_marktplace as supportedMarketplace on supportedMarketplace.id = marktplace.supported_marketplace_id
WHERE salesHead.tenant_id = :tenantId AND salesHead.is_delete = 0 AND salesItem.is_delete = 0;