V_OIFSPBL

27 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_VisualLocations view left_outer COMPOSITE Location Master Data

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pblnr OIF_PBLNR Location ID
name1 OIF_PBNAM1 Bus.loc. name
pbltyp OIF_PBLTYP Location type
addrnum OIF_ADNUM Add.No. in ADRC
erdat OIF_ERDAT Created on
erzeit OIF_ERZEIT Created at
ernam OIF_ERNAM by
aedat OIF_AEDAT Changed on
aezeit OIF_AEZEIT Changed at
aenam OIF_AENAM Changed by
bloind OIF_BLOIND Blocked
delind OIF_DELIND Will be Deleted
blcode OIF_BLCD Closed
objnr J_OBJNR Object number
brand OIRB_BRAND Brand
locvalue OIRB_VAL Rel. loc. value
locvdiff OIRB_LOCVDIFF Differentiator
locaa OIRB_LAA Loc.a.assign.
locmp OIRC_KALKS Loc.marg. proc.
pcgroup OIRA_PCG Proc.contr.grp.
autgr OIRB_AUTGR Authorization
valgp OIREVALGROUP ValGrp
bukrs BUKRS Company Code
oiripgrp OIRI_PGRP SD/FI Pst.Grp.
convgr OIRH_CONVGR Conv.group
logsys OIRH_LOGSYS Logical system

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 V_OIFSPBL (
    MANDT,     -- Client [MANDT]
    PBLNR,     -- Location ID [OIF_PBLNR]
    NAME1,     -- Bus.loc. name [OIF_PBNAM1]
    PBLTYP,    -- Location type [OIF_PBLTYP]
    ADDRNUM,   -- Add.No. in ADRC [OIF_ADNUM]
    ERDAT,     -- Created on [OIF_ERDAT]
    ERZEIT,    -- Created at [OIF_ERZEIT]
    ERNAM,     -- by [OIF_ERNAM]
    AEDAT,     -- Changed on [OIF_AEDAT]
    AEZEIT,    -- Changed at [OIF_AEZEIT]
    AENAM,     -- Changed by [OIF_AENAM]
    BLOIND,    -- Blocked [OIF_BLOIND]
    DELIND,    -- Will be Deleted [OIF_DELIND]
    BLCODE,    -- Closed [OIF_BLCD]
    OBJNR,     -- Object number [J_OBJNR]
    BRAND,     -- Brand [OIRB_BRAND]
    LOCVALUE,  -- Rel. loc. value [OIRB_VAL]
    LOCVDIFF,  -- Differentiator [OIRB_LOCVDIFF]
    LOCAA,     -- Loc.a.assign. [OIRB_LAA]
    LOCMP,     -- Loc.marg. proc. [OIRC_KALKS]
    PCGROUP,   -- Proc.contr.grp. [OIRA_PCG]
    AUTGR,     -- Authorization [OIRB_AUTGR]
    VALGP,     -- ValGrp [OIREVALGROUP]
    BUKRS,     -- Company Code [BUKRS]
    OIRIPGRP,  -- SD/FI Pst.Grp. [OIRI_PGRP]
    CONVGR,    -- Conv.group [OIRH_CONVGR]
    LOGSYS,    -- Logical system [OIRH_LOGSYS]
    PRIMARY KEY (MANDT, PBLNR)
);

Learn More