GHO_PPA_REQUEST

Transparent Table Application Table
28 Fields 19 CDS Views

PPA request details

GHO_PPA_REQUEST is an SAP database table in S/4HANA. PPA request details. It contains 28 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
I_GHOPriorPerdAdjmtReq view from BASIC Prior Period Adjustment Request
I_GHOPriorPeriodNotification view_entity from COMPOSITE Prior Period Notification
UPOV_DATAGUID_TO_INSPLOT view from Convert GUID to InspLot for Well Test
UPOV_DEFERMENTEVENT_BA view from Deferment Event Before After image
UPOV_NWMODELLING_BA view from Network Modelling PPA before after data
UPOV_PCDPOS_ZONAL view from Prepare Zonal data from Planning Doc
UPOV_PPN_DATED_BA view from PPA FOR DATED
UPOV_PPN_EV_SET_X view union PPN event to Set Cross Reference
UPOV_PPN_EVENT view union PPN Event
UPOV_PPN_MP_BA_UOM view from Event Detail Ref - Before/After data
UPOV_PPN_NETRULE_BA view from Event Detail Ref - Before/After data
UPOV_PPN_SET_MP view from PPN for Measurement Point
UPOV_PPN_SET_WC view from PPN for Well Test
UPOV_PPN_WCVOLUME_BA view from WC Volumes Before After Data
UPOV_PPN_WLT_BA view from Event Detail Ref - Before/After data
UPOV_PPN_ZONAL_BA view from PPN for zonal contribution
upov_pr_proctype_fixfieldname view from Fixed fieldnames for Process type
upov_pr_proctype_varfieldname view from Variable fieldnames for Process type
UPOV_PRODDATE_PNTZ view from Production Date in PN timezone

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY ppa_req_id GHO_DE_TYPE_ID ID of Data for Audit
KEY data_guid GHO_DE_DATA_ID Data Guid/Bus. Key
process_type GHO_DE_TYPE Type of Data
netid GHO_DE_NETOBJID Netwrk Obj ID
requester GHO_DE_REQUESTER PPA Requested By
approver GHO_DE_APPROVER PPA Req Approver
change_start_period GHO_DE_CHANGE_START_DATE Change Start Date
change_end_period GHO_DE_CHANGE_END_DATE Change End Date
ppa_req_status GHO_DE_PPA_REQ_STAT PPA Request Status
ppa_req_reason GHO_DE_PPA_REQ_REASON PPA Req Rsn Descripn
audit_reaon_code GHO_DE_AUDIT_REASON_CODE Audit Reason Code
cdoc_num CDCHANGENR Document Number
planchngnr GHO_DE_PLAN_CHDOC Plan document number
created_on GHO_CREATE_DATE Create Date
created_tst GHO_DE_CREATED_TIME Req Created Time
action GHO_DM_ACTION_TYPE Action Type
net_obj_id GHO_DE_NETOBJID Netwrk Obj ID
medium GHO_PRODUCT Medium ID
frequency GHO_ALLOC_FREQUENCY Frequency ID
processed_on GHO_DE_PROCESSED_ON Processed On
processed_at GHO_DE_PROCESSED_AT Processed At
processor_comment GHO_DE_PROCESSOR_COMMENT Processor Comment
ppa_approved_date GHO_DE_PROCESSED_ON Processed On
ppa_approved_time GHO_DE_PROCESSED_AT Processed At
ppa_aprv_rej_reason GHO_DE_PROCESSOR_COMMENT Processor Comment
inf_ppa_ind GHO_DE_PPA_IND Informative PPA Indicator
inf_ppa_guid GHO_DE_DATA_ID Data Guid/Bus. Key

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.

-- PPA request details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_PPA_REQUEST (
    CLIENT,               -- Client [MANDT]
    PPA_REQ_ID,           -- ID of Data for Audit [GHO_DE_TYPE_ID]
    DATA_GUID,            -- Data Guid/Bus. Key [GHO_DE_DATA_ID]
    PROCESS_TYPE,         -- Type of Data [GHO_DE_TYPE]
    NETID,                -- Netwrk Obj ID [GHO_DE_NETOBJID]
    REQUESTER,            -- PPA Requested By [GHO_DE_REQUESTER]
    APPROVER,             -- PPA Req Approver [GHO_DE_APPROVER]
    CHANGE_START_PERIOD,  -- Change Start Date [GHO_DE_CHANGE_START_DATE]
    CHANGE_END_PERIOD,    -- Change End Date [GHO_DE_CHANGE_END_DATE]
    PPA_REQ_STATUS,       -- PPA Request Status [GHO_DE_PPA_REQ_STAT]
    PPA_REQ_REASON,       -- PPA Req Rsn Descripn [GHO_DE_PPA_REQ_REASON]
    AUDIT_REAON_CODE,     -- Audit Reason Code [GHO_DE_AUDIT_REASON_CODE]
    CDOC_NUM,             -- Document Number [CDCHANGENR]
    PLANCHNGNR,           -- Plan document number [GHO_DE_PLAN_CHDOC]
    CREATED_ON,           -- Create Date [GHO_CREATE_DATE]
    CREATED_TST,          -- Req Created Time [GHO_DE_CREATED_TIME]
    ACTION,               -- Action Type [GHO_DM_ACTION_TYPE]
    NET_OBJ_ID,           -- Netwrk Obj ID [GHO_DE_NETOBJID]
    MEDIUM,               -- Medium ID [GHO_PRODUCT]
    FREQUENCY,            -- Frequency ID [GHO_ALLOC_FREQUENCY]
    PROCESSED_ON,         -- Processed On [GHO_DE_PROCESSED_ON]
    PROCESSED_AT,         -- Processed At [GHO_DE_PROCESSED_AT]
    PROCESSOR_COMMENT,    -- Processor Comment [GHO_DE_PROCESSOR_COMMENT]
    PPA_APPROVED_DATE,    -- Processed On [GHO_DE_PROCESSED_ON]
    PPA_APPROVED_TIME,    -- Processed At [GHO_DE_PROCESSED_AT]
    PPA_APRV_REJ_REASON,  -- Processor Comment [GHO_DE_PROCESSOR_COMMENT]
    INF_PPA_IND,          -- Informative PPA Indicator [GHO_DE_PPA_IND]
    INF_PPA_GUID,         -- Data Guid/Bus. Key [GHO_DE_DATA_ID]
    PRIMARY KEY (CLIENT, PPA_REQ_ID, DATA_GUID)
);

Learn More