FIPLC_SA_DEFKEY

Transparent Table Customizing Table
10 Fields 1 CDS Views

PL SAF-T Asset Definition Keys

FIPLC_SA_DEFKEY is an SAP database table in S/4HANA. PL SAF-T Asset Definition Keys. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PL_SAFTAssetDefinitionKey view_entity from BASIC PL SAFT Asset Definition Key

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY comp_code FIPL_SA_COMP_CODE Company Code
KEY def_key FIPL_SA_DEF_KEY Asset Definition Key
KEY def_key_field FIPL_SA_DEF_KEY_FIELD Def. Key Field
KEY def_key_seq_nmbr FIPL_SA_DEF_KEY_SEQ_NMBR Sequential Number
KEY validity_end_date ENDDA End Date
validity_start_date BEGDA Start Date
def_key_offset FIPL_SA_DEF_KEY_OFFSET Offset
def_key_length FIPL_SA_DEF_KEY_LENGTH Length
def_key_content FIPL_SA_DEF_KEY_CONTENT AssetDKContent

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.

-- PL SAF-T Asset Definition Keys
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIPLC_SA_DEFKEY (
    CLIENT,               -- Client [MANDT]
    COMP_CODE,            -- Company Code [FIPL_SA_COMP_CODE]
    DEF_KEY,              -- Asset Definition Key [FIPL_SA_DEF_KEY]
    DEF_KEY_FIELD,        -- Def. Key Field [FIPL_SA_DEF_KEY_FIELD]
    DEF_KEY_SEQ_NMBR,     -- Sequential Number [FIPL_SA_DEF_KEY_SEQ_NMBR]
    VALIDITY_END_DATE,    -- End Date [ENDDA]
    VALIDITY_START_DATE,  -- Start Date [BEGDA]
    DEF_KEY_OFFSET,       -- Offset [FIPL_SA_DEF_KEY_OFFSET]
    DEF_KEY_LENGTH,       -- Length [FIPL_SA_DEF_KEY_LENGTH]
    DEF_KEY_CONTENT,      -- AssetDKContent [FIPL_SA_DEF_KEY_CONTENT]
    PRIMARY KEY (CLIENT, COMP_CODE, DEF_KEY, DEF_KEY_FIELD, DEF_KEY_SEQ_NMBR, VALIDITY_END_DATE)
);

Learn More