A_SupplierPurchasingOrg

DDL: A_SUPPLIERPURCHASINGORG SQL: ASUPPLPURCH Type: view BASIC Package: ODATA_MASTER_DATA_BP

Purchasing Organization

A_SupplierPurchasingOrg is a Basic CDS View that provides data about "Purchasing Organization" in SAP S/4HANA. It reads from 1 data source (I_SupplierPurchasingOrg) and exposes 46 fields with key fields Supplier, PurchasingOrganization. It has 2 associations to related views. Part of development package ODATA_MASTER_DATA_BP.

1 data source(s) 46 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierPurchasingOrg I_SupplierPurchasingOrg from

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_BPPURORG_D _PurchasingExtension $projection.Supplier = _PurchasingExtension.Supplier and $projection.PurchasingOrganization = _PurchasingExtension.PurchasingOrganization association[1..1] to A_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier association[0..*] to A_SupplierPartnerFunc as _PartnerFunction on $projection.Supplier = _PartnerFunction.Supplier and $projection.PurchasingOrganization = _PartnerFunction.PurchasingOrganization and _PartnerFunction.Plant = '' and _PartnerFunction.SupplierSubrange = ''
[0..*] A_SupplierPurchasingOrgText _PurchasingOrgText $projection.Supplier = _PurchasingOrgText.Supplier and $projection.PurchasingOrganization = _PurchasingOrgText.PurchasingOrganization

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ASUPPLPURCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Purchasing Organization view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY PurchasingOrganization PurchasingOrganization
AutomaticEvaluatedRcptSettlmt AutomaticEvaluatedRcptSettlmt
CalculationSchemaGroupCode CalculationSchemaGroupCode
DeletionIndicator DeletionIndicator
EvaldReceiptSettlementIsActive EvaldReceiptSettlementIsActive
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsVersion IncotermsVersion
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID
IntrastatCrsBorderTrMode IntrastatCrsBorderTrMode
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased
InvoiceIsMMServiceEntryBased InvoiceIsMMServiceEntryBased
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn
MinimumOrderAmount MinimumOrderAmount
PaymentTerms PaymentTerms
PlanningCycle PlanningCycle
PricingDateControl PricingDateControl
ProdStockAndSlsDataTransfPrfl ProdStockAndSlsDataTransfPrfl
ProductUnitGroup ProductUnitGroup
PurOrdAutoGenerationIsAllowed PurOrdAutoGenerationIsAllowed
PurchaseOrderCurrency PurchaseOrderCurrency
PurchasingGroup PurchasingGroup
PurchasingIsBlockedForSupplier PurchasingIsBlockedForSupplier
RoundingProfile RoundingProfile
ShippingCondition ShippingCondition
SuplrDiscountInKindIsGranted SuplrDiscountInKindIsGranted
SuplrInvcRevalIsAllowed SuplrInvcRevalIsAllowed
SuplrIsRlvtForSettlmtMgmt SuplrIsRlvtForSettlmtMgmt
SuplrPurgOrgIsRlvtForPriceDetn SuplrPurgOrgIsRlvtForPriceDetn
SupplierABCClassificationCode SupplierABCClassificationCode
SupplierAccountNumber SupplierAccountNumber
SupplierIsReturnsSupplier SupplierIsReturnsSupplier
SupplierPhoneNumber SupplierPhoneNumber
SupplierRespSalesPersonName SupplierRespSalesPersonName
SupplierConfirmationControlKey SupplierConfirmationControlKey
IsOrderAcknRqd IsOrderAcknRqd
AuthorizationGroup _Supplier AuthorizationGroup
SupplierAccountGroup _Supplier SupplierAccountGroup
_PartnerFunction _PartnerFunction
_Supplier _Supplier
_PurchasingOrgText _PurchasingOrgText 
@AbapCatalog.sqlViewName: 'ASUPPLPURCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Purchasing Organization'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
//@ObjectModel.deleteEnabled:true


define view A_SupplierPurchasingOrg as select from I_SupplierPurchasingOrg

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

  association[0..*] to A_SupplierPartnerFunc as _PartnerFunction on  $projection.Supplier = _PartnerFunction.Supplier
                                                                 and $projection.PurchasingOrganization = _PartnerFunction.PurchasingOrganization
                                                                 and _PartnerFunction.Plant = ''
                                                                 and _PartnerFunction.SupplierSubrange = ''
                                                               
  association [0..*] to A_SupplierPurchasingOrgText as _PurchasingOrgText on  $projection.Supplier = _PurchasingOrgText.Supplier  
                                                                          and $projection.PurchasingOrganization = _PurchasingOrgText.PurchasingOrganization 
                       
{
  key Supplier,
  key PurchasingOrganization,
      AutomaticEvaluatedRcptSettlmt,
      CalculationSchemaGroupCode, 
      DeletionIndicator, 
      EvaldReceiptSettlementIsActive,
      IncotermsClassification, 
      IncotermsTransferLocation,
      IncotermsVersion,
      IncotermsLocation1,
      IncotermsLocation2,
      IncotermsSupChnLoc1AddlUUID,
      IncotermsSupChnLoc2AddlUUID,
      IncotermsSupChnDvtgLocAddlUUID,
      IntrastatCrsBorderTrMode,
      InvoiceIsGoodsReceiptBased, 
      InvoiceIsMMServiceEntryBased,
      MaterialPlannedDeliveryDurn,
      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency' 
      MinimumOrderAmount, 
      PaymentTerms, 
      PlanningCycle,
      PricingDateControl, 
      ProdStockAndSlsDataTransfPrfl,
      ProductUnitGroup,
      PurOrdAutoGenerationIsAllowed, 
      PurchaseOrderCurrency, 
      PurchasingGroup, 
      PurchasingIsBlockedForSupplier,  
      RoundingProfile,
      ShippingCondition, 
      SuplrDiscountInKindIsGranted,
      SuplrInvcRevalIsAllowed,
      SuplrIsRlvtForSettlmtMgmt,
      SuplrPurgOrgIsRlvtForPriceDetn,
      SupplierABCClassificationCode, 
      SupplierAccountNumber,
      SupplierIsReturnsSupplier,
      SupplierPhoneNumber, 
      SupplierRespSalesPersonName,
      SupplierConfirmationControlKey,
      IsOrderAcknRqd,
      _Supplier.AuthorizationGroup,
      _Supplier.SupplierAccountGroup,
      _PartnerFunction,
      _Supplier,
      _PurchasingOrgText
}

Learn More