C_PubSecActiveRegnKPI

Active Registrations Smart Business KPI | view: CPSACTIVEREG | Extraction: Not supported | Component: Public Sector Contract Accounts Receivable and Payable
Column Name Description
PublicSectorObjectType Object Type
PublicSectorObject Object ID
PublicSectorFactTypeSequence Fact Type Sequence
PubSecFactTypeRepetition Fact Type Repetition
PubSecFactValdtyEndDteTme Valid To Date
Column Name Description
Column Name Description
Column Name Description
PubSecRegnValdtyStartDate Valid From Date
PubSecRegnValdtyEndDate Valid To Date
Column Name Description
Column Name Description Domain name
Taxpayer Taxpayer Number BU_PARTNER
TaxPayerName Taxpayer Name
IndustryKeyShortDescription Industry Name TEXT20
TaxpayerAccount Taxpayer Account Number VKONT_KK
TaxpayerAccountName Taxpayer Account Name TEXT35
TaxpayerContract Taxpayer Contract Object Number VTREF_KK
TaxpayerContractName Taxpayer Contract Name PSOBTXT_PS
PublicSectorContractTypeName Name of Taxpayer Contract Type CHAR_30
PublicSectorRevenueTypeName Revenue Type TEXT30
NrOfPubSecActiveRegistrations Number of Active Registrations
Master Data Relations Join Conditions
Fact Set
  • Fact Set
  • Client
  • C_PUBSECACTIVEREGNKPI.PUBLICSECTORFACTSET == TFACT_SET.FACT_SET
  • C_PUBSECACTIVEREGNKPI.MANDT == TFACT_SET.CLIENT
Fact Type
  • Client
  • Fact Type
  • C_PUBSECACTIVEREGNKPI.MANDT == TFACT_TYPE.CLIENT
  • C_PUBSECACTIVEREGNKPI.PUBLICSECTORFACTTYPE == TFACT_TYPE.FACT_TYPE
Revenue Type
  • Revenue Type
  • Client
Contract Object Types
  • Client
  • Taxpayer Contract Type
  • C_PUBSECACTIVEREGNKPI.MANDT == TPSOB001.CLIENT
  • C_PUBSECACTIVEREGNKPI.TAXPAYERCONTRACTTYPE == TPSOB001.PSOBTYP
Taxpayer Standard Industry
  • Taxpayer Standard Industry
  • Client
  • ?
  • C_PUBSECACTIVEREGNKPI.TAXPAYERSTANDARDINDUSTRY == TB038A.IND_SECTOR
  • C_PUBSECACTIVEREGNKPI.MANDT == TB038A.CLIENT
  • C_PUBSECACTIVEREGNKPI.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE