I_DFS_POSITIONPERSONNELSTKDET

CDS View
13 Fields 2 CDS Views

Person Position Stock Detail

I_DFS_POSITIONPERSONNELSTKDET is a CDS View in S/4HANA. Person Position Stock Detail. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ActlFlxMtPlObjIssdQty view_entity inner COMPOSITE Issued Quantity for FMPO
I_DFS_ActlFltgMatlIssdQuantity view_entity from COMPOSITE Issued Quantity for Material

Fields (13)

KeyField CDS FieldsUsed in Views
KEY DfsIssueToPersonnelUsageType DfsIssueToPersonnelUsageType 2
KEY DfsObjectSubType DfsObjectSubType 2
KEY DfsPositionSequenceNumber DfsPositionSequenceNumber 2
KEY EmployeePersonnelNumber EmployeePersonnelNumber 2
KEY EndDate EndDate 2
KEY Material Material 1
KEY Plant Plant 2
KEY StartDate StartDate 2
KEY StorageLocation StorageLocation 2
Batch Batch 2
GoodsIssueQtyInBaseUnit GoodsIssueQtyInBaseUnit 2
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.

-- Person Position Stock Detail
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_POSITIONPERSONNELSTKDET (
    DFSISSUETOPERSONNELUSAGETYPE,
    DFSOBJECTSUBTYPE,
    DFSPOSITIONSEQUENCENUMBER,
    EMPLOYEEPERSONNELNUMBER,
    ENDDATE,
    MATERIAL,
    PLANT,
    STARTDATE,
    STORAGELOCATION,
    BATCH,
    GOODSISSUEQTYINBASEUNIT,
    MATERIALBASEUNIT,
    RETURNQUANTITY,
    PRIMARY KEY (DFSISSUETOPERSONNELUSAGETYPE, DFSOBJECTSUBTYPE, DFSPOSITIONSEQUENCENUMBER, EMPLOYEEPERSONNELNUMBER, ENDDATE, MATERIAL, PLANT, STARTDATE, STORAGELOCATION)
);

Learn More