I_PubSecOverdueInbCorrespncReq

Overdue Inbound Correspondence Requests | view: IPSOVERDUEINBCR | TRAN | Extraction: Not supported | Component: Public Sector Contract Accounts Receivable and Payable

Tables used: DFKKCOHI, DFKKCOHINCORR, BUT000, TFK001G, T001, TKA02, FKKVK, FKKVKP, DPSOB

🔑 Keys (4)
💰 Amounts (1)
∑ Quantities
📅 Dates (9)
☰ Categorical (4)
Other (6)
🔗 Relations (7)

Column Name	Description
CACorrespondenceType FK	Correspondence Type
TaxpayerAccount	Taxpayer Account Number
Taxpayer	Taxpayer Number
CACorrespondence	Correspondence key

Column Name	Description
💲 Currency Key (Currency):
CAAmountInLocalCurrency	Amount In Local Currency With +/- Signs

Column Name	Description

Column Name	Description
CreationDate	Creation Date
CorrespondencePrintDate	Print Date
CorrespondenceIssueDate	Date of Issue
CorrespondenceIssueTime	Issue Time to the Second
InboundCorrespncDueDate	Inbound Correspondence Due Date
InboundCorrespncReceivedDate	Date Inbound Correspondence Received
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
CAInbCorrespncClearingRsn	Clearing Reason for Inbound Correspondence Request	Show values
CAInbCorrespncCnsldtnStatus	Consolidation Status	Show values
ReminderIsSent	Send Reminder	Show values

Column Name	Description	Domain name
TaxpayerContract	Taxpayer Contract Object Number	VTREF_KK
CompanyCode	Company Code in Correspondence	CORR_BUKRS
CAPeriodCode	Key for Period Assignment	PERSL_KK
CAInboundCorrespncCategory	Inbound Correspondence Category
CAInbCorrespncLeadingObject	Leading Object (Inbound Correspondence)	VTREF_KK
PubSecContractAuthorizationGrp	Authorization Group	BEGRU

Master Data Relations	Join Conditions
Authorization Group Authorization Group Authorization Group Client ?	`I_PUBSECOVERDUEINBCORRESPNCREQ.PUBSECCONTRACTAUTHORIZATIONGRP == TFK_BEGRU.BEGRU` `I_PUBSECOVERDUEINBCORRESPNCREQ.CAAUTHORIZATIONGROUP == TFK_BEGRU.BEGRU` `I_PUBSECOVERDUEINBCORRESPNCREQ.MANDT == TFK_BEGRU.CLIENT` `I_PUBSECOVERDUEINBCORRESPNCREQ.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ`
Correspondence Status Client Correspondence Status	`I_PUBSECOVERDUEINBCORRESPNCREQ.MANDT == TFK070P.MANDT` `I_PUBSECOVERDUEINBCORRESPNCREQ.CACORRESPONDENCESTATUS == TFK070P.CORR_STATUS`
Correspondence type	`I_PUBSECOVERDUEINBCORRESPNCREQ.CACORRESPONDENCETYPE == TFK070A.COTYP`
Check table Client Contract Account Category ?	`I_PUBSECOVERDUEINBCORRESPNCREQ.MANDT == TFK002A.MANDT` `I_PUBSECOVERDUEINBCORRESPNCREQ.CONTRACTACCOUNTCATEGORY == TFK002A.VKTYP` `I_PUBSECOVERDUEINBCORRESPNCREQ.[column in domain "APPLK_KK"] == TFK002A.APPLK`
Currency Client Currency Key	`I_PUBSECOVERDUEINBCORRESPNCREQ.MANDT == TCURC.MANDT` `I_PUBSECOVERDUEINBCORRESPNCREQ.CURRENCY == TCURC.WAERS`
Authorization Group Client ? Authorization Group	`I_PUBSECOVERDUEINBCORRESPNCREQ.MANDT == TB037.CLIENT` `I_PUBSECOVERDUEINBCORRESPNCREQ.[column in domain "BU_AUOBJ"] == TB037.AUOBJ` `I_PUBSECOVERDUEINBCORRESPNCREQ.TAXPAYERAUTHORIZATIONGROUP == TB037.AUGRP`
Contract Object Types Client Taxpayer Contract Type	`I_PUBSECOVERDUEINBCORRESPNCREQ.MANDT == TPSOB001.CLIENT` `I_PUBSECOVERDUEINBCORRESPNCREQ.TAXPAYERCONTRACTTYPE == TPSOB001.PSOBTYP`