BUT020SCRPER_DFT

Transparent Table Application Table
72 Fields 1 CDS Views

Draft table for entity I_BUSPARTSCRIPTEDPERSADDRGOVTP

BUT020SCRPER_DFT is an SAP database table in S/4HANA. Draft table for entity I_BUSPARTSCRIPTEDPERSADDRGOVTP. It contains 72 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPScriptedPersAddrGovDraft view_entity from BASIC Draft Access Person Address Version

Fields (72)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY businesspartneraddressuuid sysuuid_x UUID
KEY bpscriptedpersnaddrdrftuuid sysuuid_x UUID
KEY masterdatachangeprocess mdc_process_id Process ID
KEY mdchgprocesssrcesystem mdc_business_system Source System
KEY mdchgprocesssrceobject mdc_source_id Source ID
KEY addressnumber ad_addrnum Address Number
KEY addressrepresentationcode ad_nation Address Version
addrrepresentationcodeforedit ad_nation Address Version
mdchgprocessstep mdc_process_step_no Step Number
validitystartdate bu_addr_valid_from Valid From
validityenddate bu_addr_valid_to Valid To
careofname ad_name_co c/o
additionalstreetsuffixname ad_lctn Street 5
correspondencelanguage spras Language
prfrdcommmediumtype ad_comm Comm. Method
pobox ad_pobx PO Box
poboxiswithoutnumber ad_pobxnum PO Box w/o No.
poboxpostalcode ad_pstcd2 PO Box Post Cde
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.
addresstimezone ad_tzone Time Zone
cityfileteststatus ad_checkst Check Status
addressnondeliverablereason ad_no_uses Undeliverable
postboxnondeliverablereason ad_no_usep Undeliverable
fullname bu_name1tx Full Name
cityname ad_city1 City
districtname ad_city2 District
homecityname ad_city3 Different City
postalcode ad_pstcd1 Postal Code
companypostalcode ad_pstcd3 Company Post Cd
streetname ad_street Street
streetprefixname ad_strspp1 Street 2
additionalstreetprefixname ad_strspp2 Street 3
streetsuffixname ad_strspp3 Street 4
housenumber ad_hsnm1 House Number
housenumbersupplementtext ad_hsnm2 Supplement
building ad_bldng Building Code
floor ad_floor Floor
roomnumber ad_roomnum Room Number
country land1 Country/Reg.
region regio Region
bpcountytext ad_county County
taxjurisdiction ad_txjcd Tax Jurisdiction
transportzone lzone Transport Zone
person ad_persnum Person Number
formofaddress ad_title Title Key
searchterm1 ad_sort1 Search Term 1
searchterm2 ad_sort2 Search Term 2
firstname ad_namefir First Name
lastname ad_namelas Last Name
businesspartnerbirthname ad_name2_p Name at Birth
middlename ad_namemid 2nd First Name
additionallastname ad_namlas2 2nd Family Name
personfullname ad_namtext Full Name
academictitle ad_title1 Academic Title
academictitle2 ad_title2 2nd Academic
lastnameprefix ad_prefix Prefix Key
lastnamesecondprefix ad_prefix2 2nd prefix
businesspartnersupplementname ad_titles Name Supplement
businesspartnernicknamelabel ad_nicknam Nickname
initials ad_inits Initials
nameformat ad_format Name Format
namecountry ad_namctry Country/Region
bpfirstnamesearchhelp ad_mc_nmfi First Name
bplastnamesearchhelp ad_mc_nmla Last Name
masterdataiscurrent abap_boolean Truth Value

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_BUSPARTSCRIPTEDPERSADDRGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT020SCRPER_DFT (
    MANDT,                          -- Client [mandt]
    BUSINESSPARTNERUUID,            -- UUID [sysuuid_x]
    BUSINESSPARTNERADDRESSUUID,     -- UUID [sysuuid_x]
    BPSCRIPTEDPERSNADDRDRFTUUID,    -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,        -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,         -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,         -- Source ID [mdc_source_id]
    ADDRESSNUMBER,                  -- Address Number [ad_addrnum]
    ADDRESSREPRESENTATIONCODE,      -- Address Version [ad_nation]
    ADDRREPRESENTATIONCODEFOREDIT,  -- Address Version [ad_nation]
    MDCHGPROCESSSTEP,               -- Step Number [mdc_process_step_no]
    VALIDITYSTARTDATE,              -- Valid From [bu_addr_valid_from]
    VALIDITYENDDATE,                -- Valid To [bu_addr_valid_to]
    CAREOFNAME,                     -- c/o [ad_name_co]
    ADDITIONALSTREETSUFFIXNAME,     -- Street 5 [ad_lctn]
    CORRESPONDENCELANGUAGE,         -- Language [spras]
    PRFRDCOMMMEDIUMTYPE,            -- Comm. Method [ad_comm]
    POBOX,                          -- PO Box [ad_pobx]
    POBOXISWITHOUTNUMBER,           -- PO Box w/o No. [ad_pobxnum]
    POBOXPOSTALCODE,                -- PO Box Post Cde [ad_pstcd2]
    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]
    ADDRESSTIMEZONE,                -- Time Zone [ad_tzone]
    CITYFILETESTSTATUS,             -- Check Status [ad_checkst]
    ADDRESSNONDELIVERABLEREASON,    -- Undeliverable [ad_no_uses]
    POSTBOXNONDELIVERABLEREASON,    -- Undeliverable [ad_no_usep]
    FULLNAME,                       -- Full Name [bu_name1tx]
    CITYNAME,                       -- City [ad_city1]
    DISTRICTNAME,                   -- District [ad_city2]
    HOMECITYNAME,                   -- Different City [ad_city3]
    POSTALCODE,                     -- Postal Code [ad_pstcd1]
    COMPANYPOSTALCODE,              -- Company Post Cd [ad_pstcd3]
    STREETNAME,                     -- Street [ad_street]
    STREETPREFIXNAME,               -- Street 2 [ad_strspp1]
    ADDITIONALSTREETPREFIXNAME,     -- Street 3 [ad_strspp2]
    STREETSUFFIXNAME,               -- Street 4 [ad_strspp3]
    HOUSENUMBER,                    -- House Number [ad_hsnm1]
    HOUSENUMBERSUPPLEMENTTEXT,      -- Supplement [ad_hsnm2]
    BUILDING,                       -- Building Code [ad_bldng]
    FLOOR,                          -- Floor [ad_floor]
    ROOMNUMBER,                     -- Room Number [ad_roomnum]
    COUNTRY,                        -- Country/Reg. [land1]
    REGION,                         -- Region [regio]
    BPCOUNTYTEXT,                   -- County [ad_county]
    TAXJURISDICTION,                -- Tax Jurisdiction [ad_txjcd]
    TRANSPORTZONE,                  -- Transport Zone [lzone]
    PERSON,                         -- Person Number [ad_persnum]
    FORMOFADDRESS,                  -- Title Key [ad_title]
    SEARCHTERM1,                    -- Search Term 1 [ad_sort1]
    SEARCHTERM2,                    -- Search Term 2 [ad_sort2]
    FIRSTNAME,                      -- First Name [ad_namefir]
    LASTNAME,                       -- Last Name [ad_namelas]
    BUSINESSPARTNERBIRTHNAME,       -- Name at Birth [ad_name2_p]
    MIDDLENAME,                     -- 2nd First Name [ad_namemid]
    ADDITIONALLASTNAME,             -- 2nd Family Name [ad_namlas2]
    PERSONFULLNAME,                 -- Full Name [ad_namtext]
    ACADEMICTITLE,                  -- Academic Title [ad_title1]
    ACADEMICTITLE2,                 -- 2nd Academic [ad_title2]
    LASTNAMEPREFIX,                 -- Prefix Key [ad_prefix]
    LASTNAMESECONDPREFIX,           -- 2nd prefix [ad_prefix2]
    BUSINESSPARTNERSUPPLEMENTNAME,  -- Name Supplement [ad_titles]
    BUSINESSPARTNERNICKNAMELABEL,   -- Nickname [ad_nicknam]
    INITIALS,                       -- Initials [ad_inits]
    NAMEFORMAT,                     -- Name Format [ad_format]
    NAMECOUNTRY,                    -- Country/Region [ad_namctry]
    BPFIRSTNAMESEARCHHELP,          -- First Name [ad_mc_nmfi]
    BPLASTNAMESEARCHHELP,           -- Last Name [ad_mc_nmla]
    MASTERDATAISCURRENT,            -- Truth Value [abap_boolean]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, BUSINESSPARTNERADDRESSUUID, BPSCRIPTEDPERSNADDRDRFTUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER, ADDRESSREPRESENTATIONCODE)
);

Learn More