Project Cost Detail

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

Table Description
tpppc200 Project Cost Transaction

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

Attribute Mapping
Actual Cost tpppc200.comm_acts
Billable tpppc200.blbl
Billable Filter tpppc200.blbl
Billable Sort tpppc200.blbl
Borrow Loan tpppc200.bwln
Borrow Loan Filter tpppc200.bwln
Borrow Loan Sort tpppc200.bwln
Cost Component for Mapping tpppc200.ccma
Cost Transaction tpppc200.csts
Cost Transaction Filter tpppc200.csts
Cost Transaction Sort tpppc200.csts
Employee tpppc200.emno
Enterprise Unit tpppc200.entu
Entity tpppc200.enid
Entity Type tpppc200.enty
Entity Type Filter tpppc200.enty
Entity Type Sort tpppc200.enty
Financial Company of Origin tpppc200.fcor
Intercompany tpppc200.intc
Intercompany Sort tpppc200.intc
Intercompany Filter tpppc200.intc
Intercompany Trade tpppc200.inti tpppc200.inti
Intercompany Trade Company tpppc200.itco tpppc200.itco
Intercompany Trade Filter tpppc200.inti tpppc200.inti
Intercompany Trade Order tpppc200.inti
Intercompany Trade Order Line tpppc200.itco
Intercompany Trade Sort tpppc200.inti
Invoice-from Business Partner tpppc200.itor
Landed Cost Line Number tpppc200.itln
Order Line tpppc200.pono
Order Line Sequence tpppc200.srnb
Order Number tpppc200.orno
Order Type tpppc200.koor
Order Type Filter tpppc200.koor
Order Type Sort tpppc200.koor
Post to Finance tpppc200.potf
Post to Finance Filter tpppc200.potf
Post to Finance Sort tpppc200.potf
Posting Type tpppc200.ptyc
Posting Type Filter tpppc200.ptyc
Posting Type Sort tpppc200.ptyc
Purchase Receipt Sequence tpppc200.rsqn
Reason tpppc200.reas
Receiving Company tpppc200.ocmp
Reported Complete tpppc200.comf
Reported Complete Filter tpppc200.comf
Reported Complete Sort tpppc200.comf
Stage Payment Line tpppc200.spln
Suppressed for Next Billing tpppc200.ntbl
Suppressed for Next Billing Sort tpppc200.ntbl
Suppressed for Next Billing Filter tpppc200.ntbl
Transaction Origin tpppc200.tror
Transaction Origin Sort tpppc200.tror
Transaction Origin Filter tpppc200.tror
Warehouse tpppc200.cwar
Warehouse Receipt / Shipment tpppc200.rcno
Warehouse Receipt / Shipment Line tpppc200.rcln