I_BUSINESSPARTNERPURGORG
Core view for Purchasing Organization
I_BUSINESSPARTNERPURGORG is a CDS View in S/4HANA. Core view for Purchasing Organization. It contains 50 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SCMTMS/CV_BPPurOrg | view | from | BOPF: /SCMTMS/BuPa Help view pur org | |
| C_EvaldRcptSettlmtSupplier | view | from | CONSUMPTION | ERS Activated Supplier |
| I_BPSuplrAddrDepdntPurgOrgInfo | view | inner | COMPOSITE | Supplier addr depnt purch info |
| I_BusinessPartnerPurgOrgTP | view | from | TRANSACTIONAL | Supplier Purchasing Organization BO View |
| I_SupplierPurchasingOrgTP | view_entity | from | TRANSACTIONAL | Supplier Purchasing Org - TP |
| P_CollabnApplFrtOrdInvoice | view | inner | CONSUMPTION | Freight Orders for Invoicing |
Fields (50)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner,BusinessPartnerForEdit | 2 |
| KEY | PurchasingOrganization | PurchasingOrganization,PurchasingOrganizationForEdit | 3 |
| KEY | Supplier | Supplier | 2 |
| AbsoluteHandlingSurchargeAmt | AbsoluteHandlingSurchargeAmt | 1 | |
| AutomaticEvaluatedRcptSettlmt | AutomaticEvaluatedRcptSettlmt | 3 | |
| AutomDebitCrtnIsEnbldOnGI | AutomDebitCrtnIsEnbldOnGI | 2 | |
| BusinessPartnerUUID | BusinessPartnerUUID | 1 | |
| CalculationSchemaGroupCode | CalculationSchemaGroupCode | 2 | |
| ContactPersonPhoneNumber | ContactPersonPhoneNumber | 2 | |
| DeletionIndicator | DeletionIndicator | 1 | |
| EvaldRcptSettlementProfile | EvaldRcptSettlementProfile | 2 | |
| EvaldReceiptSettlementIsActive | EvaldReceiptSettlementIsActive | 3 | |
| IncotermsClassification | IncotermsClassification | 2 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsSupChnDvtgLocAddlUUID | IncotermsSupChnDvtgLocAddlUUID | 1 | |
| IncotermsSupChnLoc1AddlUUID | IncotermsSupChnLoc1AddlUUID | 1 | |
| IncotermsSupChnLoc2AddlUUID | IncotermsSupChnLoc2AddlUUID | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 2 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| IntrastatCrsBorderTrMode | IntrastatCrsBorderTrMode | 1 | |
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | 2 | |
| InvoiceIsMMServiceEntryBased | InvoiceIsMMServiceEntryBased | 2 | |
| IsOrderAcknRqd | IsOrderAcknRqd | 2 | |
| MaximumHandlingSurchargeAmt | MaximumHandlingSurchargeAmt | 1 | |
| MinimumHandlingSurchargeAmt | MinimumHandlingSurchargeAmt | 1 | |
| MinimumOrderAmount | MinimumOrderAmount | 1 | |
| PaymentTerms | PaymentTerms | 2 | |
| PercentageHandlingSurchargeAmt | PercentageHandlingSurchargeAmt | 2 | |
| PlannedDeliveryDurationInDays | PlannedDeliveryDurationInDays | 1 | |
| PlanningCycle | PlanningCycle | 1 | |
| PricingDateControl | PricingDateControl | 2 | |
| ProdStockAndSlsDataTransfPrfl | ProdStockAndSlsDataTransfPrfl | 2 | |
| ProductUnitGroup | ProductUnitGroup | 2 | |
| PurchaseOrderCurrency | PurchaseOrderCurrency | 2 | |
| PurchasingGroup | PurchasingGroup | 2 | |
| PurchasingIsBlockedForSupplier | PurchasingIsBlockedForSupplier | 2 | |
| PurOrdAutoGenerationIsAllowed | PurOrdAutoGenerationIsAllowed | 2 | |
| RoundingProfile | RoundingProfile | 2 | |
| ShippingCondition | ShippingCondition | 2 | |
| SuplrDiscountInKindIsGranted | SuplrDiscountInKindIsGranted | 1 | |
| SuplrInvcRevalIsAllowed | SuplrInvcRevalIsAllowed | 2 | |
| SuplrIsRlvtForSettlmtMgmt | SuplrIsRlvtForSettlmtMgmt | 2 | |
| SuplrIsSubjToSubsqntSettlement | SuplrIsSubjToSubsqntSettlement | 2 | |
| SuplrPurgOrgAgrmtOfBusVolIsRqd | SuplrPurgOrgAgrmtOfBusVolIsRqd | 2 | |
| SuplrPurgOrgIsRlvtForPriceDetn | SuplrPurgOrgIsRlvtForPriceDetn | 1 | |
| SupplierABCClassificationCode | SupplierABCClassificationCode | 2 | |
| SupplierAccountNumber | SupplierAccountNumber | 2 | |
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | 2 | |
| SupplierRespSalesPersonName | SupplierRespSalesPersonName | 2 |
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.
-- Core view for Purchasing Organization
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERPURGORG (
BUSINESSPARTNER,
PURCHASINGORGANIZATION,
SUPPLIER,
ABSOLUTEHANDLINGSURCHARGEAMT,
AUTOMATICEVALUATEDRCPTSETTLMT,
AUTOMDEBITCRTNISENBLDONGI,
BUSINESSPARTNERUUID,
CALCULATIONSCHEMAGROUPCODE,
CONTACTPERSONPHONENUMBER,
DELETIONINDICATOR,
EVALDRCPTSETTLEMENTPROFILE,
EVALDRECEIPTSETTLEMENTISACTIVE,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSSUPCHNDVTGLOCADDLUUID,
INCOTERMSSUPCHNLOC1ADDLUUID,
INCOTERMSSUPCHNLOC2ADDLUUID,
INCOTERMSTRANSFERLOCATION,
INCOTERMSVERSION,
INTRASTATCRSBORDERTRMODE,
INVOICEISGOODSRECEIPTBASED,
INVOICEISMMSERVICEENTRYBASED,
ISORDERACKNRQD,
MAXIMUMHANDLINGSURCHARGEAMT,
MINIMUMHANDLINGSURCHARGEAMT,
MINIMUMORDERAMOUNT,
PAYMENTTERMS,
PERCENTAGEHANDLINGSURCHARGEAMT,
PLANNEDDELIVERYDURATIONINDAYS,
PLANNINGCYCLE,
PRICINGDATECONTROL,
PRODSTOCKANDSLSDATATRANSFPRFL,
PRODUCTUNITGROUP,
PURCHASEORDERCURRENCY,
PURCHASINGGROUP,
PURCHASINGISBLOCKEDFORSUPPLIER,
PURORDAUTOGENERATIONISALLOWED,
ROUNDINGPROFILE,
SHIPPINGCONDITION,
SUPLRDISCOUNTINKINDISGRANTED,
SUPLRINVCREVALISALLOWED,
SUPLRISRLVTFORSETTLMTMGMT,
SUPLRISSUBJTOSUBSQNTSETTLEMENT,
SUPLRPURGORGAGRMTOFBUSVOLISRQD,
SUPLRPURGORGISRLVTFORPRICEDETN,
SUPPLIERABCCLASSIFICATIONCODE,
SUPPLIERACCOUNTNUMBER,
SUPPLIERCONFIRMATIONCONTROLKEY,
SUPPLIERRESPSALESPERSONNAME,
PRIMARY KEY (BUSINESSPARTNER, PURCHASINGORGANIZATION, SUPPLIER)
);
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