SAP ABAP Table DFMCAILOT (PSCD: Approval List Installment Plans)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-PS-CA (Application Component) Public Sector Contract Accounting
     ⤷ FMCAD (Package) PSCD: Basics & Documents

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DFMCAILOT	Table Relationship Diagram
Short Description	PSCD: Approval List Installment Plans

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Keys of Header Fields of Installment Plan
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	RPNUM	☑	RPBEL_KK	OPBEL_KK	CHAR	12	0	Installment plan number in Contract A/R & A/P	*
4	.INCLUDE	☐				0	0	Header Fields of Installment Plan without Keys
5	RPRCI	☐	RPRCI_KK	RPRCI_KK	CHAR	1	0	Index: Use installment plan when printing payment form
6	RPRDA	☐	RPRDA_KK	RPRCA_KK	NUMC	1	0	Print Type for Letters and Payment Forms
7	RPCAT	☐	RPCAT_KK	RPCAT_KK	CHAR	2	0	Installment plan category	*
8	DEADT	☐	DEADT_KK	DATUM	DATS	8	0	Deactivation Date Of Installment Plan
9	DEMAN	☐	DEMAN_KK	DEMAN_KK	CHAR	1	0	Instalment plan was manually deactivated
10	DEOFF	☐	DEOFF_KK	WRTV7	CURR	13	2	Open amount at time of deactivation
11	WAERS	☐	WAERS_KK	WAERS	CUKY	5	0	Currency Key	*
12	DEAGD	☐	DEAGD_KK	DEAGD_KK	CHAR	2	0	Reason for deactivation	*
13	STTDT	☐	STARDAT_KK	DATUM	DATS	8	0	Start date of installment plan
14	ENDDT	☐	ENDEDAT_KK	DATS	DATS	8	0	Installment plan end date
15	NINST	☐	NINST_KK	ANZRATE_KK	NUMC	3	0	Number of Installments
16	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
17	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	*
18	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
19	DRCDT	☐	DRCDT_KK	DATUM	DATS	8	0	Print Date of the Last Run for Payment Form
20	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
21	DZINS	☐	DZINS_KK	DZINS_KK	CHAR	1	0	Calculate Interest from Original Items
22	GZVER	☐	GZVER_KK	CHAR1	CHAR	1	0	Distribute Interest/Charges to all Installments
23	FAEIN	☐	FAEIN_KK	FAEIN_KK	CHAR	1	0	Interest Document Due Date
24	DPUDT	☐	DPUDT_KK	DATUM	DATS	8	0	Entry Day Of Installment Plan Deactivation
25	DPUTM	☐	DPUTM_KK	UZEIT	TIMS	6	0	Entry Time Of Installment Plan Deactivation
26	C4EYE	☐	C4EYE_KK	C4EYE_KK	CHAR	2	0	Check Reason for Workflows Acc. to Dual Control Principle	*
27	C4EYP	☐	C4EYP_KK	C4EYP_KK	CHAR	1	0	Editing Process To Be Confirmed
28	SUBAP	☐	SUBAP_KK	SUBAP_KK	CHAR	1	0	Subapplication in Contract Accounts Receivable and Payable
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0
31	.INCLUDE	☐				0	0
32	.INCLUDE	☐				0	0	Industry Add-On Public Sector: Installment Plans
33	.INCLUDE	☐				0	0
34	OPBEL	☐	URBEL_KK	OPBEL_KK	CHAR	12	0	Document Number of Receivables Document	*
35	BETRO	☐	BETRO_IP_KK	WRTV7	CURR	13	2	Open Amount on Creation of Installment Plan
36	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
37	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
38	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
39	CHANGENR	☐	CDCHANGENR	CDCHANGENR	CHAR	10	0	Document change number
40	USERNAME	☐	CDUSERNAME	CHAR12	CHAR	12	0	User name of the person responsible in change document
41	UDATE	☐	CDDATUM	DATUM	DATS	8	0	Creation date of the change document
42	UTIME	☐	CDUZEIT	UZEIT	TIMS	6	0	Time changed
43	.INCLUDE	☐				0	0	CFC: Status include for application tables
44	STATE	☐	CFC_STATE	CFC_STATE	CHAR	2	0	CFC: Status of an application table entry	CFC_ITEM_STATE
45	LOCK_USER	☐	CFC_UNAME	XUBNAME	CHAR	12	0	Name of the person to last change the status of the object	*
46	LOCK_LIMIT	☐	CFC_LOCK_LIMIT	SYDATS	DATS	8	0	CFC: Lock period of a lock entry
47	WORKSTATE	☐	CFC_WORKSTATE	CFC_WORKSTATE	CHAR	2	0	Last processing status of a clarification case	CFC_IT_WORKSTATE
48	RESUBMIT_DATE	☐	CFC_RESUBMIT_DATE	SYDATS	DATS	8	0	Date on which Resubmission Occurs
49	WF_COUNT	☐	CFC_WORKFLOW_COUNTER	INT1	INT1	3	0	Number of active workflows with this clarification case
50	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DFMCAILOT	STATE	CFC_ITEM_STATE	STATE	REF	1	CN
2	DFMCAILOT	WORKSTATE	CFC_IT_WORKSTATE	WORKSTATE

History

Last changed by/on	SAP	20130529
SAP Release Created in