OIGSPA

Transparent Table Application Table
20 Fields 1 CDS Views

Partner in TD-shipment

OIGSPA is an SAP database table in S/4HANA. Partner in TD-shipment. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BulkShipmentPartner view from BASIC Bulk Shipment Partner

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN SD Document
KEY posnr POSNR Item
KEY parvw PARVW Partner Functn
kunnr KUNNR Customer
lifnr LIFNR Supplier
pernr PERNR_D Personnel No.
parnr PARNR Contact Person
adrnr ADRNR Address
ablad ABLAD Unloading Point
land1 LAND1 Country/Reg.
adrda ADRDA Adress ind.
xcpdk XCPDK One-time acct
hityp HITYP_KH Hierarchy type
prfre PRFRE Price determin.
bokre BOKRE Rebate
histunr HISTUNR Hierarchy level
knref KNREF Partner desc.
lzone LZONE Transport Zone
hzuor HZUOR Hier.assignment

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.

-- Partner in TD-shipment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIGSPA (
    MANDT,    -- Client [MANDT]
    VBELN,    -- SD Document [VBELN]
    POSNR,    -- Item [POSNR]
    PARVW,    -- Partner Functn [PARVW]
    KUNNR,    -- Customer [KUNNR]
    LIFNR,    -- Supplier [LIFNR]
    PERNR,    -- Personnel No. [PERNR_D]
    PARNR,    -- Contact Person [PARNR]
    ADRNR,    -- Address [ADRNR]
    ABLAD,    -- Unloading Point [ABLAD]
    LAND1,    -- Country/Reg. [LAND1]
    ADRDA,    -- Adress ind. [ADRDA]
    XCPDK,    -- One-time acct [XCPDK]
    HITYP,    -- Hierarchy type [HITYP_KH]
    PRFRE,    -- Price determin. [PRFRE]
    BOKRE,    -- Rebate [BOKRE]
    HISTUNR,  -- Hierarchy level [HISTUNR]
    KNREF,    -- Partner desc. [KNREF]
    LZONE,    -- Transport Zone [LZONE]
    HZUOR,    -- Hier.assignment [HZUOR]
    PRIMARY KEY (MANDT, VBELN, POSNR, PARVW)
);

Learn More