0INSP_LOT_ATTR

Inspection Lot Number | #ATTR | Extraction method: V | No Delta | Component: Quality Management Master Data

Tables used: QALS → show details

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical
Other (3)
🔗 Relations (12)

Column Name	Description
PRUEFLOS	Inspection Lot Number

Column Name	Description

Column Name	Description

Column Name	Description
ENSTEHDAT	Date in Time Zone Where Lot Created

Column Name	Description

Column Name	Description	Domain name
LS_KDAUF	Sales Order Number	VBELN
BWSTIPL1	Status Object1 Inspection Lot	J_STONR
BWSTIPL2	Status Object2 Inspection Lot	J_STONR

Master Data Relations	Join Conditions
Inspection Type Inspection Type Client	`0INSP_LOT_ATTR.ART == TQ30.ART` `0INSP_LOT_ATTR.MANDT == TQ30.MANDT`
Order Number Client Order Number	`0INSP_LOT_ATTR.MANDT == AUFK.MANDT` `0INSP_LOT_ATTR.AUFNR == AUFK.AUFNR`
Order Number for Recording Appraisal Costs Client Order Number for Recording Appraisal Costs	`0INSP_LOT_ATTR.MANDT == AUFK.MANDT` `0INSP_LOT_ATTR.AUFNR_CO == AUFK.AUFNR`
Purchasing organization Purchasing organization Client	`0INSP_LOT_ATTR.EKORG == T024E.EKORG` `0INSP_LOT_ATTR.MANDT == T024E.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`0INSP_LOT_ATTR.KUNNR == KNA1.KUNNR` `0INSP_LOT_ATTR.MANDT == KNA1.MANDT`
Storage Location for Inspection Lot Stock Client Storage Location for Inspection Lot Stock	`0INSP_LOT_ATTR.MANDT == T001L.MANDT` `0INSP_LOT_ATTR.LAGORTVORG == T001L.LGORT`
Vendor's account number Vendor's account number Client	`0INSP_LOT_ATTR.LIFNR == LFA1.LIFNR` `0INSP_LOT_ATTR.MANDT == LFA1.MANDT`
Sold-to Party Sold-to Party Client	`0INSP_LOT_ATTR.LS_KUNAG == KNA1.KUNNR` `0INSP_LOT_ATTR.MANDT == KNA1.MANDT`
Sales Organization Sales Organization Client	`0INSP_LOT_ATTR.LS_VKORG == TVKO.VKORG` `0INSP_LOT_ATTR.MANDT == TVKO.MANDT`
Material Number Client Material Number	`0INSP_LOT_ATTR.MANDT == MARA.MANDT` `0INSP_LOT_ATTR.MATNR == MARA.MATNR`
Plant Plant Client	`0INSP_LOT_ATTR.WERK == T001W.WERKS` `0INSP_LOT_ATTR.MANDT == T001W.MANDT`