PPS_T_CONHIERHDR

Transparent Table Application Table
30 Fields 1 CDS Views

PPS : Purchase Contract Hierarchy Header

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPSPurchaseContractHierarchy view_entity from BASIC PPS Purchase Contract Hierarchies

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hier_uuid PPS_E_CONTR_HIER_UUID Contract Hier. UUID
root_contract VDM_PURCHASECONTRACT Purchase Contract
hier_id PPS_E_CONHIERID Hierarchy ID
hier_desc PPS_E_CONHIERDESC Hierarchy Desc.
createdby ABP_CREATION_USER Created By
createdon ABP_CREATION_DATE Created On
creationtime ABP_CREATION_TSTMPL Created On
changedby ABP_LASTCHANGE_USER Changed By
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
documentcurrency WAERS Currency
purchasecontracttargetamount KTWRT Target Value
contractconsumptioninpct PPS_E_CONSUMPTION_QTY Consumption in %
purcontrconsumptionunit MEINS Base Unit
purcontractconsumptioninpct PPS_E_CONSUMPTION_QTY Consumption in %
purchasingorganization EKORG Purchasing Org.
purchasinggroup BKGRP Purch. Group
purchasingdocumentname VDM_PURGDOC_NAME Purch. Doc. Name
supplier MD_SUPPLIER Supplier
purchasingprocessingstatus MEPROCSTATE Proc. State
ppspurcontrheaderstatus PPS_E_HDR_STATUS Status
purchasingdocumentcategory EBSTYP Doc. Category
purchasecontracttype ESART Document Type
companycode BUKRS Company Code
ppsfiscalyear GJAHR Fiscal Year
ppsopeninvoicereceiptamount PPS_E_OPEN_INV_AMOUNT PPS Open Invoice Amt
inv_doc_currency WAERS Currency
ppscalloffamount PPS_E_REL_ORD_AMOUNT PPSReleaseOrderAmnt
totaldocumentcurrency WAERS Currency
pps_ready_for_archive PPS_E_READY_TO_ARCHIVE Ready for Archive

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_CONHIERHDR (
    MANDT,                         -- Client [MANDT]
    HIER_UUID,                     -- Contract Hier. UUID [PPS_E_CONTR_HIER_UUID]
    ROOT_CONTRACT,                 -- Purchase Contract [VDM_PURCHASECONTRACT]
    HIER_ID,                       -- Hierarchy ID [PPS_E_CONHIERID]
    HIER_DESC,                     -- Hierarchy Desc. [PPS_E_CONHIERDESC]
    CREATEDBY,                     -- Created By [ABP_CREATION_USER]
    CREATEDON,                     -- Created On [ABP_CREATION_DATE]
    CREATIONTIME,                  -- Created On [ABP_CREATION_TSTMPL]
    CHANGEDBY,                     -- Changed By [ABP_LASTCHANGE_USER]
    LASTCHANGEDATETIME,            -- Changed On [ABP_LASTCHANGE_TSTMPL]
    DOCUMENTCURRENCY,              -- Currency [WAERS]
    PURCHASECONTRACTTARGETAMOUNT,  -- Target Value [KTWRT]
    CONTRACTCONSUMPTIONINPCT,      -- Consumption in % [PPS_E_CONSUMPTION_QTY]
    PURCONTRCONSUMPTIONUNIT,       -- Base Unit [MEINS]
    PURCONTRACTCONSUMPTIONINPCT,   -- Consumption in % [PPS_E_CONSUMPTION_QTY]
    PURCHASINGORGANIZATION,        -- Purchasing Org. [EKORG]
    PURCHASINGGROUP,               -- Purch. Group [BKGRP]
    PURCHASINGDOCUMENTNAME,        -- Purch. Doc. Name [VDM_PURGDOC_NAME]
    SUPPLIER,                      -- Supplier [MD_SUPPLIER]
    PURCHASINGPROCESSINGSTATUS,    -- Proc. State [MEPROCSTATE]
    PPSPURCONTRHEADERSTATUS,       -- Status [PPS_E_HDR_STATUS]
    PURCHASINGDOCUMENTCATEGORY,    -- Doc. Category [EBSTYP]
    PURCHASECONTRACTTYPE,          -- Document Type [ESART]
    COMPANYCODE,                   -- Company Code [BUKRS]
    PPSFISCALYEAR,                 -- Fiscal Year [GJAHR]
    PPSOPENINVOICERECEIPTAMOUNT,   -- PPS Open Invoice Amt [PPS_E_OPEN_INV_AMOUNT]
    INV_DOC_CURRENCY,              -- Currency [WAERS]
    PPSCALLOFFAMOUNT,              -- PPSReleaseOrderAmnt [PPS_E_REL_ORD_AMOUNT]
    TOTALDOCUMENTCURRENCY,         -- Currency [WAERS]
    PPS_READY_FOR_ARCHIVE,         -- Ready for Archive [PPS_E_READY_TO_ARCHIVE]
    PRIMARY KEY (MANDT, HIER_UUID)
);

Learn More