SAP MCFPLT Table in S/4 HANA - Sales document: Billing plan dates ;
MCFPLT is a standard SAP Table which is used to store Sales document: Billing plan dates ; data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MCFPLT table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MCFPLT
MCFPLT table structure field list
Below is the full MCFPLT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10(0) | Assigned to domain | FPLNR | ||||
FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6(0) | Assigned to domain | FPLTR | ||||
FPTTP | Date category | FPTTP | CHAR | 2(0) | TFPLT | FPTTP | ||||
TETXT | Date Description | TETXT_FP | CHAR | 4(0) | TVTB | TETXT | ||||
FKDAT | Settlement date for deadline | BFDAT | DATS | 8(0) | DATUM | |||||
FPFIX | ID for adopting billing/invoice date | FPFIX | CHAR | 1(0) | FPFIX | |||||
FAREG | Rule in billing plan/invoice plan | FAREG | CHAR | 1(0) | FAREG | |||||
FPROZ | Percentage of value to be invoiced | FPROZ | DEC | 5(2) | PRZ32 | |||||
WAERS | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
KURFP | Exchange rate for date in billing plan | KURFP | DEC | 9(5) | EXCRT | KURRF | ||||
FAKWR | Value to be billed/calc. on date in billing/invoice plan | FAKWR | CURR | 15(2) | WERTV8 | |||||
FAKSP | Billing block for billing plan/invoice plan dates | FAKSP_FP | CHAR | 2(0) | TVFS | FAKSP | ||||
FKARV | Proposed billing type for an order-related billing document | FKARA | CHAR | 4(0) | TVFK | FKART | ||||
FKSAF | Billing status for the billing plan/invoice plan date | FKSAF | CHAR | 1(0) | FKSAF | |||||
PERIO | Rule for Origin of Next Billing/Invoice Date | PERIO_FP | CHAR | 2(0) | TVRG | VDREG_VEDA | ||||
FPLAE | Length of a standard period in the billing plan | FPLAE | NUMC | 3(0) | NUM3 | |||||
MLSTN | Milestone number | MLST_ZAEHL | NUMC | 12(0) | NUM12 | |||||
MLBEZ | Usage | MILESTONE | CHAR | 5(0) | T433 | MILESTONE | ||||
ZTERM | Terms of payment key | DZTERM | CHAR | 4(0) | Assigned to domain | ZTERM | ||||
KUNRG | Payer | KUNRG | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | |||
TAXK1 | Tax Classification 1 for Customer | TAXK1 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK2 | Tax Classification 2 for Customer | TAXK2 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK5 | Tax Classification 5 for Customer | TAXK5 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK6 | Tax Classification 6 for Customer | TAXK6 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK7 | Tax Classification 7 for Customer | TAXK7 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK8 | Tax Classification 8 for Customer | TAXK8 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
TAXK9 | Tax Classification 9 for Customer | TAXK9 | CHAR | 1(0) | Assigned to domain | TAXKD | ||||
VALTG | Additional Value Days | VALTG | NUMC | 2(0) | TAGE2 | |||||
VALDT | Fixed Value Date | VALDT | DATS | 8(0) | DATUM | |||||
NFDAT | Settlement date for deadline | NFDAT | DATS | 8(0) | DATUM | |||||
TEMAN | Process as for manually entered date | TEMAN_1 | CHAR | 1(0) | TEMAN | |||||
FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | FAKCA | CHAR | 2(0) | TFACD | WFCID | ||||
AFDAT | Billing Date | FKDAT | DATS | 8(0) | DATUM | |||||
NETWR | Net Value of the Order Item in Document Currency | NETWR_AP | CURR | 15(2) | WERTV8 | |||||
NETPR | Net Price | NETPR | CURR | 11(2) | WERTV6 | |||||
WAVWR | Cost in document currency | WAVWR | CURR | 13(2) | WERTV7 | |||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | |||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | |||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | |||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | |||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | |||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | |||||
CMPRE | Item credit price | CMPRE | CURR | 11(2) | WERTV6 | |||||
SKFBP | Amount Eligible for Cash Discount in Document Currency | SKFBT_CS | CURR | 13(2) | WERT7 | |||||
BONBA | Rebate basis 1 | BONBA | CURR | 13(2) | WERTV7 | |||||
PRSOK | Pricing is OK | PRSOK | CHAR | 1(0) | XFELD | |||||
TYPZM | Means of payment for classifying payment card plan lines | TYPZM | CHAR | 1(0) | TYPZM | |||||
CMPRE_FLT | Item Credit Price | CMPRE_FLT | FLTP | 16(16) | FLTP | |||||
UELNR | Higher-level payment card plan number for billing | UELNR | CHAR | 10(0) | FPLA | FPLNR | ||||
UELTR | Higher-level item in billing plan | UELTR | NUMC | 6(0) | FPLT | FPLTR | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | EXCRT | KURRF | ||||
CCACT | G/L Account Number for Payment Card Receivables | CCACT | CHAR | 10(0) | SKA1 | ALPHA | SAKNR | |||
KORTE | Indicator for correction date in billing plan | KORTE | CHAR | 1(0) | KORTE | |||||
OFKDAT | Baseline date for determining AFDAT | OFKDAT | DATS | 8(0) | DATUM | |||||
DESCR | Billing Plan Item Description | SDBP_ITEM_DESCR | CHAR | 255(0) | SDBP_DESCRIPTION | |||||
POSTPR | Reason for Postponement | SDBP_REASON_POSTPNMT | CHAR | 255(0) | SDBP_DESCRIPTION | |||||
REFDOC | SD Billing Plan Reference Document | SDBP_REFDOC | CHAR | 1(0) | SDBP_REFDOC | |||||
SET_BY_FINAL | Billing plan set to final | SDBP_SET_TO_FINAL_INDICATOR | CHAR | 1(0) | XFELD | |||||
ITEM_USAGE | Billing Plan Item Usage | SDBP_ITEM_USAGE | CHAR | 2(0) | SDBP_ITEM_USAGE | |||||
DB_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16(0) | /BOBF/CONF_KEY | |||||
PARENT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16(0) | /BOBF/CONF_KEY | |||||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8(0) | DATA_TEMPERATURE | |||||
.INCLU--AP | 0(0) | |||||||||
AD04FAREG | Rule for billing | AD04FAREG | CHAR | 1(0) | AD04FAREG | |||||
.INCLU--AP | 0(0) | |||||||||
PEROP_BEG | Period of Performance Start Date | FM_PEROP_SD_LOW | DATS | 8(0) | DATUM | |||||
PEROP_END | Period of Performance End Date | FM_PEROP_SD_HIGH | DATS | 8(0) | DATUM | |||||
FPART | Billing/Invoicing Plan Type | FPART | CHAR | 2(0) | Assigned to domain | FPART | ||||
BEDAT | Start date for billing plan/invoice plan | BEDAT_FP | DATS | 8(0) | DATUM | |||||
ENDAT | End date billing plan/invoice plan | ENDAT_FP | DATS | 8(0) | DATUM | |||||
LODAT | Dates from | TADAT | DATS | 8(0) | DATUM | |||||
TNDAT | Dates to | TBDAT | DATS | 8(0) | DATUM | |||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY |
Search for further information about these or an SAP related objects