SAP ABAP Table VVSCPOS (Bill Scheduling: Scheduling Item)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CD (Application Component) Collections/Disbursements
⤷ VVSC (Package) FS-CD: Scheduling
⤷ FS-CD (Application Component) Collections/Disbursements
⤷ VVSC (Package) FS-CD: Scheduling
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VVSCPOS | Table Relationship Diagram |
Short Description | Bill Scheduling: Scheduling Item |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | GPART | GPART_KK | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
3 | VTREF | VTREF_KK | VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
4 | POSNR | SCCOUNT_SC | SCCOUNT_SC | CHAR | 12 | 0 | Item ID | ||
5 | SCPOSNR | TIMST_VK | TIMST_VK | CHAR | 14 | 0 | Time Stamp (Date and Time) | ||
6 | BLTYP | BLTP1_SC | BLTP1_SC | CHAR | 2 | 0 | Payment Plan Item Category | * | |
7 | STATPOST | STATPOST_SC | XFELD | CHAR | 1 | 0 | Post Payment Plan Item w/o Posting Stat.? | ||
8 | ARCHI | ARCHI_SC | XFELD | CHAR | 1 | 0 | Payment item can be written to archive | ||
9 | XLOCK | XLOCK_SC | XFELD | CHAR | 1 | 0 | Indicator: Item with Document Lock | ||
10 | PSNGL | PSNGL_SC | XFELD | CHAR | 1 | 0 | Indicator: One-Time Payment | ||
11 | PMTFR | PMFTR_SC | DATUM | DATS | 8 | 0 | Valid-From Date for Payment Plan Item | ||
12 | PMTTO | PMTTO_SC | DATUM | DATS | 8 | 0 | Valid-to date for payment plan items | ||
13 | RISKFR | RISKFR_SC | DATUM | DATS | 8 | 0 | Valid-From Date for Payment Plan Item Risk | ||
14 | RISKTO | RISKTO_SC | DATUM | DATS | 8 | 0 | Valid-To Date for Risk for Payment Plan Item | ||
15 | PERFR | PERFD_SC | DATUM | DATS | 8 | 0 | Start of Next Payment Period | ||
16 | PMEND | PMEND_SC | DATUM | DATS | 8 | 0 | End early on | ||
17 | PMEND_TIME | PMEND_TIME_SC | UZEIT | TIMS | 6 | 0 | Payment Plan Item: Event for Early Ending | ||
18 | RENEW | RENEW_SC | XFELD | CHAR | 1 | 0 | Indicator: Renew Item | ||
19 | RNEWX | RNEWX_SC | NUMC3 | NUMC | 3 | 0 | Number of Automatically Renewed Items | ||
20 | RNEWD | RNEWD_SC | NUMC3 | NUMC | 3 | 0 | Number of current renewals | ||
21 | RENEW_EXEC | RENEW_EXEC_SC | CHAR1 | CHAR | 1 | 0 | Payment Plan: Payment Plan Item Renewed | ||
22 | CCODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
23 | OPCCODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
24 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
25 | OPGSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
26 | PRGRP | PRGRP_VK | PRGRP_VK | CHAR | 2 | 0 | Product Group | TKKVPRGRP | |
27 | SEGMENT | SEGMT_KK | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | * | |
28 | VSARL_VX | VSARL_VX | VSARL_VX | CHAR | 6 | 0 | Insurance Type | TLXXVAL | |
29 | INSTAXS | INSTAXS_VK | INSTAXS_VK | CHAR | 4 | 0 | Insurance Tax Schedule | TKKV007A | |
30 | TXPOS | TXPOS_KK | TXPOS_KK | NUMC | 4 | 0 | Tax Referemce (Tax Reporting) | ||
31 | AMOUNT_TOTAL | BETRW_SC | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
32 | AMOUNT_INST | AMOUNT_INST_SC | WRTV7 | CURR | 13 | 2 | Payment Plan Item: Installment for each Due Date | ||
33 | ATFRD | ATFRD_SC | DATUM | DATS | 8 | 0 | Valid-From Date for Amount Changes | ||
34 | ATFRD_TIME | ATFRD_TIME_SC | UZEIT | TIMS | 6 | 0 | Payment Plan Item: Event for Amount Change | ||
35 | AMOUNT_DIFF | BETRW_KK | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
36 | AMOUNT_TRANS | XBETRW_SC | WRTV7 | CURR | 13 | 2 | Current distrib.amount of payment plan item | ||
37 | ENDTYPE | ENDTYPE_SC | ENDTYPE_SC | CHAR | 1 | 0 | Payment Plans: End Type for a Payment Plan Item | ||
38 | AMOUNT_NEED | AMNEED_SC | WRTV7 | CURR | 13 | 2 | Total amount when canceling payment plan early | ||
39 | AMOUNT_END | AMOUNT_END_SC | WRTV7 | CURR | 13 | 2 | Difference Amount for Ending Payment Plan Item | ||
40 | CHARGE_NEED | CHNEED_SC | WRTV7 | CURR | 13 | 2 | Charges Amount When Ending Payment Plan Item | ||
41 | GLAET_AMT | BETRW_SC | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
42 | CURR | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
43 | PAYMENTFR | PAYMENTFR_SC | NUM03 | NUMC | 3 | 0 | Lower Limit for Customer-Initiated Payment (in Percent) | ||
44 | PAYMENTTO | PAYMENTTO_SC | NUM03 | NUMC | 3 | 0 | Upper Limit for Customer-Initiated Payment (in Percent) | ||
45 | CRDATE | CRDATE_SC | DATUM | DATS | 8 | 0 | Payment Plan Item Creation Date | ||
46 | CRTIME | CRTIME_SC | UZEIT | TIMS | 6 | 0 | Scheduling Item Created at | ||
47 | CRUSER | CRUSER_SC | USNAM | CHAR | 12 | 0 | Name of Person who Added Object | ||
48 | CHDATE | CHDATE_SC | DATUM | DATS | 8 | 0 | Date of Last Change of Scheduling Item | ||
49 | CHTIME | CHTIME_SC | UZEIT | TIMS | 6 | 0 | Time of Last Change of Payment Plan Item | ||
50 | CHUSER | CHUSER_SC | USNAM | CHAR | 12 | 0 | Payment Plan Item Last Changed by | ||
51 | POKEY | POKEY_VK | POKEY_VK | CHAR | 2 | 0 | Payment Option Key | * | |
52 | PKEY | PKEY_VK | PKEY_VK | CHAR | 2 | 0 | Payment Plan Key | * | |
53 | PKEYFD | PKEYFD_SC | DATUM | DATS | 8 | 0 | Valid-From Date for Payment Plan Key | ||
54 | HVORG | HVORG_KK | HVORG_KK | CHAR | 4 | 0 | Main Transaction for Line Item | TFKHVO | |
55 | TVORG | TVORG_KK | TVORG_KK | CHAR | 4 | 0 | Subtransaction for Document Item | TFKTVO | |
56 | OPHVORG | HVORG_KK | HVORG_KK | CHAR | 4 | 0 | Main Transaction for Line Item | TFKHVO | |
57 | OPTVORG | TVORG_KK | TVORG_KK | CHAR | 4 | 0 | Subtransaction for Document Item | TFKTVO | |
58 | S_HKONT | HKONT_KK | SAKNR | CHAR | 10 | 0 | General ledger account | * | |
59 | H_HKONT | HKONT_KK | SAKNR | CHAR | 10 | 0 | General ledger account | * | |
60 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
61 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
62 | KONTT | KONTT_KK | KONTT_KK | CHAR | 2 | 0 | Account Assignment Category | * | |
63 | KONTL | KONTL_KK | CHAR50 | CHAR | 50 | 0 | Acct assnmnt string for industry-specific account assngments | ||
64 | BLART | BLART_KK | BLART_KK | CHAR | 2 | 0 | Document Type | TFK003 | |
65 | VTRE2 | VTREF_KK | VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
66 | VTRE3 | VTREF_KK | VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
67 | XREVE | XREVE_SC | XFELD | CHAR | 1 | 0 | Document must be reversed | ||
68 | XDIST | XDIST_SC | XFELD | CHAR | 1 | 0 | Indicator: Manual Distribution of Amount in Item | ||
69 | BUGRD | BUGRD_VK | BUGRD_VK | NUMC | 3 | 0 | Posting Reason | * | |
70 | PNTYP | PNTYP_VK | PNTYP_VK | CHAR | 2 | 0 | Item Category | * | |
71 | XDERE | XDEREN_SC | XFELD | CHAR | 1 | 0 | Indicator: Debt Recognition | ||
72 | AMOUNT_DERE | BETRW_KK | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
73 | VGPART2 | GPART_KK | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
74 | VGPART3 | GPART_KK | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
75 | GSFNR | GSFNR_VK | GSFNR_VK | CHAR | 16 | 0 | Business Transaction Number | ||
76 | BELNR | BELNR_VK | BELNR_VK | CHAR | 6 | 0 | Transfer Document Number | ||
77 | PEROFF | PEROFF_SC | PEROFF_SC | DEC | 3 | 0 | Offset for Period Positioning | ||
78 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
79 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
80 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
81 | PYGRP | PYGRP_KK | CHAR10 | CHAR | 10 | 0 | Grouping field for automatic payments | ||
82 | PDTYP | PDTYP_KK | PDTYP_KK | CHAR | 1 | 0 | Category of Payment Specification | ||
83 | GRKEY | GRKEY_KK | CHAR3 | CHAR | 3 | 0 | Grouping Key for Displaying Open Items | ||
84 | XBEENDET | XBEENDET_SC | XFELD | CHAR | 1 | 0 | Indicator: Scheduling Item Finished, Deletes Pmend Amt-Need | ||
85 | CFSET | CFSET_SC | XFELD | CHAR | 1 | 0 | Indicator: Scheduling Item Processed in Cash Management | ||
86 | CFPPC | CFPPC_SC | XFELD | CHAR | 1 | 0 | Indicator: Payment Plan Change Processed in Cash Management | ||
87 | CFAC | CFAC_SC | XFELD | CHAR | 1 | 0 | Indicator: Amount Change Processed in Cash Management | ||
88 | CFPE | CFPE_SC | XFELD | CHAR | 1 | 0 | Indicator: End Processed in Cash Management | ||
89 | FDDATE | FDDATE_SC | DATUM | DATS | 8 | 0 | Date Used to Convert for Cash Management and Forecast | ||
90 | FDDATE_FROM | FDDATE_FROM_SC | DATUM | DATS | 8 | 0 | Date from Which Cash Management Was Updated | ||
91 | FDDATE_TO | FDDATE_TO_SC | DATUM | DATS | 8 | 0 | Date up to Which Cash Management Was Updated | ||
92 | SCFDGRP | FDGRP_KK | FDGRP | CHAR | 10 | 0 | Planning Group | * | |
93 | SCFDZTG | FDZTG_KK | NUM2 | NUMC | 2 | 0 | Additional Days for Cash Management | ||
94 | VOPBEL | OPBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Number of Contract Accts Rec. & Payable Doc. | * | |
95 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
96 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | T059Q | |
97 | STRKZ | STRKZ_KK | STRKZ_KK | CHAR | 2 | 0 | Tax Code for Other Taxes | TFK007F | |
98 | OPKONTT | KONTT_KK | KONTT_KK | CHAR | 2 | 0 | Account Assignment Category | * | |
99 | OPKONTL | KONTL_KK | CHAR50 | CHAR | 50 | 0 | Acct assnmnt string for industry-specific account assngments | ||
100 | STRNETTO | STRNETTO_SC | STRNETTO_SC | CHAR | 1 | 0 | Net Tax | ||
101 | KTOSL | KTOSL_KK | CHAR3 | CHAR | 3 | 0 | Transaction key for account determination | ||
102 | TXT | OPTXT_KK | TEXT50 | CHAR | 50 | 0 | Item text | ||
103 | ORIGIN | ORIGIN_DI | CHAR30 | CHAR | 30 | 0 | Source of Data | ||
104 | MPPLAN | MPPLAN_SC | CHAR1 | CHAR | 1 | 0 | Manual Payment Plan Linked with This Item | ||
105 | XEIBH_KO | XEIBH_KK | XFELD | CHAR | 1 | 0 | Create Separate Document in General Ledger | ||
106 | XEIPH_OPK | XEIPH_KK | XFELD | CHAR | 1 | 0 | Create Line Item in General Ledger | ||
107 | HZUON | HZUON_KK | ZUONR | CHAR | 18 | 0 | Assignment Number in G/L Document | ||
108 | SGTXT | SGTXT_KK | TEXT50 | CHAR | 50 | 0 | Item Text for G/L Document | ||
109 | XEIPH_OP | XEIPH_KK | XFELD | CHAR | 1 | 0 | Create Line Item in General Ledger | ||
110 | FINRE | FINRE_KK | VKONT_KK | CHAR | 12 | 0 | Contract Account of Final Recipient | * | |
111 | COINS_CODE | COINS_REPID | REPID_VK | CHAR | 10 | 0 | Coinsurance Key | * | |
112 | COINS_CAT | COINS_DOC_TYPE_PRCL | COINS_DOC_TYPE_PRCL_DM | CHAR | 1 | 0 | Category for Coinsurance-Relevant Document | ||
113 | VERSION | VERSION_SC | VERSION_SC | CHAR | 4 | 0 | Payment Plans: Version Number | ||
114 | .INCLUDE | 0 | 0 | Scheduling Structure for Posting of Single Documents | |||||
115 | EMGPA | EMGPA_KK | BU_PARTNER | CHAR | 10 | 0 | Alternative business partner for payments | BUT000 | |
116 | EMBVT | EMBVT_KK | CHAR4 | CHAR | 4 | 0 | Bank Details ID of Payee | ||
117 | EMADR | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
118 | EMCCID | CCID_KK | CHAR6 | CHAR | 6 | 0 | Payment Card ID for Payments | ||
119 | PYMET | PYMET_KK | PYMET_KK | CHAR | 1 | 0 | Payment Method | * | |
120 | PYBUK | PYBUK_KK | BUKRS | CHAR | 4 | 0 | Company Code for Automatic Payment Transactions | * | |
121 | FDGRP | FDGRP_KK | FDGRP | CHAR | 10 | 0 | Planning Group | T035 | |
122 | FDZTG | FDZTG_KK | NUM2 | NUMC | 2 | 0 | Additional Days for Cash Management | ||
123 | FAEDS | FAEDS_KK | DATUM | DATS | 8 | 0 | Due Date for Cash Discount | ||
124 | SKTPZ | SKTPZ_KK | PRZ23 | DEC | 5 | 3 | Cash discount rate | ||
125 | FAEDN | FAEDN_KK | DATUM | DATS | 8 | 0 | Due date for net payment | ||
126 | IKEY | IKEY_KK | IKEY_KK | CHAR | 2 | 0 | Interest Key | TFK056A | |
127 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
128 | STUDT | STUDT_KK | DATUM | DATS | 8 | 0 | Deferral to | ||
129 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
130 | DUN_REASON | DUN_LOCKREASON_KK | MANSP_KK | CHAR | 1 | 0 | Dunning Lock Reason | * | |
131 | DUN_REASON_DAYS | LOCK_DAYS_KK | LOCK_DAYS_KK | NUMC | 3 | 0 | Number Of Days An Object Remains Locked | ||
132 | PAY_REASON | SPZAH_KK | SPZAH_KK | CHAR | 1 | 0 | Lock Reason for Automatic Payment | * | |
133 | PAY_REASON_DAYS | LOCK_DAYS_KK | LOCK_DAYS_KK | NUMC | 3 | 0 | Number Of Days An Object Remains Locked | ||
134 | CLR_REASON | CLRLO_KK | SPPOS_KK | CHAR | 1 | 0 | Clearing Lock Reason | * | |
135 | CLR_REASON_DAYS | LOCK_DAYS_KK | LOCK_DAYS_KK | NUMC | 3 | 0 | Number Of Days An Object Remains Locked | ||
136 | INT_REASON | SPERZ_KK | SPERZ_KK | CHAR | 1 | 0 | Interest Lock Reason | * | |
137 | INT_REASON_DAYS | LOCK_DAYS_KK | LOCK_DAYS_KK | NUMC | 3 | 0 | Number Of Days An Object Remains Locked | ||
138 | REFCLAIM | REFCLAIM_VK | CHAR8 | CHAR | 8 | 0 | Reference to Payment in Claims Management System | ||
139 | WWERT | WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
140 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
141 | .INCLUDE | 0 | 0 | Include for FM Integration (OI) | |||||
142 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VVSCPOS | BLART | TFK003 | BLART | 1 | CN | |
2 | VVSCPOS | CURR | TCURC | WAERS | |||
3 | VVSCPOS | EMGPA | BUT000 | PARTNER | |||
4 | VVSCPOS | FDGRP | T035 | GRUPP | |||
5 | VVSCPOS | GSBER | TGSB | GSBER | C | CN | |
6 | VVSCPOS | HVORG | TFKHVO | HVORG | 1 | CN | |
7 | VVSCPOS | IKEY | TFK056A | IKEY | |||
8 | VVSCPOS | INSTAXS | TKKV007A | INSTAXS | KEY | 1 | CN |
9 | VVSCPOS | KOSTL | CSKS | KOSTL | |||
10 | VVSCPOS | MWSKZ | T007A | MWSKZ | 1 | CN | |
11 | VVSCPOS | OPGSBER | TGSB | GSBER | C | CN | |
12 | VVSCPOS | OPHVORG | TFKHVO | HVORG | 1 | CN | |
13 | VVSCPOS | OPTVORG | TFKTVO | TVORG | 1 | CN | |
14 | VVSCPOS | PRGRP | TKKVPRGRP | PRGRP | 1 | CN | |
15 | VVSCPOS | QSSKZ | T059Q | QSSKZ | |||
16 | VVSCPOS | STRKZ | TFK007F | STRKZ | |||
17 | VVSCPOS | TVORG | TFKTVO | TVORG | 1 | CN | |
18 | VVSCPOS | VSARL_VX | TLXXVAL | VSARL_VX | C | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |