Customer Claim

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

Table Description
tscmm100 Customer Claim

This table shows the attribute mapping for the dimension:

Attribute Mapping
Approval Date tscmm100.apdt
Approval Percentage tscmm100.aper
Cancel Date tscmm100.cndt
Cancel Reason tscmm100.cnre
Claim Origin tscmm100.corg
Claim Origin Filter tscmm100.corg
Claim Origin Sort tscmm100.corg
Company tscmm100.compnr
Creation Date tscmm100.crtm
Currency tscmm100.ccur
Customer Claim tscmm100.ccno
Customer Claim Desc tscmm100.desc
Customer Claim ID Desc tscmm100.ccno + tscmm100.desc
Failure Date tscmm100.fldt
Installation Group tscmm100.clst
Item tscmm100.item
Latest Finish Date tscmm100.lftm
Line of Business tscmm100.cbrn
Measured Value tscmm100.mvln
Measurement Type tscmm100.cmea
Original Order System tscmm100.oosy
Original Order System Filter tscmm100.oosy
Original Order System Sort tscmm100.oosy
Partially Approved tscmm100.papr
Partially Approved Filter tscmm100.papr
Partially Approved Sort tscmm100.papr
Planned Delivery Date tscmm100.pdtm
Problem tscmm100.cprl
Project tscmm100.cprj
Project Activity tscmm100.pcac
Project Element tscmm100.cspa
Project Peg Origin Filter tscmm100.cpor
Project Peg Origin Sort tscmm100.cpor
Rejected Reason tscmm100.rjre
Rejection Date tscmm100.rjdt
Sales Type tscmm100.styp
Serial Number tscmm100.sern
Service Office tscmm100.cwoc
Service Type tscmm100.cstp
Solution tscmm100.cstn
Status tscmm100.stat
Status Filter tscmm100.stat
Status Sort tscmm100.stat
Unknown 1 for null records, else 0
Deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields