TFPLT

Transparent Table Customizing (protected)
18 Fields 2 CDS Views

Date Type for Billing Plan Type

TFPLT is an SAP database table in S/4HANA. Date Type for Billing Plan Type. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BillingPlanDateCategory view from BASIC Billing Plan Date Category
I_Bpsddatecategory view from BASIC Billing Plan Date Category

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fpart fpart BillingPlanType
KEY fpttp fpttp Date category
tetxt tetxt_fp Date Descript.
fpfix fpfix Fixed date
fareg fareg Billing Rule
faksp faksp_fp Billing block
fkarv fkara Ord-Rel.Bill.Ty
auttd auttd CreateDatesAut.
autte autte In Advance
perio perio_fp Next Bill. Date
fplae fplae LengthOfPeriod
ksteu knprs Pricing Type
typzm typzm Means of paym.
faksk faksp_fpk BBlock CDate
fkark fkara_fpk BillTypCorrDate
lifsp lifsp Delivery Block
bomdlvgrp bomdlvgrp Apply to BOMs

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.

-- Date Type for Billing Plan Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TFPLT (
    MANDT,      -- Client [mandt]
    FPART,      -- BillingPlanType [fpart]
    FPTTP,      -- Date category [fpttp]
    TETXT,      -- Date Descript. [tetxt_fp]
    FPFIX,      -- Fixed date [fpfix]
    FAREG,      -- Billing Rule [fareg]
    FAKSP,      -- Billing block [faksp_fp]
    FKARV,      -- Ord-Rel.Bill.Ty [fkara]
    AUTTD,      -- CreateDatesAut. [auttd]
    AUTTE,      -- In Advance [autte]
    PERIO,      -- Next Bill. Date [perio_fp]
    FPLAE,      -- LengthOfPeriod [fplae]
    KSTEU,      -- Pricing Type [knprs]
    TYPZM,      -- Means of paym. [typzm]
    FAKSK,      -- BBlock CDate [faksp_fpk]
    FKARK,      -- BillTypCorrDate [fkara_fpk]
    LIFSP,      -- Delivery Block [lifsp]
    BOMDLVGRP,  -- Apply to BOMs [bomdlvgrp]
    PRIMARY KEY (MANDT, FPART, FPTTP)
);

Learn More