FPLA

Transparent Table Application Table
42 Fields 8 CDS Views

Billing Plan

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

CDS Views using this table (8)

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_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