VSFPLA_CN SAP (Version: Billing schedule) Table details
Dictionary Type: Table
Description: Version: Billing schedule
Description: Version: Billing schedule
Table field list including key, data, relationships and ABAP select examples
VSFPLA_CN is a standard SAP Table which is used to store Version: Billing schedule data and is available within R/3 SAP systems depending on the version and release level.
The VSFPLA_CN table consists of various fields, each holding specific information or linking keys about Version: Billing schedule data available in SAP. These include VSNMR (Number or description of a version), FPLNR (Billing plan number / invoicing plan number), FPTYP (Billing plan category), FPART (Billing/Invoicing Plan Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP VSFPLA_CN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | Assigned to domain | FPLNR | |||
FPTYP | Billing plan category | FPTYP_FP | CHAR | 1 | FPTYP | ||||
FPART | Billing/Invoicing Plan Type | FPART | CHAR | 2 | Assigned to domain | FPART | |||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
BEDAT | Start date for billing plan/invoice plan | BEDAT_FP | DATS | 8 | DATUM | ||||
ENDAT | End date billing plan/invoice plan | ENDAT_FP | DATS | 8 | DATUM | ||||
HORIZ | Rule for Determining Horizon in Billing/Invoicing Plan | HORIZ_FP | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
BEDAR | Rule for Origin of Start Date of Billing/Invoicing Plan | BEDAT_FPK | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
ENDAR | Rule for Origin of End Date for Billing/Invoicing Plan | ENDAT_FPK | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
PERIO | Rule for Origin of Next Billing/Invoice Date | PERIO_FP | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
FPLAE | Length of a standard period in the billing plan | FPLAE | NUMC | 3 | NUM3 | ||||
RFPLN | Standard Billing/Invoicing Plan Number | RFPLN_D | CHAR | 10 | Assigned to domain | FPLNR | |||
LODAT | Dates from | TADAT | DATS | 8 | DATUM | ||||
AUTTE | Billing/Invoice Creation in Advance | AUTTE | CHAR | 1 | XFELD | ||||
LODAR | Rule for Origin of Start Dates | LODAR | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
PERAF | Rule for Determination of a Deviating Billing/Invoice Date | PERAF_FP | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | FAKCA | CHAR | 2 | Assigned to domain | WFCID | |||
TNDAT | Dates to | TBDAT | DATS | 8 | DATUM | ||||
TNDAR | Rule for Origin of End Dates | TBDAR | CHAR | 2 | Assigned to domain | VDREG_VEDA | |||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
FPLTU | Item unlimited in value | FPLTU | NUMC | 6 | Assigned to domain | FPLTR | |||
AUST1 | Payment cards: Status regarding requirements | AUST1_CC | CHAR | 1 | AUST1_CC | ||||
AUST2 | Payment cards: Totals status - Call external system | AUST2_CC | CHAR | 1 | CCALL | ||||
AUST3 | Payment cards: Overall status - Responses from ext. system | AUST3_CC | CHAR | 1 | REACT_SD | ||||
AUST4 | Payment cards: Reserve | AUST4_CC | CHAR | 1 | CHAR1 | ||||
AUST5 | Payment cards: Authorization block | AUST5_CC | CHAR | 1 | XFELD | ||||
BASISWRT | Target value | BASISWRT | CURR | 15(2) | WERTV8 | ||||
PSPNR | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
AUTKOR | Automatic creation of correction dates in billing plan | AUTKOR | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table VSFPLA_CN using ABAP code
The following ABAP code Example will allow you to do a basic selection on VSFPLA_CN to SELECT all data from the tableDATA: WA_VSFPLA_CN TYPE VSFPLA_CN.
SELECT SINGLE *
FROM VSFPLA_CN
INTO CORRESPONDING FIELDS OF WA_VSFPLA_CN
WHERE...
How to access SAP table VSFPLA_CN
Within an ECC or HANA version of SAP you can also view further information about VSFPLA_CN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects