SDSLS_SOFI

Transparent Table Application Table
25 Fields 1 CDS Views

Sales Order Fullfiment Issue

SDSLS_SOFI is an SAP database table in S/4HANA. Sales Order Fullfiment Issue. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsDocFulfillmentIssue view_entity from BASIC Sales Order Fulfillment Issue

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY salesdocument vbeln_va Sales Document
KEY salesdocumentitem posnr_va Item
KEY issue issue_sofi
KEY issuedocument issuedocument_sof
KEY issuedocumentitem issuedocumentitemitem_sof
deliverydocument outbound_delivery Outbound Delivery
deliverydocumentitem outbound_delivery_item Outb. Delivery Item
billingdocument vbeln_vf Billing Doc.
billingdocumentitem posnr_vf Item
purchasingdocument vdm_purchaseorder Purchase Order
purchasingdocumentitem vdm_purchaseorderitem Purchase Order Item
manufacturingorder manufacturingorder Manufacturing Order
manufacturingorderitem manufacturingorderitem Manufacturing Order Item
issuecategory issue_cat Issue Category
duedate due_date_sof Due Date
issueprocessingstatus issueprocessingstatus_sof
salessddocumentcategory vbtypl Document Cat.
issuedocumentcategory issuedocumentcategory_sof
salesorganization vkorg Sales Org.
distributionchannel vtweg Distr. Channel
organizationdivision spart Division
salesdocumenttype auart Sales Doc. Type
lastchangedby changd_by Changed By
lastchangeddatetime last_changed_date_time Last Changed On

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.

-- Sales Order Fullfiment Issue
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SOFI (
    MANDT,                    -- Client [mandt]
    SALESDOCUMENT,            -- Sales Document [vbeln_va]
    SALESDOCUMENTITEM,        -- Item [posnr_va]
    ISSUE,                    -- issue_sofi
    ISSUEDOCUMENT,            -- issuedocument_sof
    ISSUEDOCUMENTITEM,        -- issuedocumentitemitem_sof
    DELIVERYDOCUMENT,         -- Outbound Delivery [outbound_delivery]
    DELIVERYDOCUMENTITEM,     -- Outb. Delivery Item [outbound_delivery_item]
    BILLINGDOCUMENT,          -- Billing Doc. [vbeln_vf]
    BILLINGDOCUMENTITEM,      -- Item [posnr_vf]
    PURCHASINGDOCUMENT,       -- Purchase Order [vdm_purchaseorder]
    PURCHASINGDOCUMENTITEM,   -- Purchase Order Item [vdm_purchaseorderitem]
    MANUFACTURINGORDER,       -- Manufacturing Order [manufacturingorder]
    MANUFACTURINGORDERITEM,   -- Manufacturing Order Item [manufacturingorderitem]
    ISSUECATEGORY,            -- Issue Category [issue_cat]
    DUEDATE,                  -- Due Date [due_date_sof]
    ISSUEPROCESSINGSTATUS,    -- issueprocessingstatus_sof
    SALESSDDOCUMENTCATEGORY,  -- Document Cat. [vbtypl]
    ISSUEDOCUMENTCATEGORY,    -- issuedocumentcategory_sof
    SALESORGANIZATION,        -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,      -- Distr. Channel [vtweg]
    ORGANIZATIONDIVISION,     -- Division [spart]
    SALESDOCUMENTTYPE,        -- Sales Doc. Type [auart]
    LASTCHANGEDBY,            -- Changed By [changd_by]
    LASTCHANGEDDATETIME,      -- Last Changed On [last_changed_date_time]
    PRIMARY KEY (MANDT, SALESDOCUMENT, SALESDOCUMENTITEM, ISSUE, ISSUEDOCUMENT, ISSUEDOCUMENTITEM)
);

Learn More