PPS_T_CONHIERITM

Transparent Table Application Table
22 Fields 1 CDS Views

PPS : Purchase Contract Hierarchy Header

PPS_T_CONHIERITM is an SAP database table in S/4HANA. PPS : Purchase Contract Hierarchy Header. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPSPurContractHierarchyItem view_entity from BASIC PPS Purchase Contract Hierarchies Item

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hier_uuid PPS_E_CONTR_HIER_UUID Contract Hier. UUID
KEY hier_item_uuid PPS_E_CONTR_HIERITEM_UUID Contract Hier. UUID
parent_hier_item_uuid PPS_E_CONTR_HIERITEM_UUID Contract Hier. UUID
purchasecontract VDM_PURCHASECONTRACT Purchase Contract
pps_sibling_order_number PPS_E_CONTR_HIERITEM_SORTNUM Item Sort Number
root_contract VDM_PURCHASECONTRACT Purchase Contract
purchasing_group EKGRP Purch. Group
supplier MD_SUPPLIER Supplier
documentcurrency WAERS Currency
purchasecontracttargetamount KTWRT Target Value
ppspurcontrheaderstatus PPS_E_HDR_STATUS Status
ppscalloffamount NETWR Net Value
invoiceamount PPS_E_OPEN_INV_AMOUNT PPS Open Invoice Amt
createdby ABP_CREATION_USER Created By
createdon CREATION_DATE_TIME Created On
creationtime ABP_CREATION_TSTMPL Created On
changedby ABP_LASTCHANGE_USER Changed By
lastchangedatetime CHANGEDATETIME Last Changed
contractconsumptioninpct PPS_E_CONSUMPTION_QTY Consumption in %
purcontractconsumptioninpct PPS_E_CONSUMPTION_QTY Consumption in %
purcontrconsumptionunit MEINS Base Unit

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.

-- PPS : Purchase Contract Hierarchy Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_T_CONHIERITM (
    MANDT,                         -- Client [MANDT]
    HIER_UUID,                     -- Contract Hier. UUID [PPS_E_CONTR_HIER_UUID]
    HIER_ITEM_UUID,                -- Contract Hier. UUID [PPS_E_CONTR_HIERITEM_UUID]
    PARENT_HIER_ITEM_UUID,         -- Contract Hier. UUID [PPS_E_CONTR_HIERITEM_UUID]
    PURCHASECONTRACT,              -- Purchase Contract [VDM_PURCHASECONTRACT]
    PPS_SIBLING_ORDER_NUMBER,      -- Item Sort Number [PPS_E_CONTR_HIERITEM_SORTNUM]
    ROOT_CONTRACT,                 -- Purchase Contract [VDM_PURCHASECONTRACT]
    PURCHASING_GROUP,              -- Purch. Group [EKGRP]
    SUPPLIER,                      -- Supplier [MD_SUPPLIER]
    DOCUMENTCURRENCY,              -- Currency [WAERS]
    PURCHASECONTRACTTARGETAMOUNT,  -- Target Value [KTWRT]
    PPSPURCONTRHEADERSTATUS,       -- Status [PPS_E_HDR_STATUS]
    PPSCALLOFFAMOUNT,              -- Net Value [NETWR]
    INVOICEAMOUNT,                 -- PPS Open Invoice Amt [PPS_E_OPEN_INV_AMOUNT]
    CREATEDBY,                     -- Created By [ABP_CREATION_USER]
    CREATEDON,                     -- Created On [CREATION_DATE_TIME]
    CREATIONTIME,                  -- Created On [ABP_CREATION_TSTMPL]
    CHANGEDBY,                     -- Changed By [ABP_LASTCHANGE_USER]
    LASTCHANGEDATETIME,            -- Last Changed [CHANGEDATETIME]
    CONTRACTCONSUMPTIONINPCT,      -- Consumption in % [PPS_E_CONSUMPTION_QTY]
    PURCONTRACTCONSUMPTIONINPCT,   -- Consumption in % [PPS_E_CONSUMPTION_QTY]
    PURCONTRCONSUMPTIONUNIT,       -- Base Unit [MEINS]
    PRIMARY KEY (MANDT, HIER_UUID, HIER_ITEM_UUID)
);

Learn More