I_DFS_POSITIONNAMETP

CDS View
14 Fields 1 CDS Views

Transactional View of Position Name

I_DFS_POSITIONNAMETP is a CDS View in S/4HANA. Transactional View of Position Name. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_DFS_PositionNameTP view from CONSUMPTION

Fields (14)

KeyField CDS FieldsUsed in Views
KEY DfsPositionID DfsPositionID 1
KEY DfsPositionObjectType DfsPositionObjectType 1
KEY DfsPositionPlanVersion DfsPositionPlanVersion 1
KEY DfsPositionPlngStatus DfsPositionPlngStatus 1
KEY DfsPositionValdtyEndDate DfsPositionValdtyEndDate 1
KEY DfsPositionValdtyStartDate DfsPositionValdtyStartDate 1
KEY LanguageCode LanguageCode 1
DfsPositionDelimitDate DfsPositionDelimitDate 1
DfsPositionInfoType DfsPositionInfoType 1
DfsPositionName DfsPositionName 1
DfsPositionPlngStsCritlty DfsPositionPlngStsCritlty 1
DfsPositionShortName DfsPositionShortName 1
DfsPositionValdtyEndDateFoEd DfsPositionValdtyEndDateFoEd 1
DfsPositionValdtyStartDateFoEd DfsPositionValdtyStartDateFoEd 1

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.

-- Transactional View of Position Name
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_POSITIONNAMETP (
    DFSPOSITIONID,
    DFSPOSITIONOBJECTTYPE,
    DFSPOSITIONPLANVERSION,
    DFSPOSITIONPLNGSTATUS,
    DFSPOSITIONVALDTYENDDATE,
    DFSPOSITIONVALDTYSTARTDATE,
    LANGUAGECODE,
    DFSPOSITIONDELIMITDATE,
    DFSPOSITIONINFOTYPE,
    DFSPOSITIONNAME,
    DFSPOSITIONPLNGSTSCRITLTY,
    DFSPOSITIONSHORTNAME,
    DFSPOSITIONVALDTYENDDATEFOED,
    DFSPOSITIONVALDTYSTARTDATEFOED,
    PRIMARY KEY (DFSPOSITIONID, DFSPOSITIONOBJECTTYPE, DFSPOSITIONPLANVERSION, DFSPOSITIONPLNGSTATUS, DFSPOSITIONVALDTYENDDATE, DFSPOSITIONVALDTYSTARTDATE, LANGUAGECODE)
);

Learn More