KNA1_DFT

Transparent Table Application Table
64 Fields 1 CDS Views

Draft table for entity I_BPCUSTOMERGOVTP

KNA1_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCUSTOMERGOVTP. It contains 64 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPCustomerGovernanceDraft view_entity from BASIC Access BP Customer

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY masterdatachangeprocess mdc_process_id Process ID
KEY mdchgprocesssrcesystem mdc_business_system Source System
KEY mdchgprocesssrceobject mdc_source_id Source ID
mdchgprocessstep mdc_process_step_no Step Number
bpassignmentid mdg_bp_assignment_id Assignment ID
customer kunnr Customer
orderisblockedforcustomer aufsd_x Order block
expresstrainstationname bahne Express station
trainstationname bahns Train station
authorizationgroup brgru Authorization
billingisblockedforcustomer faksd_x Billing block
fiscaladdress fiskn_d Fiscal address
alternativepayeraccount knrza Alternat. Payer
customercorporategroup konzs Group
customeraccountgroup ktokd Account group
customerclassification kukla Customer Class.
supplier lifnr Supplier
deliveryisblocked lifsd_x Delivery block
deletionindicator loevm_x Deletion Flag
nielsenregion niels Nielsen ID
county counc County Code
citycode cityc City Code
postingisblocked sperb_x Posting Block
vatliability stkzu Liable for VAT
alternativepayeeisallowed xregu Al.payer in doc
industrycode1 bran1_d Industry code 1
industrycode2 bran2 Industry code 2
industrycode3 bran3 Industry code 3
industrycode4 bran4 Industry code 4
industrycode5 bran5 Industry code 5
freedefinedattribute01 katr1 Attribute 1
freedefinedattribute02 katr2 Attribute 2
freedefinedattribute03 katr3 Attribute 3
freedefinedattribute04 katr4 Attribute 4
freedefinedattribute05 katr5 Attribute 5
freedefinedattribute06 katr6 Attribute 6
freedefinedattribute07 katr7 Attribute 7
freedefinedattribute08 katr8 Attribute 8
freedefinedattribute09 katr9 Attribute 9
freedefinedattribute10 katr10 Attribute 10
datamediumexchangeindicator dtams DME Rec. Code
customerconditiongroup1 kdkg1 Condition grp 1
customerconditiongroup2 kdkg2 Condition grp 2
customerconditiongroup3 kdkg3 Condition grp 3
customerconditiongroup4 kdkg4 Condition grp 4
customerconditiongroup5 kdkg5 Condition grp 5
responsibletype j_1afitp_d Tax Type
taxinvoicerepresentativename repres Rep's Name
businesstype gestyp Type of Business
industrytype indtyp Type of Industry
datacontrollerset bu_xdcset Data Ctrlr. Set
datacontroller1 bu_data_controller Data Controller
datacontroller2 bu_data_controller Data Controller
datacontroller3 bu_data_controller Data Controller
datacontroller4 bu_data_controller Data Controller
datacontroller5 bu_data_controller Data Controller
datacontroller6 bu_data_controller Data Controller
datacontroller7 bu_data_controller Data Controller
datacontroller8 bu_data_controller Data Controller
datacontroller9 bu_data_controller Data Controller
datacontroller10 bu_data_controller Data Controller
mdchgprocesssourcemodified mdc_source_modified Modified

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_BPCUSTOMERGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNA1_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]
    BPASSIGNMENTID,                -- Assignment ID [mdg_bp_assignment_id]
    CUSTOMER,                      -- Customer [kunnr]
    ORDERISBLOCKEDFORCUSTOMER,     -- Order block [aufsd_x]
    EXPRESSTRAINSTATIONNAME,       -- Express station [bahne]
    TRAINSTATIONNAME,              -- Train station [bahns]
    AUTHORIZATIONGROUP,            -- Authorization [brgru]
    BILLINGISBLOCKEDFORCUSTOMER,   -- Billing block [faksd_x]
    FISCALADDRESS,                 -- Fiscal address [fiskn_d]
    ALTERNATIVEPAYERACCOUNT,       -- Alternat. Payer [knrza]
    CUSTOMERCORPORATEGROUP,        -- Group [konzs]
    CUSTOMERACCOUNTGROUP,          -- Account group [ktokd]
    CUSTOMERCLASSIFICATION,        -- Customer Class. [kukla]
    SUPPLIER,                      -- Supplier [lifnr]
    DELIVERYISBLOCKED,             -- Delivery block [lifsd_x]
    DELETIONINDICATOR,             -- Deletion Flag [loevm_x]
    NIELSENREGION,                 -- Nielsen ID [niels]
    COUNTY,                        -- County Code [counc]
    CITYCODE,                      -- City Code [cityc]
    POSTINGISBLOCKED,              -- Posting Block [sperb_x]
    VATLIABILITY,                  -- Liable for VAT [stkzu]
    ALTERNATIVEPAYEEISALLOWED,     -- Al.payer in doc [xregu]
    INDUSTRYCODE1,                 -- Industry code 1 [bran1_d]
    INDUSTRYCODE2,                 -- Industry code 2 [bran2]
    INDUSTRYCODE3,                 -- Industry code 3 [bran3]
    INDUSTRYCODE4,                 -- Industry code 4 [bran4]
    INDUSTRYCODE5,                 -- Industry code 5 [bran5]
    FREEDEFINEDATTRIBUTE01,        -- Attribute 1 [katr1]
    FREEDEFINEDATTRIBUTE02,        -- Attribute 2 [katr2]
    FREEDEFINEDATTRIBUTE03,        -- Attribute 3 [katr3]
    FREEDEFINEDATTRIBUTE04,        -- Attribute 4 [katr4]
    FREEDEFINEDATTRIBUTE05,        -- Attribute 5 [katr5]
    FREEDEFINEDATTRIBUTE06,        -- Attribute 6 [katr6]
    FREEDEFINEDATTRIBUTE07,        -- Attribute 7 [katr7]
    FREEDEFINEDATTRIBUTE08,        -- Attribute 8 [katr8]
    FREEDEFINEDATTRIBUTE09,        -- Attribute 9 [katr9]
    FREEDEFINEDATTRIBUTE10,        -- Attribute 10 [katr10]
    DATAMEDIUMEXCHANGEINDICATOR,   -- DME Rec. Code [dtams]
    CUSTOMERCONDITIONGROUP1,       -- Condition grp 1 [kdkg1]
    CUSTOMERCONDITIONGROUP2,       -- Condition grp 2 [kdkg2]
    CUSTOMERCONDITIONGROUP3,       -- Condition grp 3 [kdkg3]
    CUSTOMERCONDITIONGROUP4,       -- Condition grp 4 [kdkg4]
    CUSTOMERCONDITIONGROUP5,       -- Condition grp 5 [kdkg5]
    RESPONSIBLETYPE,               -- Tax Type [j_1afitp_d]
    TAXINVOICEREPRESENTATIVENAME,  -- Rep's Name [repres]
    BUSINESSTYPE,                  -- Type of Business [gestyp]
    INDUSTRYTYPE,                  -- Type of Industry [indtyp]
    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]
    MDCHGPROCESSSOURCEMODIFIED,    -- Modified [mdc_source_modified]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT)
);

Learn More