_PREVALLOCPERIOD

_PREVALLOCPERIOD is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AllocationRuleUnitOfMsmt AllocationRuleUnitOfMsmt 2
KEY AllocationRunID PrevPeriodAllocationRunUUID 2
KEY GHOQuantityCategory GHOQuantityCategory 1
_FrequencyDetails _FrequencyDetails 1
_QuantityCategory _QuantityCategory 1
AllocationFrequencyCode AllocationFrequencyCode 1
AllocationResultIsFinal AllocationResultIsFinal 1
GHOAllocationQuantity GHOAllocationQuantity 1
GHOChangedOnDateTime GHOPrevProdnChangedDateTime 1
ProdnAllocDateTime PrevProdnAllocDateTime 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PREVALLOCPERIOD (
    ALLOCATIONRULEUNITOFMSMT,
    ALLOCATIONRUNID,
    GHOQUANTITYCATEGORY,
    _FREQUENCYDETAILS,
    _QUANTITYCATEGORY,
    ALLOCATIONFREQUENCYCODE,
    ALLOCATIONRESULTISFINAL,
    GHOALLOCATIONQUANTITY,
    GHOCHANGEDONDATETIME,
    PRODNALLOCDATETIME,
    PRIMARY KEY (ALLOCATIONRULEUNITOFMSMT, ALLOCATIONRUNID, GHOQUANTITYCATEGORY)
);