PICPS

Transparent Table Application Table
14 Fields 1 CDS Views

Parts Interchangeability Item (SuS+MPN)

PICPS is an SAP database table in S/4HANA. Parts Interchangeability Item (SuS+MPN). It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
PPH_PICSupersessionGroup view_entity inner Supersession Materials with NetChange

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pickey pic_pickey PIC key
KEY picpos pic_picpos Item no.
KEY counter pic_counter Counter
matnr matnr Material
loekz pic_loekz Deletion indic.
seqnr pic_seqnr Sequence number
datfr pic_datfr Valid from date
inttype pic_inttype Intch. type
piccode pic_piccode Interch code
erdat pic_erdat Created on
ernam pic_ernam Created by
aedat pic_aedat Changed on
aenam pic_aenam Changed by

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.

-- Parts Interchangeability Item (SuS+MPN)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PICPS (
    MANDT,    -- Client [mandt]
    PICKEY,   -- PIC key [pic_pickey]
    PICPOS,   -- Item no. [pic_picpos]
    COUNTER,  -- Counter [pic_counter]
    MATNR,    -- Material [matnr]
    LOEKZ,    -- Deletion indic. [pic_loekz]
    SEQNR,    -- Sequence number [pic_seqnr]
    DATFR,    -- Valid from date [pic_datfr]
    INTTYPE,  -- Intch. type [pic_inttype]
    PICCODE,  -- Interch code [pic_piccode]
    ERDAT,    -- Created on [pic_erdat]
    ERNAM,    -- Created by [pic_ernam]
    AEDAT,    -- Changed on [pic_aedat]
    AENAM,    -- Changed by [pic_aenam]
    PRIMARY KEY (MANDT, PICKEY, PICPOS, COUNTER)
);

Learn More