TFPLA

Transparent Table Customizing (protected)
23 Fields 1 CDS Views

Billing Plan Type

TFPLA is an SAP database table in S/4HANA. Billing Plan Type. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BillingPlanType view_entity from BASIC Billing Plan Type

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fpart fpart BillingPlanType
fptyp fptyp_fp Category
bpcat sdbp_bpcat BillingPlanUCat
bedar bedat_fpk OriginStartDate
endar endat_fpk Origin End Date
horiz horiz_fp Horizon
auttd auttd CreateDatesAut.
autte autte In Advance
perio perio_fp Next Bill. Date
fplae fplae LengthOfPeriod
fareg fareg Billing Rule
uevor uevor_fp FCode-OvervScrn
rfpln rfpln_d Bill. Plan. No.
fakca fakca Calendar ID
vfptt vfptt Def. Date Cat.
lodar lodar OriginStartDate
peraf peraf_fp Dev. Bill. Date
tbdar tbdar Orig. End Dates
anztm anztm Days in Month
anztj anztj No. Days in Year
autkor autkor Aut.corr. dates
dp_rlvt dp_rlvt Dwn Payt Rlvnce

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 Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TFPLA (
    MANDT,    -- Client [mandt]
    FPART,    -- BillingPlanType [fpart]
    FPTYP,    -- Category [fptyp_fp]
    BPCAT,    -- BillingPlanUCat [sdbp_bpcat]
    BEDAR,    -- OriginStartDate [bedat_fpk]
    ENDAR,    -- Origin End Date [endat_fpk]
    HORIZ,    -- Horizon [horiz_fp]
    AUTTD,    -- CreateDatesAut. [auttd]
    AUTTE,    -- In Advance [autte]
    PERIO,    -- Next Bill. Date [perio_fp]
    FPLAE,    -- LengthOfPeriod [fplae]
    FAREG,    -- Billing Rule [fareg]
    UEVOR,    -- FCode-OvervScrn [uevor_fp]
    RFPLN,    -- Bill. Plan. No. [rfpln_d]
    FAKCA,    -- Calendar ID [fakca]
    VFPTT,    -- Def. Date Cat. [vfptt]
    LODAR,    -- OriginStartDate [lodar]
    PERAF,    -- Dev. Bill. Date [peraf_fp]
    TBDAR,    -- Orig. End Dates [tbdar]
    ANZTM,    -- Days in Month [anztm]
    ANZTJ,    -- No. Days in Year [anztj]
    AUTKOR,   -- Aut.corr. dates [autkor]
    DP_RLVT,  -- Dwn Payt Rlvnce [dp_rlvt]
    PRIMARY KEY (MANDT, FPART)
);

Learn More