FPLA

Transparent Table Application Table
42 Fields 9 CDS Views

Billing Plan

FPLA is an SAP database table in S/4HANA. Billing Plan. It contains 42 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
Fclm_Mm_Invplan view from Invoice Plan
I_ComSDOpenBillingPlan view from BASIC Sales Order Item Open Billing Plans
I_PaymentPlan view from BASIC Payment Plan
I_PaymentPlanItem view inner BASIC Payment Plan Item
I_PPS_PurchaseOrderPaymentPlan view_entity from BASIC PPS Purchase Order Payment Plan Header
I_ReferenceBillingPlanVH view from BASIC Reference Billing Plan
P_BillingPlan view_entity from BASIC
P_Bpsddata view from BASIC
P_ComSDOpenBillingPlan view from BASIC

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fplnr FPLNR Bill. Plan No.
fptyp FPTYP_FP Category
bpcat SDBP_BPCAT BillingPlanUCat
fpart FPART BillingPlanType
sortl SORTL Search term
bedat BEDAT_FP Start date
endat ENDAT_FP End date
horiz HORIZ_FP Horizon
vbeln VBELN SD Document
bedar BEDAT_FPK OriginStartDate
endar ENDAT_FPK Origin End Date
perio PERIO_FP Next Bill. Date
fplae FPLAE LengthOfPeriod
rfpln RFPLN_D Bill. Plan. No.
lodat TADAT Dates from
autte AUTTE In Advance
lodar LODAR OriginStartDate
peraf PERAF_FP Dev. Bill. Date
fakca FAKCA Calendar ID
tndat TBDAT Dates to
tndar TBDAR Orig. End Dates
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CO_APLZL Counter
rsnum RSNUM Reservation
rspos RSPOS Item no.
ebeln EBELN Purchasing Doc.
fpltu FPLTU Unlim. item val.
aust1 AUST1_CC Requirement Sts
aust2 AUST2_CC Call Status
aust3 AUST3_CC Response
aust4 AUST4_CC Payment cards: Reserve
aust5 AUST5_CC Authoriz. Block
basiswrt BASISWRT Target value
waers WAERS Currency
pspnr PS_POSNR WBS Element
autkor AUTKOR Aut.corr. dates
status SDBP_ROOT_STATUS Status
final SDBP_FINAL_INDICATOR Final
db_key /BOBF/CONF_KEY NodeID
_dataaging DATA_TEMPERATURE Data Aging
ifrs15_relevance IFRS15_RELEVANCE IFRS 15 Relevant

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Billing Plan
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FPLA (
    MANDT,             -- Client [MANDT]
    FPLNR,             -- Bill. Plan No. [FPLNR]
    FPTYP,             -- Category [FPTYP_FP]
    BPCAT,             -- BillingPlanUCat [SDBP_BPCAT]
    FPART,             -- BillingPlanType [FPART]
    SORTL,             -- Search term [SORTL]
    BEDAT,             -- Start date [BEDAT_FP]
    ENDAT,             -- End date [ENDAT_FP]
    HORIZ,             -- Horizon [HORIZ_FP]
    VBELN,             -- SD Document [VBELN]
    BEDAR,             -- OriginStartDate [BEDAT_FPK]
    ENDAR,             -- Origin End Date [ENDAT_FPK]
    PERIO,             -- Next Bill. Date [PERIO_FP]
    FPLAE,             -- LengthOfPeriod [FPLAE]
    RFPLN,             -- Bill. Plan. No. [RFPLN_D]
    LODAT,             -- Dates from [TADAT]
    AUTTE,             -- In Advance [AUTTE]
    LODAR,             -- OriginStartDate [LODAR]
    PERAF,             -- Dev. Bill. Date [PERAF_FP]
    FAKCA,             -- Calendar ID [FAKCA]
    TNDAT,             -- Dates to [TBDAT]
    TNDAR,             -- Orig. End Dates [TBDAR]
    AUFPL,             -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,             -- Counter [CO_APLZL]
    RSNUM,             -- Reservation [RSNUM]
    RSPOS,             -- Item no. [RSPOS]
    EBELN,             -- Purchasing Doc. [EBELN]
    FPLTU,             -- Unlim. item val. [FPLTU]
    AUST1,             -- Requirement Sts [AUST1_CC]
    AUST2,             -- Call Status [AUST2_CC]
    AUST3,             -- Response [AUST3_CC]
    AUST4,             -- Payment cards: Reserve [AUST4_CC]
    AUST5,             -- Authoriz. Block [AUST5_CC]
    BASISWRT,          -- Target value [BASISWRT]
    WAERS,             -- Currency [WAERS]
    PSPNR,             -- WBS Element [PS_POSNR]
    AUTKOR,            -- Aut.corr. dates [AUTKOR]
    STATUS,            -- Status [SDBP_ROOT_STATUS]
    FINAL,             -- Final [SDBP_FINAL_INDICATOR]
    DB_KEY,            -- NodeID [/BOBF/CONF_KEY]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    IFRS15_RELEVANCE,  -- IFRS 15 Relevant [IFRS15_RELEVANCE]
    PRIMARY KEY (MANDT, FPLNR)
);

Learn More