SDSLS_SORPRTN

Transparent Table Application Table
11 Fields 2 CDS Views

Sales Order Request Partner

SDSLS_SORPRTN is an SAP database table in S/4HANA. Sales Order Request Partner. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SalesOrderReqItemPartner view_entity from BASIC Sales Order Request Item Partner
I_SalesOrderRequestPartner view_entity from BASIC Sales Order Request Partner

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY salesorderrequest sd_sales_order_request Sales Order Request
KEY salesorderrequestitem sd_sales_order_request_item Item
KEY partnerfunction parvw_unv Partner Funct.
customer kunnr Customer
contactperson parnr Contact Person
addressid adrnr Address
addresspersonid adrnp Home address
sddocpartneraddressreftype adrda Adress ind.
bprefaddressidfordocspcfcaddr sdpd_bp_ref_addrnum BP Ref. Address Num.
addressobjecttype ad_adrtype Address Type

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 Request Partner
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SORPRTN (
    MANDT,                          -- Client [mandt]
    SALESORDERREQUEST,              -- Sales Order Request [sd_sales_order_request]
    SALESORDERREQUESTITEM,          -- Item [sd_sales_order_request_item]
    PARTNERFUNCTION,                -- Partner Funct. [parvw_unv]
    CUSTOMER,                       -- Customer [kunnr]
    CONTACTPERSON,                  -- Contact Person [parnr]
    ADDRESSID,                      -- Address [adrnr]
    ADDRESSPERSONID,                -- Home address [adrnp]
    SDDOCPARTNERADDRESSREFTYPE,     -- Adress ind. [adrda]
    BPREFADDRESSIDFORDOCSPCFCADDR,  -- BP Ref. Address Num. [sdpd_bp_ref_addrnum]
    ADDRESSOBJECTTYPE,              -- Address Type [ad_adrtype]
    PRIMARY KEY (MANDT, SALESORDERREQUEST, SALESORDERREQUESTITEM, PARTNERFUNCTION)
);

Learn More