PPS_CONHIERHDR_D

Transparent Table Application Table
31 Fields 1 CDS Views

Draft table for entity R_PPS_PURCONTRHIERARCHYTP

PPS_CONHIERHDR_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRHIERARCHYTP. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPSPurContractHierarchyDraft view_entity from BASIC PPS Contract Hierarchies - Draft

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ppspurcontracthierarchyuuid PPS_E_CONTR_HIER_UUID Contract Hier. UUID
ppsrootpurchasecontract VDM_PURCHASECONTRACT Purchase Contract
ppspurchasecontracthierarchyid PPS_E_CONHIERID Hierarchy ID
ppspurcontrhierdescription PPS_E_CONHIERDESC Hierarchy Desc.
documentcurrency WAERS Currency
purchasecontracttargetamount KTWRT Target Value
contractconsumptioninpct abap.dec
purcontractconsumptioninpct abap.dec
purcontrconsumptionunit MEINS Base Unit
purchasingorganization EKORG Purchasing Org.
purchasinggroup BKGRP Purch. Group
purchasingdocumentname VDM_PURGDOC_NAME Purch. Doc. Name
supplier MD_SUPPLIER Supplier
purchasingdocumentcategory EBSTYP Doc. Category
purchasingprocessingstatus MEPROCSTATE Proc. State
ppspurcontrheaderstatus PPS_E_HDR_STATUS Status
purchasecontracttype ESART Document Type
companycode BUKRS Company Code
ppsfiscalyear GJAHR Fiscal Year
createdbyuser ABP_CREATION_USER Created By
creationdate ABP_CREATION_DATE Created On
creationdatetime ABP_CREATION_TSTMPL Created On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
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_PURCONTRHIERARCHYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_CONHIERHDR_D (
    MANDT,                           -- Client [MANDT]
    PPSPURCONTRACTHIERARCHYUUID,     -- Contract Hier. UUID [PPS_E_CONTR_HIER_UUID]
    PPSROOTPURCHASECONTRACT,         -- Purchase Contract [VDM_PURCHASECONTRACT]
    PPSPURCHASECONTRACTHIERARCHYID,  -- Hierarchy ID [PPS_E_CONHIERID]
    PPSPURCONTRHIERDESCRIPTION,      -- Hierarchy Desc. [PPS_E_CONHIERDESC]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    PURCHASECONTRACTTARGETAMOUNT,    -- Target Value [KTWRT]
    CONTRACTCONSUMPTIONINPCT,        -- abap.dec
    PURCONTRACTCONSUMPTIONINPCT,     -- abap.dec
    PURCONTRCONSUMPTIONUNIT,         -- Base Unit [MEINS]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    PURCHASINGDOCUMENTNAME,          -- Purch. Doc. Name [VDM_PURGDOC_NAME]
    SUPPLIER,                        -- Supplier [MD_SUPPLIER]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [EBSTYP]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [MEPROCSTATE]
    PPSPURCONTRHEADERSTATUS,         -- Status [PPS_E_HDR_STATUS]
    PURCHASECONTRACTTYPE,            -- Document Type [ESART]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PPSFISCALYEAR,                   -- Fiscal Year [GJAHR]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    CREATIONDATE,                    -- Created On [ABP_CREATION_DATE]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    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, PPSPURCONTRACTHIERARCHYUUID)
);

Learn More