Service Depot Repair Item Line

This table shows the table from which fields are retrieved for the dimension:

Table Description
tsmsc110 Maintenance Sales Order Item Lines

This table shows the attribute mapping for the dimension:

Attribute Mapping
Actual Delivery Time tsmsc110.adtm
Actual Problem Code tsmsc110.prob
Actual Receipt Date tsmsc110.artm
Actual Solution Code tsmsc110.soln
Blocked tsmsc110.blyn
Blocked Filter tsmsc110.blyn
Blocked Sort tsmsc110.blyn
Cancel Date tsmsc110.cdat
Company tsmsc110.compnr
Conformance Reporting tsmsc110.cncd
Delivery Location tsmsc110.dloc
Delivery Repair Site tsmsc110.tste
Delivery Site tsmsc110.dste
Delivery Warehouse tsmsc110.dwrh
Installation Group tsmsc110.clst
Item Label tsmsc110.ilbl
Item Line tsmsc110.lino
Line Procedure tsmsc110.lpro
Line Procedure Filter tsmsc110.lpro
Line Procedure Sort tsmsc110.lpro
Line Status tsmsc110.lsta
Line Status Filter tsmsc110.lsta
Line Status Sort tsmsc110.lsta
Maintenance Sales Order tsmsc110.cmso
Master Routing tsmsc110.camr
Operations Department tsmsc110.mdpt
Planned Delivery Time tsmsc110.pdtm
Pricing Contract Line tsmsc110.pcln
Problem Solving Method tsmsc110.pbsm
Problem Solving Method Filter tsmsc110.pbsm
Problem Solving Method Sort tsmsc110.pbsm
Project Activity tsmsc110.pcac
Project Element tsmsc110.cspa
Quote Header tsmsc110.qtno
Quote Line tsmsc110.qtnl
Quote Line Alternative tsmsc110.altn
Quote Revision tsmsc110.revn
Receipt Location tsmsc110.rloc
Receipt Repair Site tsmsc110.fste
Receipt Warehouse tsmsc110.rwrh
Reference Activity tsmsc110.crac
Replacement For Line tsmsc110.rlno
Revision tsmsc110.revi
Routing Option tsmsc110.caro
Sales Quantity Conversion Factor tsmsc110.cvqs
Sales Type tsmsc110.styp
Service Type tsmsc110.cstp
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields