OIFSMCADDR_D

Transparent Table Application Table
56 Fields 1 CDS Views

Draft table for entity R_OIL_BUSINESSLOCATIONADDRTP

OIFSMCADDR_D is an SAP database table in S/4HANA. Draft table for entity R_OIL_BUSINESSLOCATIONADDRTP. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_OIL_LocationAddressDraft view_entity from BASIC Business Location Address - Draft

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesslocationidentifier OIF_PBLNR Location ID
KEY businesslocationaddressnumber OIF_ADNUM Add.No. in ADRC
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
addressvalidfromdate AD_DATE_FR From
nation AD_NATION Address Version
organizationname1 AD_NAME1 Name
organizationname2 AD_NAME2 Name 2
organizationname3 AD_NAME3 Name 3
organizationname4 AD_NAME4 Name 4
addresssearchterm1 AD_SORT1 Search Term 1
addresssearchterm2 AD_SORT2 Search Term 2
building AD_BLDNG Building Code
floor AD_FLOOR Floor
roomnumber AD_ROOMNUM Room Number
careofname AD_NAME_CO c/o
streetprefixname1 AD_STRSPP1 Street 2
streetprefixname2 AD_STRSPP2 Street 3
streetsuffixname1 AD_STRSPP3 Street 4
streetsuffixname2 AD_LCTN Street 5
housenumber AD_HSNM1 House Number
housenumbersupplementtext AD_HSNM2 Supplement
correspondencelanguage SPRAS Language
cityname AD_CITY1 City
districtname AD_CITY2 District
villagename AD_CITY3 Different City
streetname AD_STREET Street
postalcode AD_PSTCD1 Postal Code
country LAND1 Country/Reg.
region REGIO Region
addresstext AD_REMARK1 Notes
addresstimezone AD_TZONE Time Zone
taxjurisdiction AD_TXJCD Tax Jurisdiction
formofaddress AD_TITLE Title Key
transportzone LZONE Transport Zone
regionalstructuregroup REGIOGROUP Structure Group
streetaddrnondeliverablereason AD_NO_USES Undeliverable
faxareacodesubscribernumber AD_FXNMBR Fax
phonenumber AD_TLNMBR Telephone
mobilenumber AD_TLNMBR Telephone
emailaddress AD_SMTPADR E-Mail Address
poboxaddrnondeliverablereason AD_NO_USEP Undeliverable
poboxiswithoutnumber AD_POBXNUM PO Box w/o No.
poboxlobbyname AD_PO_BOX_LBY PO Box Lobby
poboxdeviatingcityname AD_POBXLOC PO Box City
poboxdeviatingregion AD_POBXREG PO Region
poboxdeviatingcountry AD_POBXCTY PO Box C/R
deliveryservicetypecode AD_DELIVERY_SERVICE_TYPE Delvry Serv Type
deliveryservicenumber AD_DELIVERY_SERVICE_NUMBER Delivery Service No.
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_BUSINESSLOCATIONADDRTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIFSMCADDR_D (
    MANDT,                           -- Client [MANDT]
    BUSINESSLOCATIONIDENTIFIER,      -- Location ID [OIF_PBLNR]
    BUSINESSLOCATIONADDRESSNUMBER,   -- Add.No. in ADRC [OIF_ADNUM]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    ADDRESSVALIDFROMDATE,            -- From [AD_DATE_FR]
    NATION,                          -- Address Version [AD_NATION]
    ORGANIZATIONNAME1,               -- Name [AD_NAME1]
    ORGANIZATIONNAME2,               -- Name 2 [AD_NAME2]
    ORGANIZATIONNAME3,               -- Name 3 [AD_NAME3]
    ORGANIZATIONNAME4,               -- Name 4 [AD_NAME4]
    ADDRESSSEARCHTERM1,              -- Search Term 1 [AD_SORT1]
    ADDRESSSEARCHTERM2,              -- Search Term 2 [AD_SORT2]
    BUILDING,                        -- Building Code [AD_BLDNG]
    FLOOR,                           -- Floor [AD_FLOOR]
    ROOMNUMBER,                      -- Room Number [AD_ROOMNUM]
    CAREOFNAME,                      -- c/o [AD_NAME_CO]
    STREETPREFIXNAME1,               -- Street 2 [AD_STRSPP1]
    STREETPREFIXNAME2,               -- Street 3 [AD_STRSPP2]
    STREETSUFFIXNAME1,               -- Street 4 [AD_STRSPP3]
    STREETSUFFIXNAME2,               -- Street 5 [AD_LCTN]
    HOUSENUMBER,                     -- House Number [AD_HSNM1]
    HOUSENUMBERSUPPLEMENTTEXT,       -- Supplement [AD_HSNM2]
    CORRESPONDENCELANGUAGE,          -- Language [SPRAS]
    CITYNAME,                        -- City [AD_CITY1]
    DISTRICTNAME,                    -- District [AD_CITY2]
    VILLAGENAME,                     -- Different City [AD_CITY3]
    STREETNAME,                      -- Street [AD_STREET]
    POSTALCODE,                      -- Postal Code [AD_PSTCD1]
    COUNTRY,                         -- Country/Reg. [LAND1]
    REGION,                          -- Region [REGIO]
    ADDRESSTEXT,                     -- Notes [AD_REMARK1]
    ADDRESSTIMEZONE,                 -- Time Zone [AD_TZONE]
    TAXJURISDICTION,                 -- Tax Jurisdiction [AD_TXJCD]
    FORMOFADDRESS,                   -- Title Key [AD_TITLE]
    TRANSPORTZONE,                   -- Transport Zone [LZONE]
    REGIONALSTRUCTUREGROUP,          -- Structure Group [REGIOGROUP]
    STREETADDRNONDELIVERABLEREASON,  -- Undeliverable [AD_NO_USES]
    FAXAREACODESUBSCRIBERNUMBER,     -- Fax [AD_FXNMBR]
    PHONENUMBER,                     -- Telephone [AD_TLNMBR]
    MOBILENUMBER,                    -- Telephone [AD_TLNMBR]
    EMAILADDRESS,                    -- E-Mail Address [AD_SMTPADR]
    POBOXADDRNONDELIVERABLEREASON,   -- Undeliverable [AD_NO_USEP]
    POBOXISWITHOUTNUMBER,            -- PO Box w/o No. [AD_POBXNUM]
    POBOXLOBBYNAME,                  -- PO Box Lobby [AD_PO_BOX_LBY]
    POBOXDEVIATINGCITYNAME,          -- PO Box City [AD_POBXLOC]
    POBOXDEVIATINGREGION,            -- PO Region [AD_POBXREG]
    POBOXDEVIATINGCOUNTRY,           -- PO Box C/R [AD_POBXCTY]
    DELIVERYSERVICETYPECODE,         -- Delvry Serv Type [AD_DELIVERY_SERVICE_TYPE]
    DELIVERYSERVICENUMBER,           -- Delivery Service No. [AD_DELIVERY_SERVICE_NUMBER]
    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, BUSINESSLOCATIONADDRESSNUMBER, DRAFTUUID)
);

Learn More