GHO_PPA_REQUEST

Transparent Table Application Table
23 Fields 19 CDS Views

PPA request details

GHO_PPA_REQUEST is an SAP database table in S/4HANA. PPA request details. It contains 23 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 (23)

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
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

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]
    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]
    PRIMARY KEY (CLIENT, PPA_REQ_ID, DATA_GUID)
);

Learn More