A_SupplierPurchasingOrg

DDL: A_SUPPLIERPURCHASINGORG SQL: ASUPPLPURCH Type: view BASIC Package: ODATA_MASTER_DATA_BP
46 Fields 1 Data Sources 2 Associations

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.

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 Supplier
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
AutomaticEvaluatedRcptSettlmt AutomaticEvaluatedRcptSettlmt Aut. GRSet Ret
CalculationSchemaGroupCode CalculationSchemaGroupCode Schema Grp Supp
DeletionIndicator DeletionIndicator Deletion Ind.
EvaldReceiptSettlementIsActive EvaldReceiptSettlementIsActive ERS
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsVersion IncotermsVersion Inco. Version
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID Location UUID
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID Location UUID
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID Location UUID
IntrastatCrsBorderTrMode IntrastatCrsBorderTrMode Mode of Trans.
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
InvoiceIsMMServiceEntryBased InvoiceIsMMServiceEntryBased Srv.-Based Inv. Ver.
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
MinimumOrderAmount MinimumOrderAmount Minimum value
PaymentTerms PaymentTerms Pyt Terms
PlanningCycle PlanningCycle Planning Cycle
PricingDateControl PricingDateControl Pr. Date Cat.
ProdStockAndSlsDataTransfPrfl ProdStockAndSlsDataTransfPrfl PROACT control prof
ProductUnitGroup ProductUnitGroup UoM Group
PurOrdAutoGenerationIsAllowed PurOrdAutoGenerationIsAllowed Automatic PO
PurchaseOrderCurrency PurchaseOrderCurrency Order currency
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingIsBlockedForSupplier PurchasingIsBlockedForSupplier Pur. block POrg
RoundingProfile RoundingProfile Rnding Profile
ShippingCondition ShippingCondition Shipping Conditions
SuplrDiscountInKindIsGranted SuplrDiscountInKindIsGranted Checkbox
SuplrInvcRevalIsAllowed SuplrInvcRevalIsAllowed Revaluation
SuplrIsRlvtForSettlmtMgmt SuplrIsRlvtForSettlmtMgmt Settlem. Mgmt.
SuplrPurgOrgIsRlvtForPriceDetn SuplrPurgOrgIsRlvtForPriceDetn Price determin.
SupplierABCClassificationCode SupplierABCClassificationCode ABC indicator
SupplierAccountNumber SupplierAccountNumber Acc. w. supplier
SupplierIsReturnsSupplier SupplierIsReturnsSupplier Returns supplier
SupplierPhoneNumber SupplierPhoneNumber Telephone
SupplierRespSalesPersonName SupplierRespSalesPersonName Salesperson
SupplierConfirmationControlKey SupplierConfirmationControlKey Conf. Control
IsOrderAcknRqd IsOrderAcknRqd Acknowl. Reqd.
AuthorizationGroup _Supplier AuthorizationGroup AuthorizGroup
SupplierAccountGroup _Supplier SupplierAccountGroup Account group
_PartnerFunction _PartnerFunction
_Supplier _Supplier
_PurchasingOrgText _PurchasingOrgText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_SupplierPurchasingOrg.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ASUPPLPURCH

CREATE VIEW A_SupplierPurchasingOrg AS
SELECT
  Supplier,
  PurchasingOrganization,
  AutomaticEvaluatedRcptSettlmt,
  CalculationSchemaGroupCode,
  DeletionIndicator,
  EvaldReceiptSettlementIsActive,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  IntrastatCrsBorderTrMode,
  InvoiceIsGoodsReceiptBased,
  InvoiceIsMMServiceEntryBased,
  MaterialPlannedDeliveryDurn,
  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 AS AuthorizationGroup,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup
FROM I_SupplierPurchasingOrg
LEFT OUTER JOIN E_BPPURORG_D AS _PurchasingExtension ON Supplier = _PurchasingExtension.Supplier AND PurchasingOrganization = _PurchasingExtension.PurchasingOrganization association[1..1] to A_Supplier as _Supplier on Supplier = _Supplier.Supplier association[0..*] to A_SupplierPartnerFunc as _PartnerFunction on Supplier = _PartnerFunction.Supplier AND PurchasingOrganization = _PartnerFunction.PurchasingOrganization AND _PartnerFunction.Plant = '' AND _PartnerFunction.SupplierSubrange = ''  -- association [0..1]
LEFT OUTER JOIN A_SupplierPurchasingOrgText AS _PurchasingOrgText ON Supplier = _PurchasingOrgText.Supplier AND PurchasingOrganization = _PurchasingOrgText.PurchasingOrganization  -- association [0..*]
;

Learn More