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)
⤷ 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 |