ACR Credit Control

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

Table Description
tccom001 Employees – General
tccom112 Invoice-to Business Partners
tcmcs064 Credit Ratings

This table shows the attribute mapping for the dimension:

Attribute Mapping
Company tfacr200_compnr
Credit Analyst tccom112.ccra
Credit Analyst ID Name tccom112.ccra + tccom001.nama
Credit Analyst Name tccom001.nama
Credit Rating tccom112.crat
Credit Rating Desc tcmcs064.dsca
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0