SAP ABAP Table RECPDLIN (Document Overview: Invoices)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	RECPDLIN	Table Relationship Diagram
Short Description	Document Overview: Invoices

Delivery and Maintenance

Pool/cluster
Delivery Class
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	ALVBOX	☐	RECPALVBOX	XFELD	CHAR	1	0	ALV: checkbox column
2	ALVINFO	☐	RECPALVINFO		CHAR	3	0	ALV: info column (definition of line color)
3	PRINTABLE	☐	RECPPRINTABLE	XFELD	CHAR	1	0	Can the document be printed?
4	.INCLUDE	☐				0	0	Invoice Header
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
6	SRECHNGNR	☐	VVRECHNGNR	VVRECHNGNR	NUMC	10	0	Rent Invoice: Invoice Number
7	SRECHNGJAHR	☐	VVRECHNGJAHR	GJAHR	NUMC	4	0	Calendar Year of the Invoice Number
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
10	KUNNR_P	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
11	ADR_REF	☐	BP_ADR_REF	BP_ADR_REF	CHAR	10	0	Address ID	TP14
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
14	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
15	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
16	DINVFROM	☐	VVDINVFROM	DDAT	DATS	8	0	Start Date for Due Period of Open Items
17	DINVTO	☐	VVDINVTO	DDAT	DATS	8	0	End Date for Due Period of Open Items
18	CREDCH	☐	RECPCREDCH	XFELD	CHAR	1	0	Clear credit memo items?
19	INVALLOPENITEMS	☐	RECPINVALLOPENITEMS	XFELD	CHAR	1	0	Also print open items that have already been invoiced
20	INVCOLLECT	☐	RECPINVCOLLECT	RECPINVCOLLECT	CHAR	1	0	Grouping option: group invoices for each ...
21	INVPERIOD	☐	RECPINVPERIOD	RECPINVPERIOD	CHAR	1	0	Grouping option: divide up invoices for each ...
22	DRUCKDTM	☐	DRUCKDTM	DATS	DATS	8	0	Print date for letters in Real Estate Management
23	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
24	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
25	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
26	INVCOUNTCN	☐	RECPCOUNTCN		INT4	10	0	No. of contracts
27	ALTPAYER	☐	RECPALTPAYER	XFELD	CHAR	1	0	Does business partner act as alternative payer?
28	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
29	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
30	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
31	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
32	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
33	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
34	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
35	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
36	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
37	RQIDENT	☐	RQIDENT	CHAR10	CHAR	10	0	Spool number
38	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
39	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
40	TYPE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
41	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
42	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
43	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
44	SORT1	☐	BP_SORT1	CHAR20	CHAR	20	0	Sort Field 1
45	SORT2	☐	BP_SORT2	CHAR20	CHAR	20	0	Sort Field 2
46	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
47	VIP	☐	BP_VIP	PAVIP	CHAR	1	0	Business Partner: VIP Partner	*
48	XTITLE	☐	BP_XTITLE	TEXT50	CHAR	50	0	Text of Form of Address
49	XTIT_LE	☐	BP_XTIT_LE	TEXT50	CHAR	50	0	Salutation
50	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
51	PFACH	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
52	PSTL2	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
53	PFORT	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
54	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
55	PSTLZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
56	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
57	ORT02	☐	ORT01_GP	TEXT35	CHAR	35	0	City
58	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECPDLIN	ADR_REF	TP14	ADR_REF	REF	1	CN
2	RECPDLIN	BUKRS	T001	BUKRS	REF	1	CN
3	RECPDLIN	KUNNR_P	KNA1	KUNNR	REF	1	CN
4	RECPDLIN	PARTNR	BP000	PARTNR	REF	1	CN
5	RECPDLIN	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C