I_PRATSTPRODNCOMPAREUI

CDS View
31 Fields 2 CDS Views

TV - Production Calculate UI

I_PRATSTPRODNCOMPAREUI is a CDS View in S/4HANA. TV - Production Calculate UI. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PRATstProdnRslts view from CONSUMPTION Detail of Production Regression
C_PRATstProdnRsltsDet view from CONSUMPTION TV - Production Detail View

Fields (31)

KeyField CDS FieldsUsed in Views
KEY PRATstAllocVersion PRATstAllocVersion 2
KEY WellCompltnVolDoc WellCompltnVolDoc 2
KEY WellCompltnVolDocYr WellCompltnVolDocYr 2
AllocationFrequency AllocationFrequency 1
BaselineEnergy BaselineEnergy 2
BaselineHeatingValue BaselineHeatingValue 2
BaselineMaterial BaselineMaterial 2
BaselineStandardDensity BaselineStandardDensity 2
BaselineStandardVolume BaselineStandardVolume 2
BslnNmbrOfDaysProduced BslnNmbrOfDaysProduced 2
DeliveryNetwork DeliveryNetwork 2
EffectiveValidityStartDate EffectiveValidityStartDate 2
Energy Energy 2
EnergyUnit EnergyUnit 2
HeatingValue HeatingValue 2
HeatingValUnit HeatingValUnit 2
InventoryDate InventoryDate 2
MajorProduct MajorProduct 2
Material Material 2
NmbrOfDaysProduced NmbrOfDaysProduced 2
OriginatingMeasurementPt OriginatingMeasurementPt 2
ProductionDate ProductionDate 2
StandardDensity StandardDensity 2
StandardDensityUnit StandardDensityUnit 2
StandardVolume StandardVolume 2
StandardVolUnit StandardVolUnit 2
TicketNumber TicketNumber 2
Transporter Transporter 2
VolumeType VolumeType 2
Well Well 2
WellCompletion WellCompletion 2

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.

-- TV - Production Calculate UI
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRATSTPRODNCOMPAREUI (
    PRATSTALLOCVERSION,
    WELLCOMPLTNVOLDOC,
    WELLCOMPLTNVOLDOCYR,
    ALLOCATIONFREQUENCY,
    BASELINEENERGY,
    BASELINEHEATINGVALUE,
    BASELINEMATERIAL,
    BASELINESTANDARDDENSITY,
    BASELINESTANDARDVOLUME,
    BSLNNMBROFDAYSPRODUCED,
    DELIVERYNETWORK,
    EFFECTIVEVALIDITYSTARTDATE,
    ENERGY,
    ENERGYUNIT,
    HEATINGVALUE,
    HEATINGVALUNIT,
    INVENTORYDATE,
    MAJORPRODUCT,
    MATERIAL,
    NMBROFDAYSPRODUCED,
    ORIGINATINGMEASUREMENTPT,
    PRODUCTIONDATE,
    STANDARDDENSITY,
    STANDARDDENSITYUNIT,
    STANDARDVOLUME,
    STANDARDVOLUNIT,
    TICKETNUMBER,
    TRANSPORTER,
    VOLUMETYPE,
    WELL,
    WELLCOMPLETION,
    PRIMARY KEY (PRATSTALLOCVERSION, WELLCOMPLTNVOLDOC, WELLCOMPLTNVOLDOCYR)
);

Learn More