I_InspPlanMaterialAssgmtTP

Insp Plan Version-Material Assignment | view: IIPMATLTP | Extraction: Not supported | Component: Quality Planning
Tables used: PLKOMAPL
Column Name Description
InspectionPlanGroup Key for Task List Group
InspectionPlan Group Counter
InspectionPlanInternalVersion Internal counter
Material FK Material Number
Plant FK Plant
InspPlanMatlAssignment Counter for Additional Criteria
InspPlanMatlAssgmtIntVersion Internal counter
BillOfOperationsType FK Task List Type
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-to date
CreationDate Date Record Created On
LastChangeDate Last Changed On
Column Name Description
IsDeleted Deletion Indicator Show values
Column Name Description Domain name
BillOfOperationsDesc Routing Description TEXT40
CreatedByUser Created By User XUBNAME
LastChangedByUser Last Changed By User XUBNAME
BOOSearchText Search Field for Customer-Specific Task List Selection CHAR20
IsValid null
Master Data Relations Join Conditions
Task List Type
  • Client
  • Task List Type
  • I_INSPPLANMATERIALASSGMTTP.MANDT == TCA01.MANDT
  • I_INSPPLANMATERIALASSGMTTP.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Change Number
  • Change Number
  • Client
  • I_INSPPLANMATERIALASSGMTTP.CHANGENUMBER == AENR.AENNR
  • I_INSPPLANMATERIALASSGMTTP.MANDT == AENR.MANDT
Account number of customer
  • Account number of customer
  • Client
  • I_INSPPLANMATERIALASSGMTTP.CUSTOMER == KNA1.KUNNR
  • I_INSPPLANMATERIALASSGMTTP.MANDT == KNA1.MANDT
Material Number
  • Client
  • Material Number
  • Material Number
  • I_INSPPLANMATERIALASSGMTTP.MANDT == MARA.MANDT
  • I_INSPPLANMATERIALASSGMTTP.MATERIALFOREDIT == MARA.MATNR
  • I_INSPPLANMATERIALASSGMTTP.MATERIAL == MARA.MATNR
Material Number
  • Client
  • Material Number
  • Material Number
  • I_INSPPLANMATERIALASSGMTTP.MANDT == MARA.MANDT
  • I_INSPPLANMATERIALASSGMTTP.MATERIALFOREDIT == MARA.MATNR
  • I_INSPPLANMATERIALASSGMTTP.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • Plant
  • I_INSPPLANMATERIALASSGMTTP.MANDT == T001W.MANDT
  • I_INSPPLANMATERIALASSGMTTP.PLANT == T001W.WERKS
  • I_INSPPLANMATERIALASSGMTTP.PLANTFOREDIT == T001W.WERKS
Plant
  • Client
  • Plant
  • Plant
  • I_INSPPLANMATERIALASSGMTTP.MANDT == T001W.MANDT
  • I_INSPPLANMATERIALASSGMTTP.PLANT == T001W.WERKS
  • I_INSPPLANMATERIALASSGMTTP.PLANTFOREDIT == T001W.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • I_INSPPLANMATERIALASSGMTTP.SUPPLIER == LFA1.LIFNR
  • I_INSPPLANMATERIALASSGMTTP.MANDT == LFA1.MANDT