OIFSPBL_D

Transparent Table Application Table
23 Fields 2 CDS Views

Draft table for entity R_OIL_BUSINESSLOCATIONTP

OIFSPBL_D is an SAP database table in S/4HANA. Draft table for entity R_OIL_BUSINESSLOCATIONTP. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_OIL_BusinessLocationDraft view_entity from EXTENSION Business Location MD - Extension
R_OIL_BusinessLocationDraft view_entity from BASIC Business Location - Draft

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesslocationidentifier OIF_PBLNR Location ID
KEY draftuuid SDRAFT_UUID Draft Document ID
businesslocationidentifiername OIF_PBNAM1 Bus.loc. name
businesslocationtype OIF_PBLTYP Location type
businesslocationaddressnumber OIF_ADNUM Add.No. in ADRC
creationdate OIF_ERDAT Created on
creationtime OIF_ERZEIT Created at
createdbyuser OIF_ERNAM by
lastchangedate OIF_AEDAT Changed on
lastchangetime OIF_AEZEIT Changed at
lastchangedbyuser OIF_AENAM Changed by
entityisblocked OIF_BLOIND Blocked
entityismarkedfordeletion OIF_DELIND Will be Deleted
businesslocationblockingcode OIF_BLCD Closed
maintobjectinternalid J_OBJNR Object number
locationareaassignment OIRB_LAA Loc.a.assign.
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_OIL_BUSINESSLOCATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIFSPBL_D (
    MANDT,                           -- Client [MANDT]
    BUSINESSLOCATIONIDENTIFIER,      -- Location ID [OIF_PBLNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    BUSINESSLOCATIONIDENTIFIERNAME,  -- Bus.loc. name [OIF_PBNAM1]
    BUSINESSLOCATIONTYPE,            -- Location type [OIF_PBLTYP]
    BUSINESSLOCATIONADDRESSNUMBER,   -- Add.No. in ADRC [OIF_ADNUM]
    CREATIONDATE,                    -- Created on [OIF_ERDAT]
    CREATIONTIME,                    -- Created at [OIF_ERZEIT]
    CREATEDBYUSER,                   -- by [OIF_ERNAM]
    LASTCHANGEDATE,                  -- Changed on [OIF_AEDAT]
    LASTCHANGETIME,                  -- Changed at [OIF_AEZEIT]
    LASTCHANGEDBYUSER,               -- Changed by [OIF_AENAM]
    ENTITYISBLOCKED,                 -- Blocked [OIF_BLOIND]
    ENTITYISMARKEDFORDELETION,       -- Will be Deleted [OIF_DELIND]
    BUSINESSLOCATIONBLOCKINGCODE,    -- Closed [OIF_BLCD]
    MAINTOBJECTINTERNALID,           -- Object number [J_OBJNR]
    LOCATIONAREAASSIGNMENT,          -- Loc.a.assign. [OIRB_LAA]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, BUSINESSLOCATIONIDENTIFIER, DRAFTUUID)
);

Learn More