C_PubSecOverdueFilersKPI

Overdue Filers Smart Business KPI | view: CPSOVERDUEFKPI | Extraction: Not supported | Component: Public Sector Contract Accounts Receivable and Payable
Tables used: DFKKCOHI, DFKKCOHINCORR, BUT000, BUT0IS, TFK001G, TFK070P, TFK070PT, TFK_INCORR, TFK_INCORRT, TFK001P, TFK001PT, T001, TKA02, FKKVK, FKKVKP, TB038A, TB038B, DPSOB, TB038
Column Name Description
CACorrespondenceType FK Correspondence Type
Taxpayer Taxpayer Number
TaxpayerAccount Taxpayer Account Number
CACorrespondence Correspondence key
Column Name Description
Column Name Description
Column Name Description
CorrespondenceIssueDate Date of Issue
CorrespondenceIssueTime Issue Time to the Second
InboundCorrespncDueDate Inbound Correspondence Due Date
CAStartDateOfBillingPeriod Lower Limit of Billing Period
CAEndDateOfBillingPeriod Upper Limit of the Billing Period
CADeferralDate Deferral to
Column Name Description
AlternativePeriodIsExisting Alternative Periods Exist (Inbound Correspondence) Show values
Column Name Description Domain name
TaxpayerAccountName Taxpayer Account Name TEXT35
TaxPayerName Taxpayer Name
NrOfPubSecOvrdInbCorrespncReq Number of Overdue Inbound Correspondence Requests
TaxpayerContract Taxpayer Contract Object Number VTREF_KK
TaxpayerContractName Taxpayer Contract Name PSOBTXT_PS
CACorrespondenceStatusName Name of Correspondence Status TEXT20
CAPeriodCode Key for Period Assignment PERSL_KK
CAPeriodCodeName Text for Period Key TXT50
CAInboundCorrespncCategory Inbound Correspondence Category
CAInboundCorrespncCategoryName Name of Inbound Correspondence Category TEXT40
IndustryKeyShortDescription Industry Name TEXT20
CompanyCode Company Code in Correspondence CORR_BUKRS
PubSecContractAuthorizationGrp Authorization Group BEGRU
Master Data Relations Join Conditions
Authorization Group
  • ?
  • Authorization Group
  • Authorization Group
  • Client
  • C_PUBSECOVERDUEFILERSKPI.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ
  • C_PUBSECOVERDUEFILERSKPI.PUBSECCONTRACTAUTHORIZATIONGRP == TFK_BEGRU.BEGRU
  • C_PUBSECOVERDUEFILERSKPI.CAAUTHORIZATIONGROUP == TFK_BEGRU.BEGRU
  • C_PUBSECOVERDUEFILERSKPI.MANDT == TFK_BEGRU.CLIENT
Correspondence Status
  • Correspondence Status
  • Client
  • C_PUBSECOVERDUEFILERSKPI.CACORRESPONDENCESTATUS == TFK070P.CORR_STATUS
  • C_PUBSECOVERDUEFILERSKPI.MANDT == TFK070P.MANDT
Correspondence type C_PUBSECOVERDUEFILERSKPI.CACORRESPONDENCETYPE == TFK070A.COTYP
Check table
  • ?
  • Client
  • Contract Account Category
  • C_PUBSECOVERDUEFILERSKPI.[column in domain "APPLK_KK"] == TFK002A.APPLK
  • C_PUBSECOVERDUEFILERSKPI.MANDT == TFK002A.MANDT
  • C_PUBSECOVERDUEFILERSKPI.CONTRACTACCOUNTCATEGORY == TFK002A.VKTYP
Authorization Group
  • ?
  • Authorization Group
  • Client
  • C_PUBSECOVERDUEFILERSKPI.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_PUBSECOVERDUEFILERSKPI.TAXPAYERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_PUBSECOVERDUEFILERSKPI.MANDT == TB037.CLIENT
Contract Object Types
  • Client
  • Taxpayer Contract Type
  • C_PUBSECOVERDUEFILERSKPI.MANDT == TPSOB001.CLIENT
  • C_PUBSECOVERDUEFILERSKPI.TAXPAYERCONTRACTTYPE == TPSOB001.PSOBTYP
Taxpayer Standard Industry
  • Taxpayer Standard Industry
  • ?
  • Client
  • C_PUBSECOVERDUEFILERSKPI.TAXPAYERSTANDARDINDUSTRY == TB038A.IND_SECTOR
  • C_PUBSECOVERDUEFILERSKPI.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE
  • C_PUBSECOVERDUEFILERSKPI.MANDT == TB038A.CLIENT