KNA1_DFT

Transparent Table Application Table
70 Fields 2 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 70 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPCustomerGovernanceDraft view_entity from EXTENSION BP Customer Governance - Extension
R_BPCustomerGovernanceDraft view_entity from BASIC Access BP Customer

Fields (70)

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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field 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 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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT)
);

Learn More