ISLTNCERTPRTN_D

Transparent Table Application Table

Draft table for entity R_ISLTNCERTPARTNERTP

ISLTNCERTPRTN_D is an SAP database table in S/4HANA. Draft table for entity R_ISLTNCERTPARTNERTP. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_IsltnCertificatePartnerDraft view_entity from BASIC Isolation Certificate Partner - Draft

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY maintobjectinternalid J_OBJNR Object number
KEY partnerfunction PARVW_UNV Partner Funct.
KEY maintenancepartnerobjectnumber I_COUNT Counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
isolationcertificate WCEWCNR WC Document
isolationcertificatetype WCEUSAGE Usage
maintenanceplanningplant IWERK Planning Plant
customerresponsible I_PARNR Partner
supplierresponsible I_PARNR Partner
customer KUNNR Customer
personresponsible I_PARNR Partner
contactpersonresponsible I_PARNR Partner
userresponsible I_PARNR Partner
positionresponsible I_PARNR Partner
departmentresponsible I_PARNR Partner
maintenancepartner I_PARNR Partner
maintobjectcategory J_OBTYP Object Type
isltncertpartnerisdeleted KZLOESCH Delete
createdbyuser ERNAM Created By
creationdate ERDAT Created On
creationtime ERZEIT Created At
lastchangedate AEDAT Changed On
lastchangetime AEZEIT Changed At
lastchangedbyuser AENAM Changed By
sddocumentpartnertype NRART Partner Type
bpcustomername CUSTOMERNAME_2 Name of Customer
bpsuppliername SUPPLIERNAME_2 Supplier Name
personresponsiblename abap.char
username AD_NAMTEXT Full Name
contactpersonname AD_NAMTEXT Full Name
hcmemployeepositiontext SHORT_D Object abbr.
hcmorganizationalunittext SHORT_D Object abbr.
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_ISLTNCERTPARTNERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISLTNCERTPRTN_D (
    MANDT,                           -- Client [MANDT]
    MAINTOBJECTINTERNALID,           -- Object number [J_OBJNR]
    PARTNERFUNCTION,                 -- Partner Funct. [PARVW_UNV]
    MAINTENANCEPARTNEROBJECTNUMBER,  -- Counter [I_COUNT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    ISOLATIONCERTIFICATE,            -- WC Document [WCEWCNR]
    ISOLATIONCERTIFICATETYPE,        -- Usage [WCEUSAGE]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    CUSTOMERRESPONSIBLE,             -- Partner [I_PARNR]
    SUPPLIERRESPONSIBLE,             -- Partner [I_PARNR]
    CUSTOMER,                        -- Customer [KUNNR]
    PERSONRESPONSIBLE,               -- Partner [I_PARNR]
    CONTACTPERSONRESPONSIBLE,        -- Partner [I_PARNR]
    USERRESPONSIBLE,                 -- Partner [I_PARNR]
    POSITIONRESPONSIBLE,             -- Partner [I_PARNR]
    DEPARTMENTRESPONSIBLE,           -- Partner [I_PARNR]
    MAINTENANCEPARTNER,              -- Partner [I_PARNR]
    MAINTOBJECTCATEGORY,             -- Object Type [J_OBTYP]
    ISLTNCERTPARTNERISDELETED,       -- Delete [KZLOESCH]
    CREATEDBYUSER,                   -- Created By [ERNAM]
    CREATIONDATE,                    -- Created On [ERDAT]
    CREATIONTIME,                    -- Created At [ERZEIT]
    LASTCHANGEDATE,                  -- Changed On [AEDAT]
    LASTCHANGETIME,                  -- Changed At [AEZEIT]
    LASTCHANGEDBYUSER,               -- Changed By [AENAM]
    SDDOCUMENTPARTNERTYPE,           -- Partner Type [NRART]
    BPCUSTOMERNAME,                  -- Name of Customer [CUSTOMERNAME_2]
    BPSUPPLIERNAME,                  -- Supplier Name [SUPPLIERNAME_2]
    PERSONRESPONSIBLENAME,           -- abap.char
    USERNAME,                        -- Full Name [AD_NAMTEXT]
    CONTACTPERSONNAME,               -- Full Name [AD_NAMTEXT]
    HCMEMPLOYEEPOSITIONTEXT,         -- Object abbr. [SHORT_D]
    HCMORGANIZATIONALUNITTEXT,       -- Object abbr. [SHORT_D]
    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, MAINTOBJECTINTERNALID, PARTNERFUNCTION, MAINTENANCEPARTNEROBJECTNUMBER, DRAFTUUID)
);