KNVP_DFT

Transparent Table Application Table
32 Fields 1 CDS Views

Draft table for entity I_BPCUSTPARTNERFUNCTIONGOVTP

KNVP_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCUSTPARTNERFUNCTIONGOVTP. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPCustPrtnFunctionGovDraft view_entity from BASIC Draft Access Cust Partner Function

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY customersalesareauuid sysuuid_x UUID
KEY custpartnerfunctionuuid 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 salesorganization vkorg Sales Org.
KEY distributionchannel vtweg Distr. Channel
KEY division spart Division
KEY partnerfunction parvw_unv Partner Funct.
KEY partnercounter parza Partner counter
mdchgprocessstep mdc_process_step_no Step Number
bpassignmentid mdg_bp_assignment_id Assignment ID
customer kunnr Customer
partnerfunctiontype nrart Partner Type
salesorganizationforedit vkorg Sales Org.
distributionchannelforedit vtweg Distr. Channel
divisionforedit spart Division
partnerfunctionforedit parvw_unv Partner Funct.
partnercounterforedit parza Partner counter
partnerfunctionlanguagedepdnt pabez Lang-spec.partr
bpcustomernumber kunn2 Customer
supplier lifnr Supplier
personnelnumber pernr_d Personnel No.
contactperson parnr Contact Person
customerpartnerdescription knref Partner desc.
defaultpartner defpa Default Partner
partnerfunctionpartnernumber kunn2 Customer
assgdpartnerisbusinesspartner xfeld Checkbox
addressid bu_addrnum Address Number
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_BPCUSTPARTNERFUNCTIONGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVP_DFT (
    MANDT,                          -- Client [mandt]
    BUSINESSPARTNERUUID,            -- UUID [sysuuid_x]
    CUSTOMERSALESAREAUUID,          -- UUID [sysuuid_x]
    CUSTPARTNERFUNCTIONUUID,        -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,        -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,         -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,         -- Source ID [mdc_source_id]
    SALESORGANIZATION,              -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,            -- Distr. Channel [vtweg]
    DIVISION,                       -- Division [spart]
    PARTNERFUNCTION,                -- Partner Funct. [parvw_unv]
    PARTNERCOUNTER,                 -- Partner counter [parza]
    MDCHGPROCESSSTEP,               -- Step Number [mdc_process_step_no]
    BPASSIGNMENTID,                 -- Assignment ID [mdg_bp_assignment_id]
    CUSTOMER,                       -- Customer [kunnr]
    PARTNERFUNCTIONTYPE,            -- Partner Type [nrart]
    SALESORGANIZATIONFOREDIT,       -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNELFOREDIT,     -- Distr. Channel [vtweg]
    DIVISIONFOREDIT,                -- Division [spart]
    PARTNERFUNCTIONFOREDIT,         -- Partner Funct. [parvw_unv]
    PARTNERCOUNTERFOREDIT,          -- Partner counter [parza]
    PARTNERFUNCTIONLANGUAGEDEPDNT,  -- Lang-spec.partr [pabez]
    BPCUSTOMERNUMBER,               -- Customer [kunn2]
    SUPPLIER,                       -- Supplier [lifnr]
    PERSONNELNUMBER,                -- Personnel No. [pernr_d]
    CONTACTPERSON,                  -- Contact Person [parnr]
    CUSTOMERPARTNERDESCRIPTION,     -- Partner desc. [knref]
    DEFAULTPARTNER,                 -- Default Partner [defpa]
    PARTNERFUNCTIONPARTNERNUMBER,   -- Customer [kunn2]
    ASSGDPARTNERISBUSINESSPARTNER,  -- Checkbox [xfeld]
    ADDRESSID,                      -- Address Number [bu_addrnum]
    MASTERDATAISCURRENT,            -- Truth Value [abap_boolean]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, CUSTOMERSALESAREAUUID, CUSTPARTNERFUNCTIONUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, SALESORGANIZATION, DISTRIBUTIONCHANNEL, DIVISION, PARTNERFUNCTION, PARTNERCOUNTER)
);

Learn More