_PHYSINVTRYDOCHEADER

12 Fields

_PHYSINVTRYDOCHEADER is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
DocumentDate DocumentDate 1
FiscalPeriod FiscalPeriod 1
InventoryTransactionType InventoryTransactionType 1
PhysicalInventoryDocumentDesc PhysicalInventoryDocumentDesc 1
PhysicalInventoryGroup PhysicalInventoryGroup 1
PhysicalInventoryGroupType PhysicalInventoryGroupType 1
PhysicalInventoryNumber PhysicalInventoryNumber 2
PhysicalInventoryType PhysicalInventoryType 1
PhysInventoryPlannedCountDate PhysInventoryPlannedCountDate 2
PhysInvtryDocHasQtySnapshot PhysInvtryDocHasQtySnapshot 2
PostingIsBlockedForPhysInvtry PostingIsBlockedForPhysInvtry 1
SalesPriceValuationIsActive SalesPriceValuationIsActive 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 _PHYSINVTRYDOCHEADER (
    DOCUMENTDATE,
    FISCALPERIOD,
    INVENTORYTRANSACTIONTYPE,
    PHYSICALINVENTORYDOCUMENTDESC,
    PHYSICALINVENTORYGROUP,
    PHYSICALINVENTORYGROUPTYPE,
    PHYSICALINVENTORYNUMBER,
    PHYSICALINVENTORYTYPE,
    PHYSINVENTORYPLANNEDCOUNTDATE,
    PHYSINVTRYDOCHASQTYSNAPSHOT,
    POSTINGISBLOCKEDFORPHYSINVTRY,
    SALESPRICEVALUATIONISACTIVE
);

Learn More