P_ABOPRUNCONFBEFOREWTHADDUNITS

CDS View

P_ABOPRUNCONFBEFOREWTHADDUNITS is a CDS View in S/4HANA. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_ABOPRunAllConfirmations view union COMPOSITE
P_ABOPRunConfDatesBefore view from COMPOSITE
P_ABOPRunIterationAllConf view union COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ATPCheckUUID ATPCheckUUID 2
KEY ConfdProdAvailabilityUTCDteTme ATPCheckRelevantUTCDateTime 2
KEY Product Product 1
KEY SupplyingPlant Plant 1
KEY SupplyingStorageLocation StorageLocation 1
_BaseUnit _BaseUnit 1
_SupplyingPlant _SupplyingPlant 2
_SupplyingStorageLocation _SupplyingStorageLocation 1
BaseToCommonBaseQtyDenominator BaseToCommonBaseQtyDenominator 1
BaseToCommonBaseQtyNumerator BaseToCommonBaseQtyNumerator 1
BaseUnit BaseUnit 2
ConfdProdAvailabilityTimeZone ATPCheckRelevantTimeZone 2
ConfirmedQuantityInBaseUnit ConfirmedQtyBeforeInBaseUnit,ConfirmedQuantityBefore 2
ConfirmedQuantityInComBaseUnit ConfirmedQtyBefInComBaseUnit 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ABOPRUNCONFBEFOREWTHADDUNITS (
    ATPCHECKUUID,
    CONFDPRODAVAILABILITYUTCDTETME,
    PRODUCT,
    SUPPLYINGPLANT,
    SUPPLYINGSTORAGELOCATION,
    _BASEUNIT,
    _SUPPLYINGPLANT,
    _SUPPLYINGSTORAGELOCATION,
    BASETOCOMMONBASEQTYDENOMINATOR,
    BASETOCOMMONBASEQTYNUMERATOR,
    BASEUNIT,
    CONFDPRODAVAILABILITYTIMEZONE,
    CONFIRMEDQUANTITYINBASEUNIT,
    CONFIRMEDQUANTITYINCOMBASEUNIT,
    PRIMARY KEY (ATPCHECKUUID, CONFDPRODAVAILABILITYUTCDTETME, PRODUCT, SUPPLYINGPLANT, SUPPLYINGSTORAGELOCATION)
);