PPS_PURUPDI_D

Transparent Table Application Table
49 Fields 1 CDS Views

Draft table for entity R_PPS_PURGDOCUPDTREQUESTITEMTP

PPS_PURUPDI_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURGDOCUPDTREQUESTITEMTP. It contains 49 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPSPurgDocUpdtReqItemDraft view_entity from BASIC Purchasing Document Upd Req Itm - Draft

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ppspurgdocupdtrequest PPS_E_REQUEST_NO Request Number
KEY ppspurgdocupdtrequestitem PPS_E_REQUEST_ITEM_NO Item Number
ppspurgdocupdtreqitemstatus PPS_E_UPDREQ_ITM_STATUS Item Status
ppspurgdocupdtreqitmstscritlty abap.int1
ppsitemallocatedamount PPS_E_ALLOCATED_AMOUNT Allocated Amount
ppspurgdocnumber PPS_E_PURG_DOC_NUMBER Purchasing Document
purchasingdocumentitem PPS_E_PURG_DOC_ITEM Document Item
purchasingdocumentversion REVNO Version
ppsrequestedamount PPS_E_REQUESTED_AMOUNT Requested Amount
ppsunfundedamount PPS_E_UNFUNDED_AMOUNT Unfunded Amount
documentcurrency WAERS Currency
creationdatetime VDM_CREATIONDATETIME Created On
createdbyuser VDM_CREATEDBYUSERID Created By
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
applicationjobdescription BALNREXT External ID
applicationloghandle PPS_E_NOVATION_LOG_ID Log ID
purchasingdocumentitemcategory PSTYP Item Category
producttypecode PRODUCT_TYPE Product Type Group
material MATNR Material
netamount BWERT Net Value
accountassignmentcategory KNTTP Acct Assgmt Cat
ppssmartdocumentnumber PPS_E_SMT_DOC_NUMBER Smart Document Number
purgconfigurableitemnumber EXLIN Hierarchy Number
purchasingdocumenttype ESART Document Type
ppsfundedamount PPS_E_FUNDED_AMOUNT Funded Amount
ppsconfigurablelineitemnumber PPS_E_CONFIG_ITEM_NO Configurable Line Item Number
plant EWERK Plant
companycode BUKRS Company Code
uict_hideearmarkedfundsfacet BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
ppsisdeletehidden BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
semanticobject abap.char
uict_hidemessagebutton BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
purchasingdocumentcategory PPS_E_NOVATION_DOC_CAT Purchasing Document Category
ppsnovationrequestitemstatus PPS_E_NOVATION_ITM_STATUS Novation Status
ppsnovationreqpurgdocnetamount PPS_E_NOVATION_DOC_VALUE Total Value / Target Value
ppsnvtnrequestitemstatustext VAL_TEXT Short Description
ppsnvtnreqitmstscriticality abap.int1
purchasingdocumentcategoryname VAL_TEXT Short Description
purchasingdocumentdescription PPS_E_DOCUMENT_DESCRIPTION Document Desc
validitystartdate KDATB Validity Start
validityenddate KDATE Validity End
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_PPS_PURGDOCUPDTREQUESTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PURUPDI_D (
    MANDT,                           -- Client [MANDT]
    PPSPURGDOCUPDTREQUEST,           -- Request Number [PPS_E_REQUEST_NO]
    PPSPURGDOCUPDTREQUESTITEM,       -- Item Number [PPS_E_REQUEST_ITEM_NO]
    PPSPURGDOCUPDTREQITEMSTATUS,     -- Item Status [PPS_E_UPDREQ_ITM_STATUS]
    PPSPURGDOCUPDTREQITMSTSCRITLTY,  -- abap.int1
    PPSITEMALLOCATEDAMOUNT,          -- Allocated Amount [PPS_E_ALLOCATED_AMOUNT]
    PPSPURGDOCNUMBER,                -- Purchasing Document [PPS_E_PURG_DOC_NUMBER]
    PURCHASINGDOCUMENTITEM,          -- Document Item [PPS_E_PURG_DOC_ITEM]
    PURCHASINGDOCUMENTVERSION,       -- Version [REVNO]
    PPSREQUESTEDAMOUNT,              -- Requested Amount [PPS_E_REQUESTED_AMOUNT]
    PPSUNFUNDEDAMOUNT,               -- Unfunded Amount [PPS_E_UNFUNDED_AMOUNT]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    CREATIONDATETIME,                -- Created On [VDM_CREATIONDATETIME]
    CREATEDBYUSER,                   -- Created By [VDM_CREATEDBYUSERID]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    LASTCHANGEDBYUSER,               -- Changed By [VDM_LASTCHANGEDBYUSERID]
    APPLICATIONJOBDESCRIPTION,       -- External ID [BALNREXT]
    APPLICATIONLOGHANDLE,            -- Log ID [PPS_E_NOVATION_LOG_ID]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [PSTYP]
    PRODUCTTYPECODE,                 -- Product Type Group [PRODUCT_TYPE]
    MATERIAL,                        -- Material [MATNR]
    NETAMOUNT,                       -- Net Value [BWERT]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [KNTTP]
    PPSSMARTDOCUMENTNUMBER,          -- Smart Document Number [PPS_E_SMT_DOC_NUMBER]
    PURGCONFIGURABLEITEMNUMBER,      -- Hierarchy Number [EXLIN]
    PURCHASINGDOCUMENTTYPE,          -- Document Type [ESART]
    PPSFUNDEDAMOUNT,                 -- Funded Amount [PPS_E_FUNDED_AMOUNT]
    PPSCONFIGURABLELINEITEMNUMBER,   -- Configurable Line Item Number [PPS_E_CONFIG_ITEM_NO]
    PLANT,                           -- Plant [EWERK]
    COMPANYCODE,                     -- Company Code [BUKRS]
    UICT_HIDEEARMARKEDFUNDSFACET,    -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PPSISDELETEHIDDEN,               -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    SEMANTICOBJECT,                  -- abap.char
    UICT_HIDEMESSAGEBUTTON,          -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PURCHASINGDOCUMENTCATEGORY,      -- Purchasing Document Category [PPS_E_NOVATION_DOC_CAT]
    PPSNOVATIONREQUESTITEMSTATUS,    -- Novation Status [PPS_E_NOVATION_ITM_STATUS]
    PPSNOVATIONREQPURGDOCNETAMOUNT,  -- Total Value / Target Value [PPS_E_NOVATION_DOC_VALUE]
    PPSNVTNREQUESTITEMSTATUSTEXT,    -- Short Description [VAL_TEXT]
    PPSNVTNREQITMSTSCRITICALITY,     -- abap.int1
    PURCHASINGDOCUMENTCATEGORYNAME,  -- Short Description [VAL_TEXT]
    PURCHASINGDOCUMENTDESCRIPTION,   -- Document Desc [PPS_E_DOCUMENT_DESCRIPTION]
    VALIDITYSTARTDATE,               -- Validity Start [KDATB]
    VALIDITYENDDATE,                 -- Validity End [KDATE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PPSPURGDOCUPDTREQUEST, PPSPURGDOCUPDTREQUESTITEM)
);

Learn More