P_ENHPHYSINVTRYACTVSTKSEPVAL

CDS View
34 Fields 2 CDS Views

Active stock separators for which a PI count can be done

P_ENHPHYSINVTRYACTVSTKSEPVAL is a CDS View in S/4HANA. Active stock separators for which a PI count can be done. It contains 34 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PhysInvtryProposal view_entity from CONSUMPTION Proposals for new PI counts
P_PhysInvtryProposal view_entity from CONSUMPTION Proposals for new PI documents

Fields (34)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 2
KEY InventorySpecialStockType InventorySpecialStockType 2
KEY InventoryStockType InventoryStockType 2
KEY Material Material 2
KEY MaterialBaseUnit MaterialBaseUnit 2
KEY MaterialIsPostedToStock MaterialIsPostedToStock 2
KEY Plant Plant 2
KEY RealProductBatch Batch 2
KEY SalesOrder SalesOrder 2
KEY SalesOrderItem SalesOrderItem 2
KEY StockOwner StockOwner 2
KEY StorageLocation StorageLocation 2
KEY Supplier Supplier 2
KEY WBSElement WBSElement 2
Batch SearchForBatch 1
CompanyCodeCurrency CompanyCodeCurrency 2
CycleCountType CycleCountType 2
GdsIssQtySinceLastCountInBsUnt GdsIssQtySinceLastCountInBsUnt 2
GdsRcptQtySinceLastCtInBsUnt GdsRcptQtySinceLastCtInBsUnt 2
NmbrOfDaysSinceLastPInvCount NmbrOfDaysSinceLastPInvCount 2
NmbrOfPhysInvtryPerFiscalYear NmbrOfPhysInvtryPerFiscalYear 2
NrOfGdsRcptSinceLastPInvCount NrOfGdsRcptSinceLastPInvCount 2
NrOfGoodsIssSinceLastPInvCount NrOfGoodsIssSinceLastPInvCount 2
NumberOfPhysInventoryCounts NumberOfPhysInventoryCounts 2
NumberOfPInvAdjustmentsPerYear NumberOfPInvAdjustmentsPerYear 2
PhysicalInventoryItemIsCounted PhysicalInventoryItemIsCounted 2
PhysicalInventoryLastCountDate PhysicalInventoryLastCountDate 2
PhysInvtryFloatTimeCycCounting PhysInvtryFloatTimeCycCounting 2
PhysInvtryIntvlForCycCounting PhysInvtryIntvlForCycCounting 2
PInvDiffQtyPerYearInBaseUnit PInvDiffQtyPerYearInBaseUnit 2
ProductGroup ProductGroup 2
ProductType ProductType 2
SearchForValuationType SearchForValuationType 1
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.

-- Active stock separators for which a PI count can be done
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ENHPHYSINVTRYACTVSTKSEPVAL (
    CUSTOMER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSTOCKTYPE,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALISPOSTEDTOSTOCK,
    PLANT,
    REALPRODUCTBATCH,
    SALESORDER,
    SALESORDERITEM,
    STOCKOWNER,
    STORAGELOCATION,
    SUPPLIER,
    WBSELEMENT,
    BATCH,
    COMPANYCODECURRENCY,
    CYCLECOUNTTYPE,
    GDSISSQTYSINCELASTCOUNTINBSUNT,
    GDSRCPTQTYSINCELASTCTINBSUNT,
    NMBROFDAYSSINCELASTPINVCOUNT,
    NMBROFPHYSINVTRYPERFISCALYEAR,
    NROFGDSRCPTSINCELASTPINVCOUNT,
    NROFGOODSISSSINCELASTPINVCOUNT,
    NUMBEROFPHYSINVENTORYCOUNTS,
    NUMBEROFPINVADJUSTMENTSPERYEAR,
    PHYSICALINVENTORYITEMISCOUNTED,
    PHYSICALINVENTORYLASTCOUNTDATE,
    PHYSINVTRYFLOATTIMECYCCOUNTING,
    PHYSINVTRYINTVLFORCYCCOUNTING,
    PINVDIFFQTYPERYEARINBASEUNIT,
    PRODUCTGROUP,
    PRODUCTTYPE,
    SEARCHFORVALUATIONTYPE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (CUSTOMER, INVENTORYSPECIALSTOCKTYPE, INVENTORYSTOCKTYPE, MATERIAL, MATERIALBASEUNIT, MATERIALISPOSTEDTOSTOCK, PLANT, REALPRODUCTBATCH, SALESORDER, SALESORDERITEM, STOCKOWNER, STORAGELOCATION, SUPPLIER, WBSELEMENT)
);

Learn More