1. Home
  2. Resources
  3. SAP Tables
  4. BAPISDBPLD - BAPI Structure of FPLT with English Field Names

SAP Table BAPISDBPLD

BAPI Structure of FPLT with English Field Names

BAPISDBPLD (BAPI Structure of FPLT with English Field Names) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPISDBPLD to other SAP tables.

BAPISDBPLD table fields

Field Data element Checktable Datatype Length Decimals
OPERATION Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
SD_DOC Sales and Distribution Document Number VBELN CHAR 10 0
ITM_NUMBER Item number of the SD document POSNR NUMC 6 0
BILL_PLAN Billing plan number / invoicing plan number FPLNR CHAR 10 0
BILL_PLANI Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
DATETYPE Date category FPTTP CHAR 2 0
DATEDESCRI Date description TETXT_FP CHAR 4 0
SETTLEDATE Settlement date for deadline BFDAT DATS 8 0
IDADOPTBIL ID for adopting billing/invoice date FPFIX CHAR 1 0
NULL Assignment to milestones not possible
0 Fixed date, date not copied from milestone
1 Planned/actual date from milestone
2 Planned/actual date from milestone if before billing date
3 Planned/actual date from milestone if after billing date
RULEBILLPL Rule in billing plan/invoice plan FAREG CHAR 1 0
1 Milestone billing on a percentage basis
2 Milestone billing on a value basis
3 Closing invoice in milestone billing
4 Down payment in milestone billing on percentage basis
5 Down payment in milestone billing on a value basis
6 Periodic billing (rent)
INVOICEPER Percentage of value to be invoiced FPROZ DEC 5 2
CURRENCKEY Currency Key of Credit Control Area WAERS_CP CUKY 5 0
CURRENCISO ISO code currency WAERS_ISO CHAR 3 0
EXCHANRATE Direct quotation exchange rate for deadline in billing plan KURFP_P DEC 9 5
VALONDATE Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
BILLBLOCK Billing block for billing plan/invoice plan dates FAKSP_FP CHAR 2 0
ORDBILLTYP Proposed billing type for an order-related billing document FKARA CHAR 4 0
STATBILLPL Billing status for the billing plan/invoice plan date FKSAF CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RULEORINEX Rule for Origin of Next Billing/Invoice Date PERIO_FP CHAR 2 0
LENSTANPER Length of a standard period in the billing plan FPLAE NUMC 3 0
MILESTONNO Milestone number MLST_ZAEHL NUMC 12 0
MILESTONE Usage MILESTONE CHAR 5 0
PMNTTRMS Terms of Payment Key DZTERM CHAR 4 0
PAYER Payer KUNRG CHAR 10 0
TAX_CLASS1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAX_CLASS2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAX_CLASS3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAX_CLASS4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAX_CLASS5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAX_CLASS6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAX_CLASS7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAX_CLASS8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAX_CLASS9 Tax classification 9 for customer TAXK9 CHAR 1 0
ADD_VAL_DY Additional value days VALTG NUMC 2 0
FIX_VAL_DY Fixed value date VALDT DATS 8 0
SETTLEDAT Settlement date for deadline NFDAT DATS 8 0
PROCASMANU Process as for manually entered date TEMAN_1 CHAR 1 0
NULL no manual schedule
X manual schedule
Y Process as for manually entered date
CALDEFDAYS Calendar for Defining Days Relevant to Billing/Invoicing FAKCA CHAR 2 0
BILL_DATE Billing date for billing index and printout FKDAT DATS 8 0
NET_VALUE Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
NET_PRICE Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
COST_DOC_C Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
SUBTOT_PP1 Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
SUBTOT_PP2 Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
SUBTOT_PP3 Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
SUBTOT_PP4 Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
SUBTOT_PP5 Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
SUBTOT_PP6 Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
CREDPRICIT Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
AMOUNTELIG Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
REBATEBAS Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
CURRENCY SD Document Currency WAERK CUKY 5 0
CURREN_ISO ISO code currency WAERS_ISO CHAR 3 0
PRICE_OK Pricing is OK PRSOK CHAR 1 0
X Yes
NULL No
MEANSOFPAY Means of payment for classifying payment card plan lines TYPZM CHAR 1 0
0 Payment card
CREDITPRED Item credit price CMPRE_FLT FLTP 16 16
HILEVPAYNO Higher-level payment card plan number for billing UELNR CHAR 10 0
HILEVITBIL Higher-level item in billing plan UELTR NUMC 6 0
EXCHRATEFI Directly quoted exchange rate for FI postings KURRF_P DEC 9 5
ACCOUNTNO G/L Account Number for Payment Card Receivables CCACT CHAR 10 0
INDICORDAT Indicator for correction date in billing plan KORTE CHAR 1 0
NULL No correction date
A Correction date with inverted +/-
ORIGBILDAT Baseline date for determining AFDAT OFKDAT DATS 8 0
EXCHANRATE_V Indirect quotation exchange rate for deadline in billing pla KURFP_V DEC 9 5
EXCHRATEFI_V Indirectly quoted exchange rate for FI postings KURRF_V DEC 9 5