I_BusinessPartnerPurgOrg
Core view for Purchasing Organization
I_BusinessPartnerPurgOrg is a Basic CDS View that provides data about "Core view for Purchasing Organization" in SAP S/4HANA. It reads from 1 data source (I_SupplierPurchasingOrg) and exposes 57 fields with key fields PurchasingOrganization, BusinessPartner. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SupplierPurchasingOrg | I_SupplierPurchasingOrg | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_Supplier_to_BusinessPartner | _SupplierToPartner | $projection.Supplier = _SupplierToPartner.Supplier |
| [0..1] | E_BPPURORG_D | _PurgOrgExt | $projection.PurchasingOrganization = _PurgOrgExt.PurchasingOrganization and $projection.Supplier = _PurgOrgExt.Supplier |
| [0..1] | I_ShippingCondition | _ShipgCndnValueHelp | $projection.ShippingCondition = _ShipgCndnValueHelp.ShippingCondition |
| [0..*] | I_ShippingConditionText | _ShippingConditionText | $projection.ShippingCondition = _ShippingConditionText.ShippingCondition |
| [1..1] | I_TransportationLocation | _IncotermsSupChnDvtgLoc | $projection.IncotermsSupChnDvtgLocAddlUUID = _IncotermsSupChnDvtgLoc.LocationAdditionalUUID |
| [1..1] | I_TransportationLocation | _IncotermsSupChnLoc2 | $projection.IncotermsSupChnLoc2AddlUUID = _IncotermsSupChnLoc2.LocationAdditionalUUID |
| [1..1] | I_TransportationLocation | _IncotermsSupChnLoc1 | $projection.IncotermsSupChnLoc1AddlUUID = _IncotermsSupChnLoc1.LocationAdditionalUUID |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IBUPAPURGORG | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| VDM.viewType | #BASIC | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| EndUserText.label | Core view for Purchasing Organization | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view |
Fields (57)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchasingOrganization | PurchasingOrganization | ||
| KEY | BusinessPartner | |||
| BusinessPartnerUUID | _SupplierToPartner | BusinessPartnerUUID | ||
| Supplier | Supplier | |||
| PurchasingGroup | PurchasingGroup | |||
| PlannedDeliveryDurationInDays | PlannedDeliveryDurationInDays | |||
| PurchasingIsBlockedForSupplier | PurchasingIsBlockedForSupplier | |||
| SupplierRespSalesPersonName | SupplierRespSalesPersonName | |||
| ContactPersonPhoneNumber | ContactPersonPhoneNumber | |||
| PurchaseOrderCurrency | PurchaseOrderCurrency | |||
| MinimumOrderAmount | MinimumOrderAmount | |||
| CalculationSchemaGroupCode | CalculationSchemaGroupCode | |||
| PaymentTerms | PaymentTerms | |||
| PricingDateControl | PricingDateControl | |||
| SupplierABCClassificationCode | SupplierABCClassificationCode | |||
| ShippingCondition | ShippingCondition | |||
| PurOrdAutoGenerationIsAllowed | PurOrdAutoGenerationIsAllowed | |||
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsVersion | IncotermsVersion | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| EvaldReceiptSettlementIsActive | EvaldReceiptSettlementIsActive | |||
| AutomaticEvaluatedRcptSettlmt | AutomaticEvaluatedRcptSettlmt | |||
| SupplierAccountNumber | SupplierAccountNumber | |||
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | |||
| IsOrderAcknRqd | IsOrderAcknRqd | |||
| IsActiveEntity | ||||
| SuplrIsSubjToSubsqntSettlement | SuplrIsSubjToSubsqntSettlement | |||
| SuplrPurgOrgAgrmtOfBusVolIsRqd | SuplrPurgOrgAgrmtOfBusVolIsRqd | |||
| SuplrInvcRevalIsAllowed | SuplrInvcRevalIsAllowed | |||
| SuplrPurgOrgIsRlvtForPriceDetn | SuplrPurgOrgIsRlvtForPriceDetn | |||
| IntrastatCrsBorderTrMode | IntrastatCrsBorderTrMode | |||
| ProductUnitGroup | ProductUnitGroup | |||
| RoundingProfile | RoundingProfile | |||
| PlanningCycle | PlanningCycle | |||
| SuplrDiscountInKindIsGranted | SuplrDiscountInKindIsGranted | |||
| SuplrIsRlvtForSettlmtMgmt | SuplrIsRlvtForSettlmtMgmt | |||
| InvoiceIsMMServiceEntryBased | InvoiceIsMMServiceEntryBased | |||
| ProdStockAndSlsDataTransfPrfl | ProdStockAndSlsDataTransfPrfl | |||
| EvaldRcptSettlementProfile | EvaldRcptSettlementProfile | |||
| AbsoluteHandlingSurchargeAmt | AbsoluteHandlingSurchargeAmt | |||
| PercentageHandlingSurchargeAmt | PercentageHandlingSurchargeAmt | |||
| MinimumHandlingSurchargeAmt | MinimumHandlingSurchargeAmt | |||
| MaximumHandlingSurchargeAmt | MaximumHandlingSurchargeAmt | |||
| AutomDebitCrtnIsEnbldOnGI | AutomDebitCrtnIsEnbldOnGI | |||
| IncotermsSupChnLoc2AddlUUID | IncotermsSupChnLoc2AddlUUID | |||
| IncotermsSupChnLoc1AddlUUID | IncotermsSupChnLoc1AddlUUID | |||
| IncotermsSupChnDvtgLocAddlUUID | IncotermsSupChnDvtgLocAddlUUID | |||
| DeletionIndicator | DeletionIndicator | |||
| _SupplierToPartner | _SupplierToPartner | |||
| _ShipgCndnValueHelp | _ShipgCndnValueHelp | |||
| _ShippingConditionText | _ShippingConditionText | |||
| _IncotermsSupChnDvtgLoc | _IncotermsSupChnDvtgLoc | |||
| _IncotermsSupChnLoc1 | _IncotermsSupChnLoc1 | |||
| _IncotermsSupChnLoc2 | _IncotermsSupChnLoc2 |
@AbapCatalog.sqlViewName: 'IBUPAPURGORG'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Core view for Purchasing Organization'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
/*this view is directly built on lfm1 instead of I_SupplierPurchasingOrg ,
since I_SupplierPurchasingOrg fetches purchasng organization data of bp type organization only */
define view I_BusinessPartnerPurgOrg
as select from I_SupplierPurchasingOrg //lfm1 replacing with I_SupplierPurchasingOrg as there is neither an association to BP nor a where clause on type 2
association [1..1] to I_Supplier_to_BusinessPartner as _SupplierToPartner on $projection.Supplier = _SupplierToPartner.Supplier
association [0..1] to E_BPPURORG_D as _PurgOrgExt on $projection.PurchasingOrganization = _PurgOrgExt.PurchasingOrganization
and $projection.Supplier = _PurgOrgExt.Supplier
//Associations added for Text Annotation Removal
association [0..1] to I_ShippingCondition as _ShipgCndnValueHelp on $projection.ShippingCondition = _ShipgCndnValueHelp.ShippingCondition
association [0..*] to I_ShippingConditionText as _ShippingConditionText on $projection.ShippingCondition = _ShippingConditionText.ShippingCondition
association [1..1] to I_TransportationLocation as _IncotermsSupChnDvtgLoc on $projection.IncotermsSupChnDvtgLocAddlUUID = _IncotermsSupChnDvtgLoc.LocationAdditionalUUID /*+[hideWarning] { "IDS" : [
"CALCULATED_FIELD_CHECK" ] } */
association [1..1] to I_TransportationLocation as _IncotermsSupChnLoc2 on $projection.IncotermsSupChnLoc2AddlUUID = _IncotermsSupChnLoc2.LocationAdditionalUUID /*+[hideWarning] { "IDS" : [
"CALCULATED_FIELD_CHECK" ] } */
association [1..1] to I_TransportationLocation as _IncotermsSupChnLoc1 on $projection.IncotermsSupChnLoc1AddlUUID = _IncotermsSupChnLoc1.LocationAdditionalUUID /*+[hideWarning] { "IDS" : [
"CALCULATED_FIELD_CHECK" ] } */
{
key PurchasingOrganization,
key _SupplierToPartner._BusinessPartner.BusinessPartner as BusinessPartner,
_SupplierToPartner.BusinessPartnerUUID as BusinessPartnerUUID,
Supplier,
PurchasingGroup,
PlannedDeliveryDurationInDays,
PurchasingIsBlockedForSupplier,
SupplierRespSalesPersonName,
ContactPersonPhoneNumber,
@Semantics.currencyCode: true
PurchaseOrderCurrency,
@Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
MinimumOrderAmount,
CalculationSchemaGroupCode,
PaymentTerms,
PricingDateControl,
SupplierABCClassificationCode,
//@ObjectModel: {
// foreignKey.association: '_ShipgCndnValueHelp'
//}
@ObjectModel.text.association: '_ShippingConditionText'
ShippingCondition,
PurOrdAutoGenerationIsAllowed,
InvoiceIsGoodsReceiptBased,
IncotermsClassification,
IncotermsTransferLocation,
IncotermsVersion,
IncotermsLocation1,
IncotermsLocation2,
//fields requested by the TM colleagues
EvaldReceiptSettlementIsActive,
AutomaticEvaluatedRcptSettlmt,
SupplierAccountNumber,
SupplierConfirmationControlKey,
IsOrderAcknRqd,
//_SupplierToPartner._Supplier.AuthorizationGroup,
//For extensibility
cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity,
//
SuplrIsSubjToSubsqntSettlement,
SuplrPurgOrgAgrmtOfBusVolIsRqd,
SuplrInvcRevalIsAllowed,
SuplrPurgOrgIsRlvtForPriceDetn,
IntrastatCrsBorderTrMode,
ProductUnitGroup,
RoundingProfile,
PlanningCycle,
SuplrDiscountInKindIsGranted,
// lfm1.nrgew as SuplrDiscountInKindIsGranted,
SuplrIsRlvtForSettlmtMgmt,
InvoiceIsMMServiceEntryBased,
ProdStockAndSlsDataTransfPrfl,
EvaldRcptSettlementProfile,
AbsoluteHandlingSurchargeAmt,
PercentageHandlingSurchargeAmt,
MinimumHandlingSurchargeAmt,
MaximumHandlingSurchargeAmt,
AutomDebitCrtnIsEnbldOnGI,
IncotermsSupChnLoc2AddlUUID,
IncotermsSupChnLoc1AddlUUID,
IncotermsSupChnDvtgLocAddlUUID,
DeletionIndicator,
_SupplierToPartner,
_ShipgCndnValueHelp,
_ShippingConditionText,
_IncotermsSupChnDvtgLoc,
_IncotermsSupChnLoc1,
_IncotermsSupChnLoc2
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_SUPPLIERPURCHASINGORG",
"I_SUPPLIER_TO_BUSINESSPARTNER"
],
"ASSOCIATED":
[
"E_BPPURORG_D",
"I_SHIPPINGCONDITION",
"I_SHIPPINGCONDITIONTEXT",
"I_SUPPLIER_TO_BUSINESSPARTNER",
"I_TRANSPORTATIONLOCATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA