P_STL_DOC_DTLS

24 Fields 1 CDS Views

Generated Table for View

P_STL_DOC_DTLS is an SAP database table in S/4HANA. Generated Table for View. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ACCGO_APPDOC_DTLS view left_outer BASIC

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY settl_doc /ACCGO/E_SETTL_DOC Settlement Unit
KEY settl_yr /ACCGO/E_SETTL_YR Setl Unit Year
settl_cat /ACCGO/E_SETTL_CAT Document Category
settl_type /ACCGO/E_STL_TYP Settlement Type
settl_side WLF_PR_SIDE Side
appl_guid /ACCGO/E_APPL_GUID Application GUID
appl_version /ACCGO/E_APPL_VERSION Application Version
doc_typ /ACCGO/E_DOC_TYP CAS Document Type
settl_scenario /ACCGO/E_SETTL_SCENARIO Settl Scenario
side WLF_PR_SIDE Side
appldoc /ACCGO/E_APPLDOC Appl. Document No.
appldoc_item /ACCGO/E_APPLDOC_ITEM_NUM Item No.
settl_item /ACCGO/E_SETTL_ITEM Settl. Item
full_ship_qty /ACCGO/E_QUAN_FULL_SHIP Full Shipment Qty
tot_quantity_adj /ACCGO/E_Q_ADJUST Quantity Adjustment
adj_uom /ACCGO/E_MEINS Per Unit
doc_curr WAERS Currency
unit_quantity /ACCGO/E_QUAN_UNIT Quantity in Base UoM
unit_uom /ACCGO/E_PER_MEINS Per Unit UoM
contract_qty /ACCGO/E_CONTRACT_QTY Qty in Contract UoM
contract_uom /ACCGO/E_CONTRACT_UOM Contract UoM
document_qty /ACCGO/E_DOCUMENT_QTY Quantity in Doc UoM
document_uom /ACCGO/E_DOCUMENT_UOM Document UoM

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_STL_DOC_DTLS (
    MANDT,             -- Client [MANDT]
    SETTL_DOC,         -- Settlement Unit [/ACCGO/E_SETTL_DOC]
    SETTL_YR,          -- Setl Unit Year [/ACCGO/E_SETTL_YR]
    SETTL_CAT,         -- Document Category [/ACCGO/E_SETTL_CAT]
    SETTL_TYPE,        -- Settlement Type [/ACCGO/E_STL_TYP]
    SETTL_SIDE,        -- Side [WLF_PR_SIDE]
    APPL_GUID,         -- Application GUID [/ACCGO/E_APPL_GUID]
    APPL_VERSION,      -- Application Version [/ACCGO/E_APPL_VERSION]
    DOC_TYP,           -- CAS Document Type [/ACCGO/E_DOC_TYP]
    SETTL_SCENARIO,    -- Settl Scenario [/ACCGO/E_SETTL_SCENARIO]
    SIDE,              -- Side [WLF_PR_SIDE]
    APPLDOC,           -- Appl. Document No. [/ACCGO/E_APPLDOC]
    APPLDOC_ITEM,      -- Item No. [/ACCGO/E_APPLDOC_ITEM_NUM]
    SETTL_ITEM,        -- Settl. Item [/ACCGO/E_SETTL_ITEM]
    FULL_SHIP_QTY,     -- Full Shipment Qty [/ACCGO/E_QUAN_FULL_SHIP]
    TOT_QUANTITY_ADJ,  -- Quantity Adjustment [/ACCGO/E_Q_ADJUST]
    ADJ_UOM,           -- Per Unit [/ACCGO/E_MEINS]
    DOC_CURR,          -- Currency [WAERS]
    UNIT_QUANTITY,     -- Quantity in Base UoM [/ACCGO/E_QUAN_UNIT]
    UNIT_UOM,          -- Per Unit UoM [/ACCGO/E_PER_MEINS]
    CONTRACT_QTY,      -- Qty in Contract UoM [/ACCGO/E_CONTRACT_QTY]
    CONTRACT_UOM,      -- Contract UoM [/ACCGO/E_CONTRACT_UOM]
    DOCUMENT_QTY,      -- Quantity in Doc UoM [/ACCGO/E_DOCUMENT_QTY]
    DOCUMENT_UOM,      -- Document UoM [/ACCGO/E_DOCUMENT_UOM]
    PRIMARY KEY (MANDT, SETTL_DOC, SETTL_YR)
);

Learn More