GHO_ALLOCRES_H

Transparent Table Application Table
27 Fields 9 CDS Views

Allocation Results Header

GHO_ALLOCRES_H is an SAP database table in S/4HANA. Allocation Results Header. It contains 27 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_GHOAllocationRunCount view_entity union COMPOSITE Allocation run Count
I_GhoAllocResH_Db view from BASIC Allocation Result Header
UPO_INT_V_ALLOC_DATA view from UOM Alloc Data for a Run Id
UPOV_ALLOC_DATA view from UOM Alloc Data for a Run Id
UPOV_ALLOC_RESULTS_DIM view from Allocation Results based on dimension
UPOV_ALLOC_RESULTS_WC view inner Allocation Result details per WC
UPOV_ORIGIN_DEST_DET view inner Allocated Origin Destination combination
UPOV_WC_SOURCED_FROM_INVT view inner WC Sourced from Inventory
UPOV_WC_THEO_VALUE view inner Theoretical Volume at Well Completion

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY alloc_run_id GHO_ALLOC_RUN_ID Allocation Run ID
netid GHO_NETOBJ_ID Netw Object ID
medium GHO_PRODUCT Medium ID
alloc_type GHO_ALLOC_TYPE Allocation Type
frequency GHO_ALLOC_FREQUENCY Frequency ID
prod_date GHO_START_DATE_ALLOC Prod. Start Dt
prod_time GHO_START_TIME_ALLOC Prod St Tme
alloc_purpose GHO_ALLOC_PURPOSE Allocation Purpose
final_ind GHO_FINAL_IND Final Ind Alloc Rest
alloc_status GHO_ALLOC_STATUS Alloc Run Status
last_process_ts TIMESTAMP Time Stamp
batch_run_id GUID GUID
log_handle_trace BALLOGHNDL Handle
created_by GHO_CREATED_BY Record Created By
created_tst GHO_DE_CREATED_ON Created On
changed_by GHO_CHANGED_BY Changed By
changed_tst GHO_DE_CHANGED_ON Changed On
ppn_indicator GHO_PPN_INDICATOR Pending PPN
ppn_log_handle BALLOGHNDL Handle
business_status GHO_ALLOC_BUSINESS_STATUS Business Status
status_object_number GHO_DE_OBJECT_NUMBER Object Number
last_action GHO_DE_ACTION Status Mgmt Action
doc_num UPO_UDM_VER_DOC_NUM Document No.
doc_year GJAHR Fiscal Year
conv_grp OIB_UMRSL Conv. Group
prod_aloc_datetime_utc GHO_PRODALLOC_UTC_DATETIME Production UTC Date Time

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.

-- Allocation Results Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_ALLOCRES_H (
    CLIENT,                  -- Client [MANDT]
    ALLOC_RUN_ID,            -- Allocation Run ID [GHO_ALLOC_RUN_ID]
    NETID,                   -- Netw Object ID [GHO_NETOBJ_ID]
    MEDIUM,                  -- Medium ID [GHO_PRODUCT]
    ALLOC_TYPE,              -- Allocation Type [GHO_ALLOC_TYPE]
    FREQUENCY,               -- Frequency ID [GHO_ALLOC_FREQUENCY]
    PROD_DATE,               -- Prod. Start Dt [GHO_START_DATE_ALLOC]
    PROD_TIME,               -- Prod St Tme [GHO_START_TIME_ALLOC]
    ALLOC_PURPOSE,           -- Allocation Purpose [GHO_ALLOC_PURPOSE]
    FINAL_IND,               -- Final Ind Alloc Rest [GHO_FINAL_IND]
    ALLOC_STATUS,            -- Alloc Run Status [GHO_ALLOC_STATUS]
    LAST_PROCESS_TS,         -- Time Stamp [TIMESTAMP]
    BATCH_RUN_ID,            -- GUID [GUID]
    LOG_HANDLE_TRACE,        -- Handle [BALLOGHNDL]
    CREATED_BY,              -- Record Created By [GHO_CREATED_BY]
    CREATED_TST,             -- Created On [GHO_DE_CREATED_ON]
    CHANGED_BY,              -- Changed By [GHO_CHANGED_BY]
    CHANGED_TST,             -- Changed On [GHO_DE_CHANGED_ON]
    PPN_INDICATOR,           -- Pending PPN [GHO_PPN_INDICATOR]
    PPN_LOG_HANDLE,          -- Handle [BALLOGHNDL]
    BUSINESS_STATUS,         -- Business Status [GHO_ALLOC_BUSINESS_STATUS]
    STATUS_OBJECT_NUMBER,    -- Object Number [GHO_DE_OBJECT_NUMBER]
    LAST_ACTION,             -- Status Mgmt Action [GHO_DE_ACTION]
    DOC_NUM,                 -- Document No. [UPO_UDM_VER_DOC_NUM]
    DOC_YEAR,                -- Fiscal Year [GJAHR]
    CONV_GRP,                -- Conv. Group [OIB_UMRSL]
    PROD_ALOC_DATETIME_UTC,  -- Production UTC Date Time [GHO_PRODALLOC_UTC_DATETIME]
    PRIMARY KEY (CLIENT, ALLOC_RUN_ID)
);

Learn More