BUT000_DFT

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 I_BUSINESSPARTNERGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT000_DFT (
    MANDT,                           -- Client [mandt]
    BUSINESSPARTNERUUID,             -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,         -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,          -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,          -- Source ID [mdc_source_id]
    MDCHGPROCESSSTEP,                -- Step Number [mdc_process_step_no]
    MASTERDATACHANGEPROCESSFOREDIT,  -- Process ID [mdc_process_id]
    MDCHANGEPROCESSNUMBERDISPLAY,    -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCEOBJECTTYPECODE,  -- Bus. Obj. Type [mdc_object_type_code]
    MDCHGPROCESSGOAL,                -- Process Goal [mdc_process_goal]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    BUSINESSPARTNERCATEGORY,         -- Partner Cat. [bu_type]
    AUTHORIZATIONGROUP,              -- Authorization Group [bu_augrp]
    PERSONNUMBER,                    -- Person Number [ad_persnum]
    ETAG,                            -- Update Token [mdc_process_update_token]
    MDCHGPROCESSISSTARTED,           -- Process Started [mdc_process_started_indicator]
    MDCHGPROCESSISIDLE,              -- Truth Value [abap_boolean]
    BUSINESSPARTNERNAME,             -- abap.char
    BUSINESSPARTNERFULLNAME,         -- abap.char
    CREATEDBYUSER,                   -- Created by [bu_crusr]
    CREATIONDATE,                    -- Created On [bu_crdat]
    CREATIONTIME,                    -- Created at [bu_crtim]
    LASTCHANGEDBYUSER,               -- Changed by [bu_chusr]
    LASTCHANGEDATE,                  -- Changed on [bu_chdat]
    LASTCHANGETIME,                  -- Changed at [bu_chtim]
    BUSINESSPARTNERISBLOCKED,        -- Central Block [bu_xblck]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [bu_xpcpt]
    ORGANIZATIONBPNAME1,             -- Name 1 [bu_nameor1]
    ORGANIZATIONBPNAME2,             -- Name 2 [bu_nameor2]
    ORGANIZATIONBPNAME3,             -- Name 3 [bu_nameor3]
    ORGANIZATIONBPNAME4,             -- Name 4 [bu_nameor4]
    INTERNATIONALLOCATIONNUMBER1,    -- Location no. 1 [bu_location1str]
    INTERNATIONALLOCATIONNUMBER2,    -- Location no. 2 [bu_location2str]
    INTERNATIONALLOCATIONNUMBER3,    -- Check digit [bu_location3str]
    LEGALFORM,                       -- Legal form [bu_legenty]
    ORGANIZATIONFOUNDATIONDATE,      -- Date founded [bu_found_dat]
    ORGANIZATIONLIQUIDATIONDATE,     -- Liquidation [bu_liquid_dat]
    INDUSTRY,                        -- Industry sector [bu_indsect]
    FORMOFADDRESSPERSON,             -- Title Key [ad_title]
    FORMOFADDRESSORGANIZATION,       -- Title Key [ad_title]
    FORMOFADDRESSGROUP,              -- Title Key [ad_title]
    FORMOFADDRESS,                   -- Title Key [ad_title]
    BUSINESSPARTNERGROUPING,         -- Grouping [bu_group]
    BUSINESSPARTNERTYPE,             -- Partner Type [bu_bpkind]
    BUSINESSPARTNERPRINTFORMAT,      -- Print Format [bu_print_mode]
    BUSINESSPARTNERDATAORIGINTYPE,   -- Data Origin [bu_source]
    SEARCHTERM1,                     -- Search Term 1 [bu_sort1]
    SEARCHTERM2,                     -- Search Term 2 [bu_sort2]
    BPLASTNAMESEARCHHELP,            -- Name 1/Last Nme [bu_mcname1]
    BPFIRSTNAMESEARCHHELP,           -- Name2/First Nme [bu_mcname2]
    INDEPENDENTADDRESSID,            -- Address Number [bu_addrcomm]
    ISMARKEDFORARCHIVING,            -- Archiving Flag [bu_xdele]
    CONTACTPERMISSION,               -- Contact [bu_contact]
    LEGALENTITYOFORGANIZATION,       -- Legal entity [bu_legal_org]
    BUSINESSPARTNERISNOTRELEASED,    -- Not released [bu_xnot_released]
    ISNOTCONTRACTUALLYCAPABLE,       -- Not Legally Competnt [bu_not_leg_competent]
    ACTIVEAUTHORIZATIONGROUP,        -- Authorization Group [bu_augrp]
    CORRESPONDENCELANGUAGE,          -- Correspondence Lang. [bu_langu_corr]
    BPPERSONDATAISDISPLAYED,         -- TRUE [boole_d]
    BUSPARTPERSONDATAISHIDDEN,       -- TRUE [boole_d]
    BUSPARTORGDATAISHIDDEN,          -- TRUE [boole_d]
    BUSPARTGROUPDATAISHIDDEN,        -- TRUE [boole_d]
    BUSPARTADDRLANGUAGEISHIDDEN,     -- TRUE [boole_d]
    ISFEMALE,                        -- Female [bu_xsexf]
    ISMALE,                          -- Male [bu_xsexm]
    ISSEXUNKNOWN,                    -- Unknown [bu_xsexu]
    GENDERCODENAME,                  -- Sex [bu_sexid]
    FIRSTNAME,                       -- First Name [bu_namep_f]
    LASTNAME,                        -- Last Name [bu_namep_l]
    ADDITIONALNAME,                  -- abap.char
    ADDITIONALLASTNAME,              -- Other Last Name [bu_namepl2]
    BUSINESSPARTNERBIRTHNAME,        -- Name at Birth [bu_birthnm]
    MIDDLENAME,                      -- Middle Name [bu_namemid]
    ACADEMICTITLE,                   -- Academic Title [ad_title1]
    ACADEMICTITLE2,                  -- 2nd Academic [ad_title2]
    BUSINESSPARTNERSUPPLEMENTNAME,   -- Name Supplement [ad_titles]
    LASTNAMEPREFIX,                  -- Prefix Key [ad_prefix]
    LASTNAMESECONDPREFIX,            -- 2nd prefix [ad_prefix2]
    PERSONFULLNAME,                  -- Full Name [bu_name1tx]
    BUSINESSPARTNERNICKNAMELABEL,    -- Known As [bu_nicknam]
    INITIALS,                        -- Initials [ad_inits]
    NAMEFORMAT,                      -- Name Format [ad_format]
    NAMECOUNTRY,                     -- Country/Region [ad_namctry]
    LANGUAGE,                        -- Language [bu_langu]
    ISNATURALPERSON,                 -- Natural Person [bu_natural_person]
    BIRTHDATE,                       -- Date of Birth [bu_birthdt]
    BUSINESSPARTNERBIRTHPLACENAME,   -- Birthplace [bu_birthpl]
    BUSINESSPARTNERDEATHDATE,        -- Death date [bu_deathdt]
    BUSINESSPARTNERBIRTHDATESTATUS,  -- Birth Date Status [bu_birthdt_status]
    NATURALPERSONEMPLOYERNAME,       -- Employer [bu_emplo]
    BUSINESSPARTNEROCCUPATION,       -- Occupation [bu_jobgr]
    BUSPARTMARITALSTATUS,            -- Marital Status [bu_marst]
    BUSPARTNATIONALITY,              -- Nationality [bu_natio]
    BUSINESSPARTNERIDBYEXTSYSTEM,    -- External Number [bu_bpext]
    NONRESIDENTCOMPANYORIGINCNTRY,   -- C/R of Origin [bu_cndsc]
    GROUPBUSINESSPARTNERNAME1,       -- Name 1 [bu_namegr1]
    GROUPBUSINESSPARTNERNAME2,       -- Name 2 [bu_namegr2]
    BUSINESSPARTNERGROUPTYPE,        -- Group type [bu_grptyp]
    MDCHGBPRELSHPHASCHANGED,         -- TRUE [boole_d]
    DATACONTROLLERSET,               -- Data Ctrlr. Set [bu_xdcset]
    DATACONTROLLER1,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER2,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER3,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER4,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER5,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER6,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER7,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER8,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER9,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER10,                -- Data Controller [bu_data_controller]
    BPDATACONTROLLERISNOTREQUIRED,   -- DC Not Required [bu_dc_not_req]
    ORIGIN,                          -- abap.char
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT)
);