_ALLOCATEDTHEO

23 Fields

_ALLOCATEDTHEO is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY AllocationRuleUnitOfMsmt AllocationRuleUnitOfMsmt 5
KEY AllocRsltsThrtclOrActual AllocRsltsThrtclOrActual 3
KEY EffectiveFromDateTime EffectiveFromDateTime 1
KEY GHOComponent GHOComponent 2
KEY GHOFromNtwkObjID GHOFromNtwkObjID 2
KEY GHOQuantityCategory GHOQuantityCategory 3
KEY GHOQuantityType GHOQuantityType 2
KEY GHOToNtwkObjID GHOToNtwkObjID 2
KEY WellCompltnVolDoc WellCompltnVolDoc 2
_NetworkObjectDetails _NetworkObjectDetails 1
_NtwkAllocRuleQtyType _NtwkAllocRuleQtyType 1
_QuantityCategory _QuantityCategory 1
AllocationMaterial AllocationMaterial 1
EffectiveToDateTime EffectiveToDateTime 1
GHOOriginatingMsmtPoint GHOOriginatingMsmtPoint 1
InventoryDate InventoryDate 1
LoadOilTransferWithoutRecovery LoadOilTransferWithoutRecovery 1
ProductionHours ProductionHours 1
ReclassifiedMaterial ReclassifiedMaterial 1
TicketDateTime TicketDateTime 1
TicketNumber TicketNumber 1
Transporter Transporter 1
TransporterReference TransporterReference 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 _ALLOCATEDTHEO (
    ALLOCATIONRULEUNITOFMSMT,
    ALLOCRSLTSTHRTCLORACTUAL,
    EFFECTIVEFROMDATETIME,
    GHOCOMPONENT,
    GHOFROMNTWKOBJID,
    GHOQUANTITYCATEGORY,
    GHOQUANTITYTYPE,
    GHOTONTWKOBJID,
    WELLCOMPLTNVOLDOC,
    _NETWORKOBJECTDETAILS,
    _NTWKALLOCRULEQTYTYPE,
    _QUANTITYCATEGORY,
    ALLOCATIONMATERIAL,
    EFFECTIVETODATETIME,
    GHOORIGINATINGMSMTPOINT,
    INVENTORYDATE,
    LOADOILTRANSFERWITHOUTRECOVERY,
    PRODUCTIONHOURS,
    RECLASSIFIEDMATERIAL,
    TICKETDATETIME,
    TICKETNUMBER,
    TRANSPORTER,
    TRANSPORTERREFERENCE,
    PRIMARY KEY (ALLOCATIONRULEUNITOFMSMT, ALLOCRSLTSTHRTCLORACTUAL, EFFECTIVEFROMDATETIME, GHOCOMPONENT, GHOFROMNTWKOBJID, GHOQUANTITYCATEGORY, GHOQUANTITYTYPE, GHOTONTWKOBJID, WELLCOMPLTNVOLDOC)
);

Learn More