I_BUSINESSPARTNERPURGORG

CDS View

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)

ViewTypeJoinVDMDescription
/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)

KeyField CDS FieldsUsed 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":""
}
}*/