C_Supplierpurchasingorg

DDL: C_SUPPLIERPURCHASINGORG SQL: CSUPPLPURCH Type: view CONSUMPTION

SupplierPurchasingOrganization

C_Supplierpurchasingorg is a Consumption CDS View that provides data about "SupplierPurchasingOrganization" in SAP S/4HANA. It reads from 1 data source (I_SupplierPurchasingOrg) and exposes 25 fields with key fields Supplier, PurchasingOrganization. It has 4 associations to related views.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierPurchasingOrg I_SupplierPurchasingOrg from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_PurchasingOrganization _PurgOrganization $projection.PurchasingOrganization = _PurgOrganization.PurchasingOrganization
[0..1] C_IncotermsClassfctnTextVHTemp _IncotermsClassfctnText $projection.IncotermsClassification = _IncotermsClassfctnText.IncotermsClassification and _IncotermsClassfctnText.Language = $session.system_language
[0..1] C_PaymentTermsTextVHTemp _PaymentTermsDescription $projection.PaymentTerms = _PaymentTermsDescription.PaymentTerms and _PaymentTermsDescription.Language = $session.system_language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CSUPPLPURCH view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SupplierPurchasingOrganization view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey PurchasingOrganization view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Purchasing Organization view
UI.headerInfo.typeNamePlural Purchasing Organizations view
UI.headerInfo.title.label Purchasing Organization view
UI.headerInfo.title.value PurchasingOrganizationName view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY PurchasingOrganization PurchasingOrganization
PurchasingOrganizationName _PurgOrganization PurchasingOrganizationName
PurchasingGroup PurchasingGroup
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn
PurchasingIsBlockedForSupplier PurchasingIsBlockedForSupplier Pur. Block POrg
SupplierRespSalesPersonName SupplierRespSalesPersonName
SupplierPhoneNumber SupplierPhoneNumber
PurchaseOrderCurrency PurchaseOrderCurrency Order Currency
MinimumOrderAmount MinimumOrderAmount
CalculationSchemaGroupCode CalculationSchemaGroupCode
PaymentTerms PaymentTerms
PaymentTermsDescription _PaymentTermsDescription PaymentTermsName
PricingDateControl PricingDateControl
SupplierABCClassificationCode SupplierABCClassificationCode
ShippingCondition ShippingCondition
PurOrdAutoGenerationIsAllowed PurOrdAutoGenerationIsAllowed
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased
SupplierConfirmationControlKey SupplierConfirmationControlKey
IsOrderAcknRqd IsOrderAcknRqd
IncotermsClassification IncotermsClassification
IncotermsClassificationName _IncotermsClassfctnText IncotermsClassificationName
_Supplier _Supplier
_PurgOrganization _PurgOrganization
_IncotermsClassfctnText _IncotermsClassfctnText 
@AbapCatalog.sqlViewName: 'CSUPPLPURCH'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling.algorithm : #SESSION_VARIABLE

@EndUserText.label: 'SupplierPurchasingOrganization'

@Metadata.allowExtensions: true

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

@VDM.viewType: #CONSUMPTION

@UI.headerInfo:{
  typeName: 'Purchasing Organization',
  typeNamePlural: 'Purchasing Organizations',
  title:  { label:'Purchasing Organization', value: 'PurchasingOrganizationName' }
  }

define view C_Supplierpurchasingorg
  as select from I_SupplierPurchasingOrg
  association [0..1] to I_Supplier                     as _Supplier                on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_PurchasingOrganization       as _PurgOrganization        on  $projection.PurchasingOrganization = _PurgOrganization.PurchasingOrganization
  association [0..1] to C_IncotermsClassfctnTextVHTemp as _IncotermsClassfctnText  on  $projection.IncotermsClassification = _IncotermsClassfctnText.IncotermsClassification
                                                                                   and _IncotermsClassfctnText.Language    = $session.system_language

  association [0..1] to C_PaymentTermsTextVHTemp       as _PaymentTermsDescription on  $projection.PaymentTerms          = _PaymentTermsDescription.PaymentTerms
                                                                                   and _PaymentTermsDescription.Language = $session.system_language
{
      @ObjectModel.foreignKey.association: '_Supplier'
  key Supplier,
      @ObjectModel.text.element:'PurchasingOrganizationName'
  key PurchasingOrganization,
      _PurgOrganization.PurchasingOrganizationName,
      PurchasingGroup,
      MaterialPlannedDeliveryDurn,
      @EndUserText.label: 'Pur. Block POrg'
      PurchasingIsBlockedForSupplier,
      SupplierRespSalesPersonName,
      SupplierPhoneNumber,
      @EndUserText.label: 'Order Currency'
      PurchaseOrderCurrency,
      MinimumOrderAmount,
      CalculationSchemaGroupCode,
      PaymentTerms,
      _PaymentTermsDescription.PaymentTermsName as PaymentTermsDescription,
      PricingDateControl,
      SupplierABCClassificationCode,
      ShippingCondition,
      PurOrdAutoGenerationIsAllowed,
      InvoiceIsGoodsReceiptBased,
      SupplierConfirmationControlKey,
      IsOrderAcknRqd,
      @ObjectModel.text.element:'IncotermsClassificationName'
      IncotermsClassification,
      _IncotermsClassfctnText.IncotermsClassificationName,

      _Supplier,
      _PurgOrganization,
      _IncotermsClassfctnText
}

Learn More