BUPA_PURGORG_D
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 64 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_SupplierPurgOrgDraft | view_entity | from | BASIC | Supplier Purchasing Organization - Draft |
Fields (64)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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]
PRIMARY KEY (MANDT, PURCHASINGORGANIZATION, BUSINESSPARTNER, SUPPLIER, DRAFTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA