Cost Object

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

Table Description
tcibd001 Item
tppdm005 Project Item
tppdm025 Equipment
tppdm625 Project Equipment
tppdm035 Subcontracting
tppdm635 Project Subcontracting
tppdm015 Labor
tppdm040 Sundry Costs
tppdm042 Overhead
tppdm615 Project Labor
tppdm640 Project Sundry Costs

This table shows the attribute mapping to LN table fields for the dimension:

Attribute Mapping
Company tppdm640.compnr\ tppdm040.compnr\ tppdm015.compnr\ tppdm615.compnr\ tppdm005.compnr
Company Desc tcemm170.desc
Control Code tppdm640.ccts\ tppdm040.ccts\ tppdm015.ccts\ tppdm615.ccts\ tppdm005.ccts
Control Code Base tppdm005.ccit / tppdm015/615.ccts / tppdm040/640.ccic
Control Code Desc tppdm640.desc\ tppdm040.desc\ tppdm015.desc\ tppdm615.desc\ tppdm005.desc
Control Code Filter tppdm005.ccit+'*Item' / tppdm015/615.ccts+'*Labor' / tppdm040/640.ccic+'*Sundry'
Control Code Project tppdm640.cprj\ tppdm040.cprj\ tppdm015.cprj\ tppdm615.cprj\ tppdm005.cprj
Control Code Project Desc tppdm600.dsca
Cost Object tppdm640.cico\ tppdm040.task\ tppdm015.task\ tppdm615.cico\ tcibd001.Item\ tppdm042.ovhd
Cost Object Base tcibd001.item / tppdm015/615.task / tppdm040/640.cico / tppdm042.ovhd
Cost Object Desc tppdm640.desc\ tppdm040.desc\ tppdm015.desc\ tppdm615.desc\ tcibd001.desc\ tppdm042.desc
Cost Object Filter tcibd001.item+'*Item' / tppdm015/615.task+'*Labor' / tppdm040/640.cico+'*Sundry' / tppdm042.ovhd+'*Overhead'
Cost Object Project tppdm640.cprj\ tppdm040.cprj\ tppdm015.cprj\ tppdm615.cprj\ tppdm005.cprj
Cost Object Project Desc tppdm600.dsca
Cost Type Cost Type:
  • Labor
  • Sundry
  • Material
  • Equipment
  • Subcontracting
  • Overhead
Cost Type Filter Cost Type:
  • Labor – tppdm.cotp.tasks
  • Material - tppdm.cotp.materials
  • Equipment - tppdm.cotp.equipment
  • Subcontracting – subcontracting
  • Sundry - tppdm.cotp.indirect
  • Overhead - overhead
Cost Type Sort Cost Type:
  • Labor – 1
  • Material - 2
  • Equipment - 3
  • Subcontracting – 4
  • Sundry - 5
  • Overhead - 10
Item Group tcibd001.citg
Item Group Desc tcmcs023.dsca
Item Type tcibd001.kitm
  • Purchased
  • Manufactured
  • Product
  • Tool
  • Equipment
  • Subcontracted Service
  • Cost
  • Service
  • Generic
  • Engineering Module
  • List
Item Type Filter tcibd001.kitm
  • Purchased - tckitm.purchase
  • Manufactured - tckitm.manufacture
  • Product - tckitm.product
  • Tool - tckitm.tool
  • Equipment - tckitm.equipment
  • Subcontracted Service - tckitm.subcontracting
  • Cost - tckitm.cost
  • Service - tckitm.service
  • Generic - tckitm.generic
  • Engineering Module - tckitm.engineering
  • List - tckitm.list
Item Type Sort tcibd001.kitm
  • Purchased - 1
  • Manufactured - 2
  • Product - 30
  • Tool - 40
  • Equipment - 50
  • Subcontracted Service - 60
  • Cost - 70
  • Service - 80
  • Generic - 90
  • Engineering Module - 100
  • List - 110
Trade Group tppdm015 \ tppdm615.ctrg
Trade Group Desc tppdm016.desc tppdm016.desc
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields