BUPA_PURGORG_D

Transparent Table Application Table
71 Fields 1 CDS Views

Draft table for entity I_SUPPLIERPURCHASINGORGTP

BUPA_PURGORG_D is an SAP database table in S/4HANA. Draft table for entity I_SUPPLIERPURCHASINGORGTP. It contains 71 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SupplierPurgOrgDraft view_entity from BASIC Supplier Purchasing Organization - Draft

Fields (71)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchasingorganization EKORG Purchasing Org.
KEY businesspartner BU_PARTNER Busn. Partner
KEY supplier ELIFN Supplier
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
purchasingorganizationforedit EKORG Purchasing Org.
businesspartnerforedit BU_PARTNER Busn. Partner
supplierforedit ELIFN Supplier
businesspartneruuid BU_PARTNER_GUID BP GUID
purchasinggroup EKGRP Purch. Group
planneddeliverydurationindays PLIFZ Pl. Deliv. Time
purchasingisblockedforsupplier SPERM_M Pur. block POrg
supplierrespsalespersonname EVERK Salesperson
contactpersonphonenumber TELFE Telephone
purchaseordercurrency BSTWA Order currency
minimumorderamount MINBW Minimum value
calculationschemagroupcode KALSK Schema Grp Supp
paymentterms DZTERM Pyt Terms
pricingdatecontrol MEPRF Pr. Date Cat.
supplierabcclassificationcode LFABC ABC indicator
shippingcondition VSBED Shipping Conditions
purordautogenerationisallowed KZAUT Automatic PO
invoiceisgoodsreceiptbased WEBRE GR-Based IV
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
incotermsversion INCOV Inco. Version
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
evaldreceiptsettlementisactive XERSY ERS
automaticevaluatedrcptsettlmt XERSR Aut. GRSet Ret
supplieraccountnumber EIKTO_M Acc. w. supplier
supplierconfirmationcontrolkey BSTAE Conf. Control
isorderacknrqd KZABS Acknowl. Reqd.
suplrissubjtosubsqntsettlement BOLRE Subseq. sett.
suplrpurgorgagrmtofbusvolisrqd UMSAE B.vol.comp./ag.
suplrinvcrevalisallowed XNBWY Revaluation
suplrpurgorgisrlvtforpricedetn PRFRE_LH Price determin.
intrastatcrsbordertrmode EXPVZ Mode of Trans.
productunitgroup MEGRU UoM Group
roundingprofile RDPRF Rnding Profile
planningcycle LFRHY Planning Cycle
suplrdiscountinkindisgranted XFELD Checkbox
suplrisrlvtforsettlmtmgmt AGREL Settlem. Mgmt.
invoiceismmserviceentrybased LEBRE Srv.-Based Inv. Ver.
prodstockandslsdatatransfprfl WVMI_PAPRF PROACT control prof
evaldrcptsettlementprofile VALID_PRO Settlement profile
absolutehandlingsurchargeamt HSCABS Absolute surcharge
percentagehandlingsurchargeamt HSCPE Percentage HSC
minimumhandlingsurchargeamt HSCMIN Minimum HSC
maximumhandlingsurchargeamt HSCMAX Max. HSC
automdebitcrtnisenbldongi AUBEL Auto. debit
incotermssupchnloc2addluuid /SAPAPO/LOCATION_UUID Location UUID
incotermssupchnloc1addluuid /SAPAPO/LOCATION_UUID Location UUID
incotermssupchndvtglocaddluuid /SAPAPO/LOCATION_UUID Location UUID
bphasactiveentity SDRAFT_IS_ACTIVE Is active
deletionindicator LOEVM_M Del. flag POrg.
incotermslocation1identifier /SAPAPO/LOCNO Location
incotermslocation2identifier /SAPAPO/LOCNO Location
incotermsdvtglocidentifier /SAPAPO/LOCNO Location
supplieraccountgroup KTOKK Account group
supplierauthzngrp BRGRU Authorization
authorizationgroup BU_AUGRP Authorization Group
isbusinesspurposecompleted BU_XPCPT Purpose Completed
businesspartnerdraftuuid SDRAFT_UUID Draft Document ID
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_SUPPLIERPURCHASINGORGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_PURGORG_D (
    MANDT,                           -- Client [MANDT]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    BUSINESSPARTNER,                 -- Busn. Partner [BU_PARTNER]
    SUPPLIER,                        -- Supplier [ELIFN]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    PURCHASINGORGANIZATIONFOREDIT,   -- Purchasing Org. [EKORG]
    BUSINESSPARTNERFOREDIT,          -- Busn. Partner [BU_PARTNER]
    SUPPLIERFOREDIT,                 -- Supplier [ELIFN]
    BUSINESSPARTNERUUID,             -- BP GUID [BU_PARTNER_GUID]
    PURCHASINGGROUP,                 -- Purch. Group [EKGRP]
    PLANNEDDELIVERYDURATIONINDAYS,   -- Pl. Deliv. Time [PLIFZ]
    PURCHASINGISBLOCKEDFORSUPPLIER,  -- Pur. block POrg [SPERM_M]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [EVERK]
    CONTACTPERSONPHONENUMBER,        -- Telephone [TELFE]
    PURCHASEORDERCURRENCY,           -- Order currency [BSTWA]
    MINIMUMORDERAMOUNT,              -- Minimum value [MINBW]
    CALCULATIONSCHEMAGROUPCODE,      -- Schema Grp Supp [KALSK]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    PRICINGDATECONTROL,              -- Pr. Date Cat. [MEPRF]
    SUPPLIERABCCLASSIFICATIONCODE,   -- ABC indicator [LFABC]
    SHIPPINGCONDITION,               -- Shipping Conditions [VSBED]
    PURORDAUTOGENERATIONISALLOWED,   -- Automatic PO [KZAUT]
    INVOICEISGOODSRECEIPTBASED,      -- GR-Based IV [WEBRE]
    INCOTERMSCLASSIFICATION,         -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [INCO2]
    INCOTERMSVERSION,                -- Inco. Version [INCOV]
    INCOTERMSLOCATION1,              -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,              -- Inco. Location2 [INCO3_L]
    EVALDRECEIPTSETTLEMENTISACTIVE,  -- ERS [XERSY]
    AUTOMATICEVALUATEDRCPTSETTLMT,   -- Aut. GRSet Ret [XERSR]
    SUPPLIERACCOUNTNUMBER,           -- Acc. w. supplier [EIKTO_M]
    SUPPLIERCONFIRMATIONCONTROLKEY,  -- Conf. Control [BSTAE]
    ISORDERACKNRQD,                  -- Acknowl. Reqd. [KZABS]
    SUPLRISSUBJTOSUBSQNTSETTLEMENT,  -- Subseq. sett. [BOLRE]
    SUPLRPURGORGAGRMTOFBUSVOLISRQD,  -- B.vol.comp./ag. [UMSAE]
    SUPLRINVCREVALISALLOWED,         -- Revaluation [XNBWY]
    SUPLRPURGORGISRLVTFORPRICEDETN,  -- Price determin. [PRFRE_LH]
    INTRASTATCRSBORDERTRMODE,        -- Mode of Trans. [EXPVZ]
    PRODUCTUNITGROUP,                -- UoM Group [MEGRU]
    ROUNDINGPROFILE,                 -- Rnding Profile [RDPRF]
    PLANNINGCYCLE,                   -- Planning Cycle [LFRHY]
    SUPLRDISCOUNTINKINDISGRANTED,    -- Checkbox [XFELD]
    SUPLRISRLVTFORSETTLMTMGMT,       -- Settlem. Mgmt. [AGREL]
    INVOICEISMMSERVICEENTRYBASED,    -- Srv.-Based Inv. Ver. [LEBRE]
    PRODSTOCKANDSLSDATATRANSFPRFL,   -- PROACT control prof [WVMI_PAPRF]
    EVALDRCPTSETTLEMENTPROFILE,      -- Settlement profile [VALID_PRO]
    ABSOLUTEHANDLINGSURCHARGEAMT,    -- Absolute surcharge [HSCABS]
    PERCENTAGEHANDLINGSURCHARGEAMT,  -- Percentage HSC [HSCPE]
    MINIMUMHANDLINGSURCHARGEAMT,     -- Minimum HSC [HSCMIN]
    MAXIMUMHANDLINGSURCHARGEAMT,     -- Max. HSC [HSCMAX]
    AUTOMDEBITCRTNISENBLDONGI,       -- Auto. debit [AUBEL]
    INCOTERMSSUPCHNLOC2ADDLUUID,     -- Location UUID [/SAPAPO/LOCATION_UUID]
    INCOTERMSSUPCHNLOC1ADDLUUID,     -- Location UUID [/SAPAPO/LOCATION_UUID]
    INCOTERMSSUPCHNDVTGLOCADDLUUID,  -- Location UUID [/SAPAPO/LOCATION_UUID]
    BPHASACTIVEENTITY,               -- Is active [SDRAFT_IS_ACTIVE]
    DELETIONINDICATOR,               -- Del. flag POrg. [LOEVM_M]
    INCOTERMSLOCATION1IDENTIFIER,    -- Location [/SAPAPO/LOCNO]
    INCOTERMSLOCATION2IDENTIFIER,    -- Location [/SAPAPO/LOCNO]
    INCOTERMSDVTGLOCIDENTIFIER,      -- Location [/SAPAPO/LOCNO]
    SUPPLIERACCOUNTGROUP,            -- Account group [KTOKK]
    SUPPLIERAUTHZNGRP,               -- Authorization [BRGRU]
    AUTHORIZATIONGROUP,              -- Authorization Group [BU_AUGRP]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [BU_XPCPT]
    BUSINESSPARTNERDRAFTUUID,        -- Draft Document ID [SDRAFT_UUID]
    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, PURCHASINGORGANIZATION, BUSINESSPARTNER, SUPPLIER, DRAFTUUID)
);

Learn More