STCKDET

13 Fields

STCKDET is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 1
KEY IssueDate IssueDate 1
KEY IssueType IssueType 1
KEY Material Material 1
KEY MaterialGroup MaterialGroup 1
KEY Plant Plant 1
KEY ReferenceDocumentScheduleLine ReferenceDocumentScheduleLine 1
KEY SalesDocument SalesDocument 1
KEY SalesDocumentItem SalesDocumentItem 1
IssueAmount IssueAmount 1
IssueQuantity IssueQuantity 1
OrderPriceUnit OrderPriceUnit 1
QuantityUnit QuantityUnit 1

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 STCKDET (
    BATCH,
    ISSUEDATE,
    ISSUETYPE,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    REFERENCEDOCUMENTSCHEDULELINE,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    ISSUEAMOUNT,
    ISSUEQUANTITY,
    ORDERPRICEUNIT,
    QUANTITYUNIT,
    PRIMARY KEY (BATCH, ISSUEDATE, ISSUETYPE, MATERIAL, MATERIALGROUP, PLANT, REFERENCEDOCUMENTSCHEDULELINE, SALESDOCUMENT, SALESDOCUMENTITEM)
);

Learn More