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