SAP ABAP Table FPLTVB (Reference Structure for XFPLT/YFPLT)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
⤷ VZ (Package) Application development R/3 RV central functions
⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
⤷ VZ (Package) Application development R/3 RV central functions
Basic Data
Table Category | INTTAB | Structure |
Structure | FPLTVB | Table Relationship Diagram |
Short Description | Reference Structure for XFPLT/YFPLT |
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 | Billing Plan: Dates | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | FPLNR | FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
4 | FPLTR | FPLTR | FPLTR | NUMC | 6 | 0 | Item for billing plan/invoice plan/payment cards | * | |
5 | FPTTP | FPTTP | FPTTP | CHAR | 2 | 0 | Date Category | TFPLT | |
6 | TETXT | TETXT_FP | TETXT | CHAR | 4 | 0 | Date description | TVTB | |
7 | FKDAT | BFDAT | DATUM | DATS | 8 | 0 | Settlement Date for Deadline | ||
8 | FPFIX | FPFIX | FPFIX | CHAR | 1 | 0 | ID for adopting billing/invoice date | ||
9 | FAREG | FAREG | FAREG | CHAR | 1 | 0 | Rule in billing plan/invoice plan | ||
10 | FPROZ | FPROZ | PRZ32 | DEC | 5 | 2 | Percentage of value to be billed | ||
11 | WAERS | WAERS_CP | WAERS | CUKY | 5 | 0 | Currency Key of Credit Control Area | TCURC | |
12 | KURFP | KURFP | KURRF | DEC | 9 | 5 | Exchange rate for date in billing plan | ||
13 | FAKWR | FAKWR | WERTV8 | CURR | 15 | 2 | Value to be billed/calc. on date in billing/invoice plan | ||
14 | FAKSP | FAKSP_FP | FAKSP | CHAR | 2 | 0 | Billing block for billing plan/invoice plan dates | TVFS | |
15 | FKARV | FKARA | FKART | CHAR | 4 | 0 | Proposed billing type for an order-related billing document | TVFK | |
16 | FKSAF | FKSAF | STATV | CHAR | 1 | 0 | Billing status for the billing plan/invoice plan date | ||
17 | PERIO | PERIO_FP | VDREG_VEDA | CHAR | 2 | 0 | Rule for determining the next billing/invoice date | TVRG | |
18 | FPLAE | FPLAE | NUM3 | NUMC | 3 | 0 | Length of a standard period in the billing plan | ||
19 | MLSTN | MLST_ZAEHL | NUM12 | NUMC | 12 | 0 | Number of milestone | ||
20 | MLBEZ | MILESTONE | MILESTONE | CHAR | 5 | 0 | Usage | T433 | |
21 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | * | |
22 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | KNA1 | |
23 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
24 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
25 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
26 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
27 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
28 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
29 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
30 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
31 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
32 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
33 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
34 | NFDAT | NFDAT | DATUM | DATS | 8 | 0 | Settlement date for deadline | ||
35 | TEMAN | TEMAN_1 | TEMAN | CHAR | 1 | 0 | Process as for manually entered date | ||
36 | FAKCA | FAKCA | WFCID | CHAR | 2 | 0 | Calendar for defining days relevant for billing/invoicing | TFACD | |
37 | AFDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
38 | NETWR | NETWR_AP | WERTV8 | CURR | 15 | 2 | Net value of the order item in document currency | ||
39 | NETPR | NETPR | WERTV6 | CURR | 11 | 2 | Net price | ||
40 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
41 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
42 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
43 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
44 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
45 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
46 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
47 | CMPRE | CMPRE | WERTV6 | CURR | 11 | 2 | Item credit price | ||
48 | SKFBP | SKFBT | WERT7 | CURR | 13 | 2 | Amount Eligible for Cash Discount in Document Currency | ||
49 | BONBA | BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
50 | PRSOK | PRSOK | XFELD | CHAR | 1 | 0 | Pricing is OK | ||
51 | TYPZM | TYPZM | TYPZM | CHAR | 1 | 0 | Means of payment for classifying payment card plan lines | ||
52 | CMPRE_FLT | CMPRE_FLT | FLTP | FLTP | 16 | 16 | Item credit price | ||
53 | UELNR | UELNR | FPLNR | CHAR | 10 | 0 | Higher-level payment card plan number for billing | FPLA | |
54 | UELTR | UELTR | FPLTR | NUMC | 6 | 0 | Higher-level item in billing plan | FPLT | |
55 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
56 | CCACT | CCACT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Payment Card Receivables | SKA1 | |
57 | KORTE | KORTE | KORTE | CHAR | 1 | 0 | Indicator for correction date in billing plan | ||
58 | OFKDAT | OFKDAT | DATUM | DATS | 8 | 0 | Baseline date for determining AFDAT | ||
59 | .INCLU--AP | 0 | 0 | Period of Performance | |||||
60 | PEROP_BEG | FM_PEROP_SD_LOW | DATUM | DATS | 8 | 0 | Period of Performance Start Date | ||
61 | PEROP_END | FM_PEROP_SD_HIGH | DATUM | DATS | 8 | 0 | Period of Performance End Date | ||
62 | .INCLUDE | 0 | 0 | Dynamic Part of Billing Plan Dates | |||||
63 | UPDKZ | UPDKZ_D | UPDKZ | CHAR | 1 | 0 | Update indicator | ||
64 | SELKZ | SELKZ_LIST | SELKZ | CHAR | 1 | 0 | Selection indicator for list screens | ||
65 | KZMEI | KZMEI | XFELD | CHAR | 1 | 0 | ID: Milestone assigned to date | ||
66 | TEBEZ | TEBEZ_FP | TEXT40 | CHAR | 40 | 0 | Date description | ||
67 | NETWRG | NETWRG | WERTV8 | CURR | 15 | 2 | Total net value of the header billing plan in doc. curr. | ||
68 | FKSAFK | FKSAFK | STATV | CHAR | 1 | 0 | Header status for date of billing plan/invoice plan | ||
69 | .INCLUDE | 0 | 0 | Payment cards: Database fields relevant to both SD and FI | |||||
70 | CCINS | CCINS | CCINS | CHAR | 4 | 0 | Payment cards: Card type | TVCIN | |
71 | CCNUM | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | * | |
72 | CCFOL | CCFOL | CHAR10 | CHAR | 10 | 0 | Payment cards: Payment card suffix | ||
73 | DATAB | DATAB_CC | DATUM | DATS | 8 | 0 | Payment cards: Valid from | ||
74 | DATBI | DATBI_CC | DATUM | DATS | 8 | 0 | Payment Cards: Valid To | ||
75 | CCNAME | CCNAME | TEXT40 | CHAR | 40 | 0 | Payment Cards: Name of Cardholder | ||
76 | CSOUR | CSOUR | CSOUR | CHAR | 1 | 0 | Payment cards: Entry mode | ||
77 | AUTWR | AUTWR | WERTV8 | CURR | 15 | 2 | Payment cards: Authorized amount | ||
78 | CCWAE | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
79 | SETTL | SETTL | XFELD | CHAR | 1 | 0 | Payment cards: Settlement carried out | ||
80 | AUNUM | AUNUM | CHAR10 | CHAR | 10 | 0 | Payment cards: Authorization number | ||
81 | AUTRA | AUTRA | CHAR15 | CHAR | 15 | 0 | Payment cards: Authoriz. reference code of clearing house | ||
82 | AUDAT | AUDAT_CC | DATUM | DATS | 8 | 0 | Payment cards: Authorization date | ||
83 | AUTIM | AUTIM | UZEIT | TIMS | 6 | 0 | Payment cards: Authorization time | ||
84 | MERCH | MERCH | MERCH | CHAR | 15 | 0 | Payment cards: Merchant ID at the clearing house | TCCM | |
85 | LOCID | LOCID_CC | LOCID_CC | CHAR | 10 | 0 | Payment cards: Point of receipt for the transaction | TCCL | |
86 | TRMID | TRMID | CHAR10 | CHAR | 10 | 0 | Payment cards: Terminal | ||
87 | CCBTC | CCBTC | CCBTC | CHAR | 10 | 0 | Payment cards: Settlement run | ||
88 | CCTYP | CCTYP | CCTYP | CHAR | 2 | 0 | Payment cards: Card category | TVCTY | |
89 | CCARD_GUID | CCARDEC_GUID | SYSUUID_C | CHAR | 32 | 0 | Reference to Encrypted Payment Card Data | ||
90 | .INCLUDE | 0 | 0 | Payment Cards: Transaction Data - SD Database Fields | |||||
91 | CCAUA | CCAUA | CCAUA | CHAR | 1 | 0 | Payment cards: Authorization type | ||
92 | CCALL | CCALL | CCALL | CHAR | 1 | 0 | Payment cards: Status when external system is called? | ||
93 | REACT | REACT_SD | REACT_SD | CHAR | 1 | 0 | Payment cards: Response to authorization checks | ||
94 | AUTWV | AUTWV | WERTV8 | CURR | 15 | 2 | Payment cards: Amount to be authorized | ||
95 | CCOLD | CCOLD | XFELD | CHAR | 1 | 0 | Payment cards: Authorization has expired | ||
96 | CCVAL | CCVAL | XFELD | CHAR | 1 | 0 | Payment cards: Amount changed | ||
97 | CCPRE | CCPRE | XFELD | CHAR | 1 | 0 | Payment cards: Preauthorization | ||
98 | UELTR_A | UELTR_A | FPLTR | NUMC | 6 | 0 | Higher-level authorization for billing plan | FPLT | |
99 | .INCLUDE | 0 | 0 | Payment Cards: Result of Authorization/Settlement | |||||
100 | RCAVR | RCAVR_CC | CHAR4 | CHAR | 4 | 0 | Payment Cards: Result of Address Check (Address Result) | TCCRC | |
101 | RCAVA | RCAVA_CC | CHAR4 | CHAR | 4 | 0 | Payment Cards: Result of Address Check (Address Approval) | TCCRC | |
102 | RCAVZ | RCAVZ_CC | CHAR4 | CHAR | 4 | 0 | Payment Cards: Result of Address Check (ZIP Code Result) | TCCRC | |
103 | RCRSP | RCRSP_CC | CHAR4 | CHAR | 4 | 0 | Payment cards: Result of card check (response code) | TCCRC | |
104 | RTEXT | RTEXT_CC | TXT40 | CHAR | 40 | 0 | Payment cards: Result text | ||
105 | .INCLUDE | 0 | 0 | Payment Cards: Fields for SET Processing | |||||
106 | VCARD | VCARD | XFELD | CHAR | 1 | 0 | Virtual card | ||
107 | RFCAUT | RFCDEST | RFCDEST | CHAR | 32 | 0 | Logical Destination (Specified in Function Call) | * | |
108 | FNAUT_SETINIT | FNAUT_SETINIT | FUNCNAME | CHAR | 30 | 0 | Payment Cards: Function for Initialization SET Authorization | * | |
109 | FNAUT_SETINFO | FNAUT_SETINFO | FUNCNAME | CHAR | 30 | 0 | Payment Cards: Function for Result of Authorization (SET) | * | |
110 | .INCLUDE | 0 | 0 | Card Verification Value | |||||
111 | CVVAL | CVVAL | CVVAL | CHAR | 6 | 0 | Card Verification Value | ||
112 | CVVCT | CVVCT | CVVCT | CHAR | 1 | 0 | Control Field for Card Verification Value | ||
113 | CVVST | CVVST | CVVST | CHAR | 1 | 0 | Usage Status for Card Verification Value | ||
114 | .INCLUDE | 0 | 0 | Response for Card Verification Value | |||||
115 | RCCVV | RCCVV_CC | CHAR4 | CHAR | 4 | 0 | Results Check for Card Verification Value | TCCRC |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FPLTVB | CCACT | SKA1 | SAKNR | 1 | CN | |
2 | FPLTVB | CCINS | TVCIN | CCINS | |||
3 | FPLTVB | CCTYP | TVCTY | CCTYP | REF | 1 | CN |
4 | FPLTVB | CCWAE | TCURC | WAERS | |||
5 | FPLTVB | FAKCA | TFACD | IDENT | |||
6 | FPLTVB | FAKSP | TVFS | FAKSP | REF | C | CN |
7 | FPLTVB | FKARV | TVFK | FKART | REF | C | CN |
8 | FPLTVB | FPTTP | TFPLT | FPTTP | REF | 1 | CN |
9 | FPLTVB | KUNRG | KNA1 | KUNNR | REF | C | CN |
10 | FPLTVB | LOCID | TCCL | LOCID | REF | C | CN |
11 | FPLTVB | MANDT | T000 | MANDT | KEY | 1 | CN |
12 | FPLTVB | MERCH | TCCM | MERCH | |||
13 | FPLTVB | MLBEZ | T433 | MLSTN | REF | C | CN |
14 | FPLTVB | PERIO | TVRG | REGEL | REF | C | CN |
15 | FPLTVB | RCAVA | TCCRC | RCODE | REF | 1 | CN |
16 | FPLTVB | RCAVR | TCCRC | RCODE | REF | 1 | CN |
17 | FPLTVB | RCAVZ | TCCRC | RCODE | REF | 1 | CN |
18 | FPLTVB | RCCVV | TCCRC | RCODE | |||
19 | FPLTVB | RCRSP | TCCRC | RCODE | REF | 1 | CN |
20 | FPLTVB | TETXT | TVTB | TETBE | REF | 1 | CN |
21 | FPLTVB | UELNR | FPLA | FPLNR | REF | 1 | CN |
22 | FPLTVB | UELTR | FPLT | FPLTR | REF | 1 | CN |
23 | FPLTVB | UELTR_A | FPLT | FPLTR | REF | 1 | C |
24 | FPLTVB | WAERS | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |