P_PL_SAFTOLDESTACQFORMRUN

CDS View

Run ID of the oldest Acquisition form

P_PL_SAFTOLDESTACQFORMRUN is a CDS View in S/4HANA. Run ID of the oldest Acquisition form. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PL_SAFTOldestAcqForm view_entity from CONSUMPTION Acquisition form with minimum run ID

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FixedAsset FixedAsset 1
KEY MasterFixedAsset MasterFixedAsset 1
KEY StatryRptRunID StatryRptRunID 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.

-- Run ID of the oldest Acquisition form
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PL_SAFTOLDESTACQFORMRUN (
    COMPANYCODE,
    FIXEDASSET,
    MASTERFIXEDASSET,
    STATRYRPTRUNID,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, MASTERFIXEDASSET, STATRYRPTRUNID)
);