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. 5 CDS views read from this table.
CDS Views using this table (5)
| 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 |
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 |
@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":""
}
}*/