P_ENHPHYSINVTRYACTVSTKSEPVAL

CDS View
14 Fields 3 CDS Views

P_ENHPHYSINVTRYACTVSTKSEPVAL 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
C_PhysInvtryProposal view from CONSUMPTION Proposals for new PI counts
P_PhysInventorySituation view left_outer COMPOSITE
P_PhysInvtryProposal view from CONSUMPTION Proposals for new PI documents

Fields (14)

KeyField CDS FieldsUsed in Views
KEY MaterialIsPostedToStock MaterialIsPostedToStock 2
KEY Plant Plant 2
CompanyCodeCurrency CompanyCodeCurrency 2
GdsIssQtySinceLastCountInBsUnt GdsIssQtySinceLastCountInBsUnt 3
GdsRcptQtySinceLastCtInBsUnt GdsRcptQtySinceLastCtInBsUnt 3
NmbrOfDaysSinceLastPInvCount NmbrOfDaysSinceLastPInvCount 2
NrOfGdsRcptSinceLastPInvCount NrOfGdsRcptSinceLastPInvCount 3
NrOfGoodsIssSinceLastPInvCount NrOfGoodsIssSinceLastPInvCount 3
NumberOfPhysInventoryCounts NumberOfPhysInventoryCounts 3
NumberOfPInvAdjustmentsPerYear NumberOfPInvAdjustmentsPerYear 3
PhysicalInventoryItemIsCounted PhysicalInventoryItemIsCounted 2
PhysicalInventoryLastCountDate PhysicalInventoryLastCountDate 2
PInvDiffQtyPerYearInBaseUnit PInvDiffQtyPerYearInBaseUnit 3
WBSElementInternalID WBSElementInternalID 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_ENHPHYSINVTRYACTVSTKSEPVAL (
    MATERIALISPOSTEDTOSTOCK,
    PLANT,
    COMPANYCODECURRENCY,
    GDSISSQTYSINCELASTCOUNTINBSUNT,
    GDSRCPTQTYSINCELASTCTINBSUNT,
    NMBROFDAYSSINCELASTPINVCOUNT,
    NROFGDSRCPTSINCELASTPINVCOUNT,
    NROFGOODSISSSINCELASTPINVCOUNT,
    NUMBEROFPHYSINVENTORYCOUNTS,
    NUMBEROFPINVADJUSTMENTSPERYEAR,
    PHYSICALINVENTORYITEMISCOUNTED,
    PHYSICALINVENTORYLASTCOUNTDATE,
    PINVDIFFQTYPERYEARINBASEUNIT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (MATERIALISPOSTEDTOSTOCK, PLANT)
);

Learn More