_PERSONNELSTOCKDETAILS

10 Fields

_PERSONNELSTOCKDETAILS is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY DfsIssueToPersonnelUsageType DfsIssueToPersonnelUsageType 2
KEY DfsObjectSubType DfsObjectSubType 2
KEY DfsPositionSequenceNumber DfsPositionSequenceNumber 3
KEY EmployeePersonnelNumber EmployeePersonnelNumber 3
KEY EndDate EndDate 3
KEY StartDate StartDate 3
BaseUnit BaseUnit 1
GoodsIssueQtyInBaseUnit GoodsIssueQtyInBaseUnit 3
MaterialBaseUnit MaterialBaseUnit 2
ReturnQuantity ReturnQuantity 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 _PERSONNELSTOCKDETAILS (
    DFSISSUETOPERSONNELUSAGETYPE,
    DFSOBJECTSUBTYPE,
    DFSPOSITIONSEQUENCENUMBER,
    EMPLOYEEPERSONNELNUMBER,
    ENDDATE,
    STARTDATE,
    BASEUNIT,
    GOODSISSUEQTYINBASEUNIT,
    MATERIALBASEUNIT,
    RETURNQUANTITY,
    PRIMARY KEY (DFSISSUETOPERSONNELUSAGETYPE, DFSOBJECTSUBTYPE, DFSPOSITIONSEQUENCENUMBER, EMPLOYEEPERSONNELNUMBER, ENDDATE, STARTDATE)
);

Learn More