I_BusinessPartnerPurgOrgTP

DDL: I_BUSINESSPARTNERPURGORGTP SQL: IBUPAPURGORGTP Type: view TRANSACTIONAL

Supplier Purchasing Organization BO View

I_BusinessPartnerPurgOrgTP is a Transactional CDS View that provides data about "Supplier Purchasing Organization BO View" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerPurgOrg) and exposes 60 fields with key fields BusinessPartner, PurchasingOrganization. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerPurgOrg BusinessPartnerPurgOrg from

Associations (6)

CardinalityTargetAliasCondition
[0..1] E_BPPURORG_D _ActiveExtension $projection.PurchasingOrganization = _ActiveExtension.PurchasingOrganization and $projection.Supplier = _ActiveExtension.Supplier
[0..1] E_BPPURORG_D _DraftExtension $projection.PurchasingOrganization = _DraftExtension.PurchasingOrganization and $projection.Supplier = _DraftExtension.Supplier
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..*] I_BPSupplierPartnerFunctionTP _BPSupplierPartnerFunction $projection.BusinessPartner = _BPSupplierPartnerFunction.BusinessPartner and $projection.PurchasingOrganization = _BPSupplierPartnerFunction.PurchasingOrganization
[0..*] I_BPSupplierPurchasingOrgTxtTP _BPSupplierPurchasingOrgTxt $projection.BusinessPartner = _BPSupplierPurchasingOrgTxt.BusinessPartner and $projection.PurchasingOrganization = _BPSupplierPurchasingOrgTxt.PurchasingOrganization
[0..*] I_BPSupplyRegionTP _BPSupplyRegion $projection.BusinessPartner = _BPSupplyRegion.BusinessPartner and $projection.PurchasingOrganization = _BPSupplyRegion.PurchasingOrganization

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBUPAPURGORGTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence PUR_ORG_D view
ObjectModel.draftEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
Search.searchable true view
EndUserText.label Supplier Purchasing Organization BO View view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartnerPurgOrg BusinessPartner
KEY PurchasingOrganization I_BusinessPartnerPurgOrg PurchasingOrganization
BusinessPartnerForEdit I_BusinessPartnerPurgOrg BusinessPartner
BusinessPartnerUUID I_BusinessPartnerPurgOrg BusinessPartnerUUID
Supplier I_BusinessPartnerPurgOrg Supplier
PurchasingOrganizationForEdit I_BusinessPartnerPurgOrg PurchasingOrganization
PurchasingGroup I_BusinessPartnerPurgOrg PurchasingGroup
PlannedDeliveryDurationInDays I_BusinessPartnerPurgOrg PlannedDeliveryDurationInDays
PurchasingIsBlockedForSupplier I_BusinessPartnerPurgOrg PurchasingIsBlockedForSupplier
SupplierRespSalesPersonName I_BusinessPartnerPurgOrg SupplierRespSalesPersonName
ContactPersonPhoneNumber I_BusinessPartnerPurgOrg ContactPersonPhoneNumber
PurchaseOrderCurrency I_BusinessPartnerPurgOrg PurchaseOrderCurrency
MinimumOrderAmount I_BusinessPartnerPurgOrg MinimumOrderAmount
CalculationSchemaGroupCode I_BusinessPartnerPurgOrg CalculationSchemaGroupCode
PaymentTerms I_BusinessPartnerPurgOrg PaymentTerms
PricingDateControl I_BusinessPartnerPurgOrg PricingDateControl
SupplierABCClassificationCode I_BusinessPartnerPurgOrg SupplierABCClassificationCode
ShippingCondition I_BusinessPartnerPurgOrg ShippingCondition
PurOrdAutoGenerationIsAllowed I_BusinessPartnerPurgOrg PurOrdAutoGenerationIsAllowed
InvoiceIsGoodsReceiptBased I_BusinessPartnerPurgOrg InvoiceIsGoodsReceiptBased
IncotermsClassification I_BusinessPartnerPurgOrg IncotermsClassification
IncotermsTransferLocation I_BusinessPartnerPurgOrg IncotermsTransferLocation
IncotermsVersion I_BusinessPartnerPurgOrg IncotermsVersion
IncotermsLocation1 I_BusinessPartnerPurgOrg IncotermsLocation1
IncotermsLocation2 I_BusinessPartnerPurgOrg IncotermsLocation2
SupplierConfirmationControlKey I_BusinessPartnerPurgOrg SupplierConfirmationControlKey
IsOrderAcknRqd I_BusinessPartnerPurgOrg IsOrderAcknRqd
SuplrIsSubjToSubsqntSettlement I_BusinessPartnerPurgOrg SuplrIsSubjToSubsqntSettlement
SuplrPurgOrgAgrmtOfBusVolIsRqd I_BusinessPartnerPurgOrg SuplrPurgOrgAgrmtOfBusVolIsRqd
SuplrInvcRevalIsAllowed I_BusinessPartnerPurgOrg SuplrInvcRevalIsAllowed
SuplrPurgOrgIsRlvtForPriceDetn I_BusinessPartnerPurgOrg SuplrPurgOrgIsRlvtForPriceDetn
IntrastatCrsBorderTrMode I_BusinessPartnerPurgOrg IntrastatCrsBorderTrMode
ProductUnitGroup I_BusinessPartnerPurgOrg ProductUnitGroup
RoundingProfile I_BusinessPartnerPurgOrg RoundingProfile
PlanningCycle I_BusinessPartnerPurgOrg PlanningCycle
SuplrDiscountInKindIsGranted I_BusinessPartnerPurgOrg SuplrDiscountInKindIsGranted
SuplrIsRlvtForSettlmtMgmt I_BusinessPartnerPurgOrg SuplrIsRlvtForSettlmtMgmt
InvoiceIsMMServiceEntryBased I_BusinessPartnerPurgOrg InvoiceIsMMServiceEntryBased
EvaldReceiptSettlementIsActive I_BusinessPartnerPurgOrg EvaldReceiptSettlementIsActive
ProdStockAndSlsDataTransfPrfl I_BusinessPartnerPurgOrg ProdStockAndSlsDataTransfPrfl
EvaldRcptSettlementProfile I_BusinessPartnerPurgOrg EvaldRcptSettlementProfile
AbsoluteHandlingSurchargeAmt I_BusinessPartnerPurgOrg AbsoluteHandlingSurchargeAmt
PercentageHandlingSurchargeAmt I_BusinessPartnerPurgOrg PercentageHandlingSurchargeAmt
MinimumHandlingSurchargeAmt I_BusinessPartnerPurgOrg MinimumHandlingSurchargeAmt
MaximumHandlingSurchargeAmt I_BusinessPartnerPurgOrg MaximumHandlingSurchargeAmt
AutomaticEvaluatedRcptSettlmt I_BusinessPartnerPurgOrg AutomaticEvaluatedRcptSettlmt
AutomDebitCrtnIsEnbldOnGI I_BusinessPartnerPurgOrg AutomDebitCrtnIsEnbldOnGI
SupplierAccountNumber I_BusinessPartnerPurgOrg SupplierAccountNumber
IncotermsSupChnLoc2AddlUUID I_BusinessPartnerPurgOrg IncotermsSupChnLoc2AddlUUID
IncotermsSupChnLoc1AddlUUID I_BusinessPartnerPurgOrg IncotermsSupChnLoc1AddlUUID
IncotermsSupChnDvtgLocAddlUUID I_BusinessPartnerPurgOrg IncotermsSupChnDvtgLocAddlUUID
IncotermsLocation1Identifier
IncotermsLocation2Identifier
IncotermsDvtgLocIdentifier
_BusinessPartner _BusinessPartner
_ShipgCndnValueHelp _ShipgCndnValueHelp
_ShippingConditionText _ShippingConditionText
_BPSupplierPartnerFunction _BPSupplierPartnerFunction
_BPSupplierPurchasingOrgTxt _BPSupplierPurchasingOrgTxt
_BPSupplyRegion _BPSupplyRegion
@AbapCatalog.sqlViewName: 'IBUPAPURGORGTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true

@ObjectModel.writeDraftPersistence: 'PUR_ORG_D'
@ObjectModel.draftEnabled:true 

@ObjectModel.semanticKey: [ 'PurchasingOrganization','BusinessPartner']
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled: 'EXTERNAL_CALCULATION'
@Search.searchable: true
@EndUserText.label: 'Supplier Purchasing Organization BO View'



@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view I_BusinessPartnerPurgOrgTP

  as select from I_BusinessPartnerPurgOrg as BusinessPartnerPurgOrg

  association [0..1] to E_BPPURORG_D                   as _ActiveExtension            on  $projection.PurchasingOrganization = _ActiveExtension.PurchasingOrganization
                                                                                      and $projection.Supplier               = _ActiveExtension.Supplier

  association [0..1] to E_BPPURORG_D                   as _DraftExtension             on  $projection.PurchasingOrganization = _DraftExtension.PurchasingOrganization
                                                                                      and $projection.Supplier               = _DraftExtension.Supplier

  association [1..1] to I_BusinessPartnerTP            as _BusinessPartner            on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [0..*] to I_BPSupplierPartnerFunctionTP  as _BPSupplierPartnerFunction  on  $projection.BusinessPartner        = _BPSupplierPartnerFunction.BusinessPartner
                                                                                      and $projection.PurchasingOrganization = _BPSupplierPartnerFunction.PurchasingOrganization
  association [0..*] to I_BPSupplierPurchasingOrgTxtTP as _BPSupplierPurchasingOrgTxt on  $projection.BusinessPartner        = _BPSupplierPurchasingOrgTxt.BusinessPartner
                                                                                      and $projection.PurchasingOrganization = _BPSupplierPurchasingOrgTxt.PurchasingOrganization
  association [0..*] to I_BPSupplyRegionTP             as _BPSupplyRegion             on  $projection.BusinessPartner        = _BPSupplyRegion.BusinessPartner
                                                                                      and $projection.PurchasingOrganization = _BPSupplyRegion.PurchasingOrganization  
{
  key BusinessPartnerPurgOrg.BusinessPartner,
  key BusinessPartnerPurgOrg.PurchasingOrganization,

      BusinessPartnerPurgOrg.BusinessPartner                  as BusinessPartnerForEdit,
      BusinessPartnerPurgOrg.BusinessPartnerUUID,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.Supplier,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PurchasingOrganization           as PurchasingOrganizationForEdit,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PurchasingGroup,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PlannedDeliveryDurationInDays,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PurchasingIsBlockedForSupplier,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SupplierRespSalesPersonName,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.ContactPersonPhoneNumber,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PurchaseOrderCurrency,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.MinimumOrderAmount,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.CalculationSchemaGroupCode,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PaymentTerms,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PricingDateControl,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SupplierABCClassificationCode,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.ShippingCondition,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PurOrdAutoGenerationIsAllowed,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.InvoiceIsGoodsReceiptBased,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.IncotermsClassification,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.IncotermsTransferLocation,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.IncotermsVersion,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.IncotermsLocation1,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.IncotermsLocation2,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SupplierConfirmationControlKey,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.IsOrderAcknRqd,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SuplrIsSubjToSubsqntSettlement,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SuplrPurgOrgAgrmtOfBusVolIsRqd,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SuplrInvcRevalIsAllowed,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SuplrPurgOrgIsRlvtForPriceDetn,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.IntrastatCrsBorderTrMode,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.ProductUnitGroup,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.RoundingProfile,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.PlanningCycle,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SuplrDiscountInKindIsGranted,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.SuplrIsRlvtForSettlmtMgmt,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.InvoiceIsMMServiceEntryBased,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.EvaldReceiptSettlementIsActive,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg.ProdStockAndSlsDataTransfPrfl,

      BusinessPartnerPurgOrg.EvaldRcptSettlementProfile,
      BusinessPartnerPurgOrg.AbsoluteHandlingSurchargeAmt,
      BusinessPartnerPurgOrg.PercentageHandlingSurchargeAmt,
      BusinessPartnerPurgOrg.MinimumHandlingSurchargeAmt,
      BusinessPartnerPurgOrg.MaximumHandlingSurchargeAmt,
      BusinessPartnerPurgOrg.AutomaticEvaluatedRcptSettlmt,
      BusinessPartnerPurgOrg.AutomDebitCrtnIsEnbldOnGI,
      BusinessPartnerPurgOrg.SupplierAccountNumber,

      BusinessPartnerPurgOrg.IncotermsSupChnLoc2AddlUUID,
      BusinessPartnerPurgOrg.IncotermsSupChnLoc1AddlUUID,
      BusinessPartnerPurgOrg.IncotermsSupChnDvtgLocAddlUUID,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg._IncotermsSupChnLoc1.Location    as IncotermsLocation1Identifier,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg._IncotermsSupChnLoc2.Location    as IncotermsLocation2Identifier,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPurgOrg._IncotermsSupChnDvtgLoc.Location as IncotermsDvtgLocIdentifier,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT]
      _BusinessPartner,

      _ShipgCndnValueHelp,
      _ShippingConditionText,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPSupplierPartnerFunction,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPSupplierPurchasingOrgTxt,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPSupplyRegion

      //      _DraftAdministrativeData,

      //      _SiblingEntity,

      ////      _PurgOrganizationValueHelp


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERPURGORG",
"I_TRANSPORTATIONLOCATION"
],
"ASSOCIATED":
[
"E_BPPURORG_D",
"I_BPSUPPLIERPARTNERFUNCTIONTP",
"I_BPSUPPLIERPURCHASINGORGTXTTP",
"I_BPSUPPLYREGIONTP",
"I_BUSINESSPARTNERTP",
"I_SHIPPINGCONDITION",
"I_SHIPPINGCONDITIONTEXT"
],
"BASE":
[
"I_BUSINESSPARTNERPURGORG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/