CUST_SLSAREA_D

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_CUSTOMERSALESAREATP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUST_SLSAREA_D (
    MANDT,                           -- Client [mandt]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    CUSTOMER,                        -- Customer [kunnr]
    SALESORGANIZATION,               -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [vtweg]
    DIVISION,                        -- Division [spart]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    BUSINESSPARTNERFOREDIT,          -- Busn. Partner [bu_partner]
    SALESORGANIZATIONFOREDIT,        -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNELFOREDIT,      -- Distr. Channel [vtweg]
    DIVISIONFOREDIT,                 -- Division [spart]
    BUSINESSPARTNERUUID,             -- BP GUID [bu_partner_guid]
    CUSTOMERGROUP,                   -- Customer Group [kdgrp]
    SALESOFFICE,                     -- Sales Office [vkbur]
    SALESGROUP,                      -- Sales Group [vkgrp]
    ACCOUNTBYCUSTOMER,               -- Acct at Cust. [eikto]
    CUSTOMERABCCLASSIFICATION,       -- ABC class [klabc]
    CURRENCY,                        -- Currency [waers_v02d]
    CUSTOMERPRICEGROUP,              -- CustPrice Group [konda]
    BPCUSTOMERPRICINGPROCEDURE,      -- Cust.Pric.Proc. [kalks]
    DELIVERYPRIORITY,                -- Delivery Prior. [lprio]
    ORDERCOMBINATIONISALLOWED,       -- Order Combinat. [kzazu_d]
    SHIPPINGCONDITION,               -- Shipping Conditions [vsbed]
    SUPPLYINGPLANT,                  -- Deliver.Plant [dwerk_ext]
    DELIVBLKDFORCUSTSLSAREA,         -- DelBlckSalesAr. [lifsd_v]
    BILLINGISBLOCKEDFORCUSTOMER,     -- BBlock for SlsA [faksd_v]
    COMPLETEDELIVERYISDEFINED,       -- Complete Dlv. [autlf]
    PARTIALDELIVERYISALLOWED,        -- Part.dlv./item [kztlf]
    BPFACTORYCALENDARID,             -- Invoicing Dates [perfk]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [inco2]
    CUSTOMERPAYMENTTERMS,            -- Pyt Terms [dzterm]
    CUSTOMERACCOUNTASSIGNMENTGROUP,  -- AccAssmtGrpCust [ktgrd]
    SALESDISTRICT,                   -- Sales District [bzirk]
    ORDERISBLOCKEDFORCUSTOMER,       -- Ord.blk:sls ar. [aufsd_v]
    PRICELISTTYPE,                   -- Price List Tp. [pltyp]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    AUTHORIZATIONGROUP,              -- AuthorizGroup [begru]
    CUSTOMERPAYTGUARPROCED,          -- Paym.guar.proc. [kabssch_cm]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [cvp_xblck]
    INVOICELISTSCHEDULE,             -- Inv.List Sched. [perrl]
    EXCHANGERATETYPE,                -- Exch. Rate Type [kurst]
    ITEMORDERPROBABILITYINPERCENT,   -- Order Probab. [awahr]
    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]
    UNDERDELIVTOLRTDLMTRATIOINPCT,   -- Underdel. Tol. [untto]
    OVERDELIVTOLRTDLMTRATIOINPCT,    -- Overdeliv. Tol. [uebto]
    MAXNMBROFPARTIALDELIVERY,        -- Max.Part.Deliv. [antlf]
    SUPLRISRLVTFORSETTLMTMGMT,       -- Settlem. Mgmt. [agrel]
    PRODUCTUNITGROUP,                -- UoM Group [megru]
    SLSDOCISRLVTFORPROOFOFDELIV,     -- POD-relevant [podkz]
    SLSUNLMTDOVRDELIVISALLWD,        -- Unlimited Tol. [uebtk_v]
    CREDITCONTROLAREA,               -- Cred.Contr.Area [kkber]
    CUSTOMERISREBATERELEVANT,        -- Rebate [bokre]
    INSPSBSTHASNOTIMEORQUANTITY,     -- Price determin. [prfre]
    MANUALINVOICEMAINTISRELEVANT,    -- Man.Inv.Maint. [mrnkz]
    SALESITEMPROPOSAL,               -- Item proposal [vsort]
    CUSTPRODPROPOSALPROCEDURE,       -- PP cust. proc. [pvksm]
    PROOFOFDELIVERYTIMEVALUE,        -- POD timeframe [cust_pod]
    INCOTERMSSUPCHNLOC2ADDLUUID,     -- Location UUID [/sapapo/location_uuid]
    INCOTERMSSUPCHNLOC1ADDLUUID,     -- Location UUID [/sapapo/location_uuid]
    INCOTERMSSUPCHNDVTGLOCADDLUUID,  -- Location UUID [/sapapo/location_uuid]
    SALESBLOCKFORCUSTOMER,           -- Sales Block [cassd_v]
    INCOTERMSLOCATION1IDENTIFIER,    -- Location [/sapapo/locno]
    INCOTERMSLOCATION2IDENTIFIER,    -- Location [/sapapo/locno]
    INCOTERMSDVTGLOCIDENTIFIER,      -- Location [/sapapo/locno]
    BPHASACTIVEENTITY,               -- Is active [sdraft_is_active]
    INCOTERMSDVTGLOCDESCRIPTION,     -- Loc. Description [/sapapo/loc_descr40]
    PLANTNAME,                       -- Plant Name [werks_name]
    SALESORGANIZATIONNAME,           -- Sales Organization Description [salesorganizationname]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, CUSTOMER, SALESORGANIZATION, DISTRIBUTIONCHANNEL, DIVISION, DRAFTUUID)
);