SAP ABAP Table RECP_SF_DOC_A520 (Document: Invoice)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-CP (Application Component) Correspondence
     ⤷ RE_CP_SF (Package) RE: Mass Print (Correspondence with PDF-Based Forms)

Basic Data

Table Category	INTTAB	Structure
Structure	RECP_SF_DOC_A520	Table Relationship Diagram
Short Description	Document: Invoice

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	.INCLUDE	☐				0	0	Document Properties - General
2	.INCLUDE	☐				0	0	Document Properties: Business Object
3	BUSTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
4	BUSKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
5	XMBUSOBJ	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
8	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
9	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
10	.INCLUDE	☐				0	0	Document Properties: Recipient
11	OBJRELGUID	☐	REBPOBJRELGUID	RECAGUID	RAW	16	0	GUID: Business Partner Object Relationship
12	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
13	ROLE	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	TB003
14	ADDRTYPE	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	TB009
15	XPARTNER	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
16	PARTN_CAT	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
17	PARTN_GRP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
18	SEARCHTERM1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
19	SEARCHTERM2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
20	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
21	.INCLUDE	☐				0	0	Document Properties: Form and Output Properties
22	CPACT	☐	RECPCPACT	RECPCPACT	CHAR	4	0	Correspondence Activity	TIVCPCT
23	FMSEQNO	☐	RECPFMSEQNO	NUMC4	NUMC	4	0	Sequence No. of Entry in Correspondence Activity
24	RECIPGRP	☐	RECPRECIPGRP	CHAR2	CHAR	2	0	Recipient Group for Exactly One Document
25	RECIPCATE	☐	RECPRECIPCATE	RECPRECIPCATE	CHAR	1	0	Selection of Recipient in Corresp. Activity
26	RECIPROLE	☐	RECPRECIPROLE	BU_ROLE	CHAR	6	0	Role of Recipient	TB003
27	RECIPSUBROLE	☐	RECPRECIPSUBROLE	REBPSUBROLE	CHAR	4	0	Role Type of Recipient	TIVBPSUBROLE
28	RECIPFINDHIER	☐	RECPRECIPFINDHIER	RECABOOL	CHAR	1	0	Search for Recipients in Superior Objects
29	FNAME	☐	RECPFNAME	RECPFNAME	CHAR	15	0	Form	TIVCPFM
30	XFNAME	☐	RECPXFNAME	RECAXMDESCRIPTION	CHAR	30	0	Name of Form
31	FORMTYPE	☐	FPTOOLTYPE	FPTOOLTYPE	CHAR	1	0	Form Formatting Type
32	SFNAME	☐	RECPSFNAME	FPNAME	CHAR	30	0	Smart Form or PDF-Based Form
33	TDCOPIESFM	☐	RECPTDCOPIESFM	TDCOPIES	NUMC	3	0	Number of Copies
34	TDDEVICETYPE	☐	RECPTDDEVICETYPE	RECPTDDEVICETYPE	CHAR	1	0	Output Type
35	TDDEVICEICON	☐	RECPTDDEVICEICON	RECAICON	CHAR	137	0	Icon for Output Type
36	XMAILORFAXNO	☐	RECPXMAILORFAXNO	SO_STRI241	CHAR	241	0	E-mail Address or Fax Number
37	TDNEWID	☐	RECPTDNEWID	RECABOOL	CHAR	1	0	New Spool Request
38	TDCOVTITLE	☐	SYPRTXT	SYCHAR68K	CHAR	68	0	Spool Description
39	SUBTYPE	☐	RECPSFSUBTYPE	CHAR32	CHAR	32	0	Correspondence-Dep. Identification for Output Activity
40	.INCLUDE	☐				0	0	Document Properties: Language
41	LANGU	☐	RECPSFLANGU	SPRAS	LANG	1	0	Language for Document Creation	*
42	.INCLU-_SP	☐				0	0	Specific Document Data: Invoice
43	.INCLUDE	☐				0	0	RE Invoice Header
44	.INCLUDE	☐				0	0	RE Invoice Header
45	MANDT_SP	☐	MANDT	MANDT	CLNT	3	0	Client	*
46	INVGUID_SP	☐	RERAINVGUID	RECAGUID	RAW	16	0	GUID: Unique Internal Key for RE Invoice
47	.INCLUDE	☐				0	0	RE Invoice Header: Key Fields
48	BUKRS_SP	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
49	INVNO_SP	☐	RERAINVNO	RERAINVNO	NUMC	10	0	Invoice Number
50	FISC_YEAR_SP	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
51	.INCLUDE	☐				0	0	RE Invoice Header: Non-Key Fields
52	PROCESSGUID_SP	☐	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process	VICAPROCESSID
53	PARTNER_SP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
54	ADDRTYPE_SP	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
55	ROLE_SP	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
56	.INCLUDE	☐				0	0	Options That Are Saved in Invoice Header
57	ITEMSELIND_SP	☐	RERAINVITEMSELIND	RERAINVITEMSELIND	CHAR	1	0	Type of Selection of Invoice Items
58	DUEDATEFROM_SP	☐	RERADUEDATEFROM	RECADATEBEG	DATS	8	0	Start Date of Due Period of the Items
59	DUEDATETO_SP	☐	RERADUEDATETO	RECADATEEND	DATS	8	0	End Date of Due Period of the Items
60	INCLCLEAREDITEMS_SP	☐	RERAINVINCLCLEAREDITEMS	RECABOOL	CHAR	1	0	Also Consider Cleared Items?
61	CLEARCREDITITEMS_SP	☐	RERAINVCLEARCREDITITEMS	RECABOOL	CHAR	1	0	Also Consider Credit Memo Items?
62	ALLOPENITEMS_SP	☐	RERAINVALLOPENITEMS	RECABOOL	CHAR	1	0	Also Consider Items Already Invoiced?
63	COLLECTIND_SP	☐	RERAINVCOLLECTIND	RERAINVCOLLECTIND	CHAR	1	0	Grouping Option: Summarize Invoices
64	CUSTOMER_SP	☐	RERACUSTOMERNO	RERAPARTNERNO	CHAR	10	0	Customer Number
65	OBJNR_SP	☐	RERAINVOBJNRSINGLE	J_OBJNR	CHAR	22	0	Object Number of Only Contract of Invoice, Otherwise Blank	*
66	OBJCOUNT_SP	☐	RERAINVOBJCOUNT	INT4	INT4	10	0	Number of Contracts in This Invoice
67	ISCREDITMEMO_SP	☐	RERAINVISCREDITMEMO	RECABOOL	CHAR	1	0	Credit Memo?
68	ISMINORAMOUNT_SP	☐	RERAINVISMINORAMOUNT	RECABOOL	CHAR	1	0	Trivial Amount?
69	CURRENCY_SP	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
70	TOTALGROSSAMOUNT_SP	☐	RERAINVTOTALAMOUNT	RECACURR	CURR	15	2	Full Amount of Invoice
71	TOTALNETAMOUNT_SP	☐	RERAINVTOTALNETAMOUNT	RECACURR	CURR	15	2	Net Amount of Invoice
72	TOTALTAXAMOUNT_SP	☐	RERAINVTOTALTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount of Invoice
73	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
74	RERF_SP	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
75	DERF_SP	☐	DERF	DATUM	DATS	8	0	First Entered on
76	TERF_SP	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
77	REHER_SP	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
78	RBEAR_SP	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
79	DBEAR_SP	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
80	TBEAR_SP	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
81	RBHER_SP	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
82	CANCELED_SP	☐	RERAINVCANCELED	RECABOOL	CHAR	1	0	Invoice Reversed?
83	SFDOCGUID_SP	☐	RECPSFDOCGUID	RECAGUID	RAW	16	0	GUID for Document to be Output
84	PRINTEDON_SP	☐	RERAINVPRINTEDON	RECADATE	DATS	8	0	Invoice Last Printed On
85	PRINTEDBY_SP	☐	RERAINVPRINTEDBY	SYCHAR12	CHAR	12	0	Invoice Last Printed By
86	PROCESSID_SP	☐	RERAINVPROCESSID	RECAPROCESSID	CHAR	16	0	Invoicing Run ID
87	IDENTKEY_SP	☐	RERAINVIDENTKEYSINGLE	CHAR45	CHAR	45	0	External ID of Contract, for Example, 1000/123

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECP_SF_DOC_A520	ADDRTYPE	TB009	ADR_KIND	REF	C	CN
2	RECP_SF_DOC_A520	BUKRS	T001	BUKRS	REF	C	CN
3	RECP_SF_DOC_A520	COMM_TYPE	TSAC	COMM_TYPE	REF	C	CN
4	RECP_SF_DOC_A520	CPACT	TIVCPCT	CPACT	REF	C	CN
5	RECP_SF_DOC_A520	FNAME	TIVCPFM	FNAME	REF	C	CN
6	RECP_SF_DOC_A520	PARTNER	BUT000	PARTNER	REF	C	CN
7	RECP_SF_DOC_A520	RECIPROLE	TB003	ROLE	REF	C	CN
8	RECP_SF_DOC_A520	RECIPSUBROLE	TIVBPSUBROLE	SUBROLE	REF	C	CN
9	RECP_SF_DOC_A520	ROLE	TB003	ROLE	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	500