KNVV_DFT

Transparent Table Application Table
75 Fields 2 CDS Views

Draft table for entity I_BPCUSTOMERSALESAREAGOVTP

KNVV_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCUSTOMERSALESAREAGOVTP. It contains 75 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPCustomerSalesAreaGovDraft view_entity from EXTENSION BP Customer Sales Area Gov - Extension
R_BPCustomerSalesAreaGovDraft view_entity from BASIC Draft Access BP Customer Sales Area

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesspartneruuid SYSUUID_X UUID
KEY customersalesareauuid 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
mdchgprocessstep MDC_PROCESS_STEP_NO Step Number
bpassignmentid MDG_BP_ASSIGNMENT_ID Assignment ID
customer KUNNR Customer
salesorganizationforedit VKORG Sales Org.
distributionchannelforedit VTWEG Distr. Channel
divisionforedit SPART Division
authorizationgroup BEGRU AuthorizGroup
deletionindicator LOEVM_V Del.ID SlsArea
orderisblockedforcustomer AUFSD_V Ord.blk:sls ar.
bpcustomerpricingprocedure KALKS Cust.Pric.Proc.
customergroup KDGRP Customer Group
salesdistrict BZIRK Sales District
customerpricegroup KONDA CustPrice Group
pricelisttype PLTYP Price List Tp.
itemorderprobabilityinpercent AWAHR Order Probab.
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
deliveryisblocked LIFSD_V DelBlckSalesAr.
completedeliveryisdefined AUTLF Complete Dlv.
maxnmbrofpartialdelivery ANTLF Max.Part.Deliv.
partialdeliveryisallowed KZTLF Part.dlv./item
ordercombinationisallowed KZAZU_D Order Combinat.
deliverypriority LPRIO Delivery Prior.
accountbycustomer EIKTO Acct at Cust.
shippingcondition VSBED Shipping Conditions
productunitgroup MEGRU UoM Group
billingisblockedforcustomer FAKSD_V BBlock for SlsA
manualinvoicemaintisrelevant MRNKZ Man.Inv.Maint.
invccalendardateidentification PERFK Invoicing Dates
invoicelistschedule PERRL Inv.List Sched.
currency WAERS_V02D Currency
customerabcclassification KLABC ABC class
customeraccountassignmentgroup KTGRD AccAssmtGrpCust
customerpaymentterms DZTERM Pyt Terms
supplyingplant DWERK_EXT Deliver.Plant
salesgroup VKGRP Sales Group
salesoffice VKBUR Sales Office
salesitemproposal VSORT Item proposal
additionalcustomergroup1 KVGR1 Customer Grp 1
additionalcustomergroup2 KVGR2 Customer Grp 2
additionalcustomergroup3 KVGR3 Customer Grp 3
additionalcustomergroup4 KVGR4 Customer Grp 4
additionalcustomergroup5 KVGR5 Customer Grp 5
customerisrebaterelevant BOKRE Rebate
exchangeratetype KURST Exch. Rate Type
inspsbsthasnotimeorquantity PRFRE Price determin.
customerpaytguarproced KABSSCH_CM Paym.guar.proc.
creditcontrolarea KKBER Cred.Contr.Area
customersalesareaisblocked BOOLE_D TRUE
suplrisrlvtforsettlmtmgmt AGREL Settlem. Mgmt.
overdelivtolrtdlmtratioinpct UEBTO Overdeliv. Tol.
underdelivtolrtdlmtratioinpct UNTTO Underdel. Tol.
slsunlmtdovrdelivisallwd UEBTK_V Unlimited Tol.
slsdocisrlvtforproofofdeliv PODKZ POD-relevant
proofofdeliverytimevalue CUST_POD POD timeframe
incotermsversion INCOV Inco. Version
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
isbusinesspurposecompleted CVP_XBLCK Purpose Completed
masterdataiscurrent ABAP_BOOLEAN Truth Value
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_BPCUSTOMERSALESAREAGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVV_DFT (
    MANDT,                           -- Client [MANDT]
    BUSINESSPARTNERUUID,             -- UUID [SYSUUID_X]
    CUSTOMERSALESAREAUUID,           -- 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]
    MDCHGPROCESSSTEP,                -- Step Number [MDC_PROCESS_STEP_NO]
    BPASSIGNMENTID,                  -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    CUSTOMER,                        -- Customer [KUNNR]
    SALESORGANIZATIONFOREDIT,        -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNELFOREDIT,      -- Distr. Channel [VTWEG]
    DIVISIONFOREDIT,                 -- Division [SPART]
    AUTHORIZATIONGROUP,              -- AuthorizGroup [BEGRU]
    DELETIONINDICATOR,               -- Del.ID SlsArea [LOEVM_V]
    ORDERISBLOCKEDFORCUSTOMER,       -- Ord.blk:sls ar. [AUFSD_V]
    BPCUSTOMERPRICINGPROCEDURE,      -- Cust.Pric.Proc. [KALKS]
    CUSTOMERGROUP,                   -- Customer Group [KDGRP]
    SALESDISTRICT,                   -- Sales District [BZIRK]
    CUSTOMERPRICEGROUP,              -- CustPrice Group [KONDA]
    PRICELISTTYPE,                   -- Price List Tp. [PLTYP]
    ITEMORDERPROBABILITYINPERCENT,   -- Order Probab. [AWAHR]
    INCOTERMSCLASSIFICATION,         -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [INCO2]
    DELIVERYISBLOCKED,               -- DelBlckSalesAr. [LIFSD_V]
    COMPLETEDELIVERYISDEFINED,       -- Complete Dlv. [AUTLF]
    MAXNMBROFPARTIALDELIVERY,        -- Max.Part.Deliv. [ANTLF]
    PARTIALDELIVERYISALLOWED,        -- Part.dlv./item [KZTLF]
    ORDERCOMBINATIONISALLOWED,       -- Order Combinat. [KZAZU_D]
    DELIVERYPRIORITY,                -- Delivery Prior. [LPRIO]
    ACCOUNTBYCUSTOMER,               -- Acct at Cust. [EIKTO]
    SHIPPINGCONDITION,               -- Shipping Conditions [VSBED]
    PRODUCTUNITGROUP,                -- UoM Group [MEGRU]
    BILLINGISBLOCKEDFORCUSTOMER,     -- BBlock for SlsA [FAKSD_V]
    MANUALINVOICEMAINTISRELEVANT,    -- Man.Inv.Maint. [MRNKZ]
    INVCCALENDARDATEIDENTIFICATION,  -- Invoicing Dates [PERFK]
    INVOICELISTSCHEDULE,             -- Inv.List Sched. [PERRL]
    CURRENCY,                        -- Currency [WAERS_V02D]
    CUSTOMERABCCLASSIFICATION,       -- ABC class [KLABC]
    CUSTOMERACCOUNTASSIGNMENTGROUP,  -- AccAssmtGrpCust [KTGRD]
    CUSTOMERPAYMENTTERMS,            -- Pyt Terms [DZTERM]
    SUPPLYINGPLANT,                  -- Deliver.Plant [DWERK_EXT]
    SALESGROUP,                      -- Sales Group [VKGRP]
    SALESOFFICE,                     -- Sales Office [VKBUR]
    SALESITEMPROPOSAL,               -- Item proposal [VSORT]
    ADDITIONALCUSTOMERGROUP1,        -- Customer Grp 1 [KVGR1]
    ADDITIONALCUSTOMERGROUP2,        -- Customer Grp 2 [KVGR2]
    ADDITIONALCUSTOMERGROUP3,        -- Customer Grp 3 [KVGR3]
    ADDITIONALCUSTOMERGROUP4,        -- Customer Grp 4 [KVGR4]
    ADDITIONALCUSTOMERGROUP5,        -- Customer Grp 5 [KVGR5]
    CUSTOMERISREBATERELEVANT,        -- Rebate [BOKRE]
    EXCHANGERATETYPE,                -- Exch. Rate Type [KURST]
    INSPSBSTHASNOTIMEORQUANTITY,     -- Price determin. [PRFRE]
    CUSTOMERPAYTGUARPROCED,          -- Paym.guar.proc. [KABSSCH_CM]
    CREDITCONTROLAREA,               -- Cred.Contr.Area [KKBER]
    CUSTOMERSALESAREAISBLOCKED,      -- TRUE [BOOLE_D]
    SUPLRISRLVTFORSETTLMTMGMT,       -- Settlem. Mgmt. [AGREL]
    OVERDELIVTOLRTDLMTRATIOINPCT,    -- Overdeliv. Tol. [UEBTO]
    UNDERDELIVTOLRTDLMTRATIOINPCT,   -- Underdel. Tol. [UNTTO]
    SLSUNLMTDOVRDELIVISALLWD,        -- Unlimited Tol. [UEBTK_V]
    SLSDOCISRLVTFORPROOFOFDELIV,     -- POD-relevant [PODKZ]
    PROOFOFDELIVERYTIMEVALUE,        -- POD timeframe [CUST_POD]
    INCOTERMSVERSION,                -- Inco. Version [INCOV]
    INCOTERMSLOCATION1,              -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,              -- Inco. Location2 [INCO3_L]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [CVP_XBLCK]
    MASTERDATAISCURRENT,             -- Truth Value [ABAP_BOOLEAN]
    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, CUSTOMERSALESAREAUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, SALESORGANIZATION, DISTRIBUTIONCHANNEL, DIVISION)
);

Learn More