I_SupplierPurchasingOrgTP
Supplier Purchasing Org - TP
I_SupplierPurchasingOrgTP is a Transactional CDS View that provides data about "Supplier Purchasing Org - TP" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerPurgOrg) and exposes 78 fields with key fields PurchasingOrganization, BusinessPartner, Supplier. It has 10 associations to related views. Part of development package VDM_MD_BP_RAP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartnerPurgOrg | SupplierPurchasingOrg | from |
Associations (10)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_BusinessPartnerTP_2 | _BusinessPartner | $projection.BusinessPartner = _BusinessPartner.BusinessPartner |
| [0..1] | I_PurchasingOrganization | _PurgOrganization | $projection.PurchasingOrganizationForEdit = _PurgOrganization.PurchasingOrganization |
| [0..1] | I_PurchasingGroup | _PurchasingGroup | $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup |
| [0..*] | I_CurrencyText | _CurrencyText | $projection.PurchaseOrderCurrency = _CurrencyText.Currency |
| [0..*] | C_SchemaGroupTextVHTemp | _SchemaGroupText | $projection.CalculationSchemaGroupCode = _SchemaGroupText.SchemaGroup |
| [0..*] | I_CustomerPaymentTermsText | _PaymentTermsText | $projection.PaymentTerms = _PaymentTermsText.CustomerPaymentTerms |
| [1..*] | C_Pricingdatecontroltextvhtemp | _PriceDateControlText | $projection.PricingDateControl = _PriceDateControlText.PricingDateControl |
| [0..*] | I_IncotermsVersionText | _IncotermsVersionText | $projection.IncotermsVersion = _IncotermsVersionText.IncotermsVersion |
| [0..*] | I_IncotermsClassificationText | _IncotermsClassfctnText | $projection.IncotermsClassification = _IncotermsClassfctnText.IncotermsClassification |
| [0..1] | I_LogisticalRoundingProfile | _LogisticalRoundingProfile | $projection.RoundingProfile = _LogisticalRoundingProfile.LogisticalRoundingProfile |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Supplier Purchasing Org - TP | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (78)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchasingOrganization | PurchasingOrganization | ||
| KEY | BusinessPartner | BusinessPartner | ||
| KEY | Supplier | Supplier | ||
| PurchasingOrganizationForEdit | PurchasingOrganization | |||
| BusinessPartnerForEdit | BusinessPartner | |||
| SupplierForEdit | Supplier | |||
| BusinessPartnerUUID | BusinessPartnerUUID | |||
| PurchasingGroup | PurchasingGroup | |||
| PlannedDeliveryDurationInDays | PlannedDeliveryDurationInDays | |||
| PurchasingIsBlockedForSupplier | PurchasingIsBlockedForSupplier | |||
| SupplierRespSalesPersonName | SupplierRespSalesPersonName | |||
| ContactPersonPhoneNumber | ContactPersonPhoneNumber | |||
| PurchaseOrderCurrency | PurchaseOrderCurrency | |||
| MinimumOrderAmount | MinimumOrderAmount | |||
| CalculationSchemaGroupCode | CalculationSchemaGroupCode | |||
| PaymentTerms | PaymentTerms | |||
| PricingDateControl | PricingDateControl | |||
| SupplierABCClassificationCode | SupplierABCClassificationCode | |||
| ShippingCondition | ShippingCondition | |||
| PurOrdAutoGenerationIsAllowed | PurOrdAutoGenerationIsAllowed | |||
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsVersion | IncotermsVersion | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| EvaldReceiptSettlementIsActive | EvaldReceiptSettlementIsActive | |||
| AutomaticEvaluatedRcptSettlmt | AutomaticEvaluatedRcptSettlmt | |||
| SupplierAccountNumber | SupplierAccountNumber | |||
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | |||
| IsOrderAcknRqd | IsOrderAcknRqd | |||
| SuplrIsSubjToSubsqntSettlement | SuplrIsSubjToSubsqntSettlement | |||
| SuplrPurgOrgAgrmtOfBusVolIsRqd | SuplrPurgOrgAgrmtOfBusVolIsRqd | |||
| SuplrInvcRevalIsAllowed | SuplrInvcRevalIsAllowed | |||
| SuplrPurgOrgIsRlvtForPriceDetn | SuplrPurgOrgIsRlvtForPriceDetn | |||
| IntrastatCrsBorderTrMode | IntrastatCrsBorderTrMode | |||
| ProductUnitGroup | ProductUnitGroup | |||
| RoundingProfile | RoundingProfile | |||
| PlanningCycle | PlanningCycle | |||
| SuplrDiscountInKindIsGranted | SuplrDiscountInKindIsGranted | |||
| SuplrIsRlvtForSettlmtMgmt | SuplrIsRlvtForSettlmtMgmt | |||
| InvoiceIsMMServiceEntryBased | InvoiceIsMMServiceEntryBased | |||
| ProdStockAndSlsDataTransfPrfl | ProdStockAndSlsDataTransfPrfl | |||
| EvaldRcptSettlementProfile | EvaldRcptSettlementProfile | |||
| AbsoluteHandlingSurchargeAmt | AbsoluteHandlingSurchargeAmt | |||
| PercentageHandlingSurchargeAmt | PercentageHandlingSurchargeAmt | |||
| MinimumHandlingSurchargeAmt | MinimumHandlingSurchargeAmt | |||
| MaximumHandlingSurchargeAmt | MaximumHandlingSurchargeAmt | |||
| AutomDebitCrtnIsEnbldOnGI | AutomDebitCrtnIsEnbldOnGI | |||
| IncotermsSupChnLoc2AddlUUID | IncotermsSupChnLoc2AddlUUID | |||
| IncotermsSupChnLoc1AddlUUID | IncotermsSupChnLoc1AddlUUID | |||
| IncotermsSupChnDvtgLocAddlUUID | IncotermsSupChnDvtgLocAddlUUID | |||
| BPHasActiveEntity | ||||
| DeletionIndicator | DeletionIndicator | |||
| IncotermsLocation1Identifier | _IncotermsSupChnLoc1 | Location | ||
| IncotermsLocation2Identifier | _IncotermsSupChnLoc2 | Location | ||
| IncotermsDvtgLocIdentifier | _IncotermsSupChnDvtgLoc | Location | ||
| SupplierAccountGroup | ||||
| SupplierAuthznGrp | ||||
| AuthorizationGroup | ||||
| IsBusinessPurposeCompleted | ||||
| _IncotermsSupChnDvtgLoc | _IncotermsSupChnDvtgLoc | |||
| _IncotermsSupChnLoc1 | _IncotermsSupChnLoc1 | |||
| _IncotermsSupChnLoc2 | _IncotermsSupChnLoc2 | |||
| _ShipgCndnValueHelp | _ShipgCndnValueHelp | |||
| _ShippingConditionText | _ShippingConditionText | |||
| _SupplierToPartner | _SupplierToPartner | |||
| _CurrencyText | _CurrencyText | |||
| _SchemaGroupText | _SchemaGroupText | |||
| _PaymentTermsText | _PaymentTermsText | |||
| _PriceDateControlText | _PriceDateControlText | |||
| _IncotermsVersionText | _IncotermsVersionText | |||
| _IncotermsClassfctnText | _IncotermsClassfctnText | |||
| _PurgOrganization | _PurgOrganization | |||
| _LogisticalRoundingProfile | _LogisticalRoundingProfile | |||
| _BusinessPartnerSupplier | _BusinessPartnerSupplier | |||
| _BusinessPartner | _BusinessPartner | |||
| _PurchasingGroup | _PurchasingGroup |
@EndUserText.label: 'Supplier Purchasing Org - TP'
@VDM.viewType: #TRANSACTIONAL
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #REQUIRED
}
@ObjectModel:{
usageType: {
serviceQuality: #C,
sizeCategory: #XXL,
dataClass: #TRANSACTIONAL
}
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_SupplierPurchasingOrgTP
as select from I_BusinessPartnerPurgOrg as SupplierPurchasingOrg
// composition [0..*] of I_SupplierPartnerFunctionTP_2 as _SupplierPartnerFunction
association to parent I_BusinessPartnerSupplierTP_2 as _BusinessPartnerSupplier on $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
and $projection.Supplier = _BusinessPartnerSupplier.Supplier
association [1..1] to I_BusinessPartnerTP_2 as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [0..1] to I_PurchasingOrganization as _PurgOrganization on $projection.PurchasingOrganizationForEdit = _PurgOrganization.PurchasingOrganization
association [0..1] to I_PurchasingGroup as _PurchasingGroup on $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
association [0..*] to I_CurrencyText as _CurrencyText on $projection.PurchaseOrderCurrency = _CurrencyText.Currency
association [0..*] to C_SchemaGroupTextVHTemp as _SchemaGroupText on $projection.CalculationSchemaGroupCode = _SchemaGroupText.SchemaGroup
association [0..*] to I_CustomerPaymentTermsText as _PaymentTermsText on $projection.PaymentTerms = _PaymentTermsText.CustomerPaymentTerms
association [1..*] to C_Pricingdatecontroltextvhtemp as _PriceDateControlText on $projection.PricingDateControl = _PriceDateControlText.PricingDateControl
association [0..*] to I_IncotermsVersionText as _IncotermsVersionText on $projection.IncotermsVersion = _IncotermsVersionText.IncotermsVersion
association [0..*] to I_IncotermsClassificationText as _IncotermsClassfctnText on $projection.IncotermsClassification = _IncotermsClassfctnText.IncotermsClassification
association [0..1] to I_LogisticalRoundingProfile as _LogisticalRoundingProfile on $projection.RoundingProfile = _LogisticalRoundingProfile.LogisticalRoundingProfile
{
key PurchasingOrganization,
key BusinessPartner,
key Supplier,
@ObjectModel.editableFieldFor: 'PurchasingOrganization'
PurchasingOrganization as PurchasingOrganizationForEdit,
@ObjectModel.editableFieldFor: 'BusinessPartner'
BusinessPartner as BusinessPartnerForEdit,
@ObjectModel.editableFieldFor: 'Supplier'
Supplier as SupplierForEdit,
BusinessPartnerUUID,
PurchasingGroup,
PlannedDeliveryDurationInDays,
PurchasingIsBlockedForSupplier,
SupplierRespSalesPersonName,
ContactPersonPhoneNumber,
PurchaseOrderCurrency,
MinimumOrderAmount,
CalculationSchemaGroupCode,
PaymentTerms,
PricingDateControl,
SupplierABCClassificationCode,
ShippingCondition,
PurOrdAutoGenerationIsAllowed,
InvoiceIsGoodsReceiptBased,
IncotermsClassification,
IncotermsTransferLocation,
IncotermsVersion,
IncotermsLocation1,
IncotermsLocation2,
EvaldReceiptSettlementIsActive,
AutomaticEvaluatedRcptSettlmt,
SupplierAccountNumber,
SupplierConfirmationControlKey,
IsOrderAcknRqd,
// IsActiveEntity,
SuplrIsSubjToSubsqntSettlement,
SuplrPurgOrgAgrmtOfBusVolIsRqd,
SuplrInvcRevalIsAllowed,
SuplrPurgOrgIsRlvtForPriceDetn,
IntrastatCrsBorderTrMode,
ProductUnitGroup,
RoundingProfile,
PlanningCycle,
SuplrDiscountInKindIsGranted,
SuplrIsRlvtForSettlmtMgmt,
InvoiceIsMMServiceEntryBased,
ProdStockAndSlsDataTransfPrfl,
EvaldRcptSettlementProfile,
AbsoluteHandlingSurchargeAmt,
PercentageHandlingSurchargeAmt,
MinimumHandlingSurchargeAmt,
MaximumHandlingSurchargeAmt,
AutomDebitCrtnIsEnbldOnGI,
IncotermsSupChnLoc2AddlUUID,
IncotermsSupChnLoc1AddlUUID,
IncotermsSupChnDvtgLocAddlUUID,
cast( 'X' as sdraft_is_active preserving type ) as BPHasActiveEntity,
DeletionIndicator,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_IncotermsSupChnLoc1.Location as IncotermsLocation1Identifier,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_IncotermsSupChnLoc2.Location as IncotermsLocation2Identifier,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
_IncotermsSupChnDvtgLoc.Location as IncotermsDvtgLocIdentifier,
_SupplierToPartner._Supplier.SupplierAccountGroup,
_SupplierToPartner._Supplier.AuthorizationGroup as SupplierAuthznGrp,
_SupplierToPartner._BusinessPartner.AuthorizationGroup,
_SupplierToPartner._BusinessPartner.IsBusinessPurposeCompleted,
/* Associations */
_IncotermsSupChnDvtgLoc,
_IncotermsSupChnLoc1,
_IncotermsSupChnLoc2,
_ShipgCndnValueHelp,
_ShippingConditionText,
_SupplierToPartner,
// _SupplierPartnerFunction,
_CurrencyText,
_SchemaGroupText,
_PaymentTermsText,
_PriceDateControlText,
_IncotermsVersionText,
_IncotermsClassfctnText,
_PurgOrganization, // for text for Purchasing Org
_LogisticalRoundingProfile,
_BusinessPartnerSupplier,
_BusinessPartner,
_PurchasingGroup // added for Purchasing group VH
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA