I_SupplierPurchasingOrgTP

DDL: I_SUPPLIERPURCHASINGORGTP Type: view_entity TRANSACTIONAL Package: VDM_MD_BP_RAP

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)

SourceAliasJoin Type
I_BusinessPartnerPurgOrg SupplierPurchasingOrg from

Associations (10)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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


}