R_PURCHASECONTRACT

CDS View

Purchase Contract Base View

R_PURCHASECONTRACT is a CDS View in S/4HANA. Purchase Contract Base View. It contains 50 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 50 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_PurchaseContract view from BASIC Purchase Contract
I_PurchaseContractVersion view from COMPOSITE Purchase Contract Version
I_PurContrVersionHistory view inner BASIC Purchase Contract Version History
M_V_Purchctr_Output_Params view from Output Parameters for Purchase Contracts
P_ContrConsumptionPct view from COMPOSITE
P_PurContrHdrCndnValdty view inner BASIC
R_PPS_PurContrVersionHistory view_entity inner COMPOSITE Purchase Contract Version History
R_PurchaseContractItem view inner BASIC Purchase Contract Item Base view

Fields (50)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 2
_DocumentCurrency _DocumentCurrency 2
ActivePurchasingDocument ActivePurchasingDocument 2
CashDiscount1Days CashDiscount1Days 2
CashDiscount1Percent CashDiscount1Percent 2
CashDiscount2Days CashDiscount2Days 2
CashDiscount2Percent CashDiscount2Percent 2
CompanyCode CompanyCode 2
CorrespncExternalReference CorrespncExternalReference 2
CorrespncInternalReference CorrespncInternalReference 2
CreatedByUser PurchaseContractCreatedByUser 1
DocumentCurrency DocumentCurrency 2
ExchangeRateIsFixed ExchangeRateIsFixed 2
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 1
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 1
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 1
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 2
InvoicingParty InvoicingParty 2
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 2
LastChangeDateTime LastChangeDateTime 2
NetPaymentDays NetPaymentDays 2
PaymentTerms PaymentTerms 2
PurchaseContractTargetAmount OutlineAgreementTargetAmount,PurchaseContractTargetAmount 3
PurchaseContractType PurchaseContractType 3
PurchasingDocumentCategory PurchasingDocumentCategory 2
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 2
PurchasingDocumentName PurchasingDocumentName 2
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentVersion PurchasingDocumentVersion 2
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 2
PurchasingProcessingStatus PurchasingProcessingStatus 2
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts 2
PurgDocChangeRequestStatus PurgDocChangeRequestStatus 2
PurgDocIsChgVers PurgDocIsChgVers 2
PurgHasCatalogRelevantItems PurgHasCatalogRelevantItems 1
QuotationSubmissionDate QuotationSubmissionDate 2
ReleaseCode ReleaseCode 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 2
Supplier Supplier 2
SupplierPhoneNumber SupplierPhoneNumber 2
SupplierQuotation SupplierQuotation 2
SupplierRespSalesPersonName SupplierRespSalesPersonName 2
SupplyingSupplier SupplyingSupplier 2
ValidityEndDate PurContrValidityEndDate,ValidityEndDate 3
ValidityStartDate PurContrValidityStartDate,ValidityStartDate 3 
@AbapCatalog.sqlViewName: 'RPURCHASECTR'
@AbapCatalog.preserveKey:true
@VDM.viewType : #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchase Contract Base View'
@ObjectModel.representativeKey: 'PurchaseContract'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL


define view R_PurchaseContract
  as select from R_PurchasingDocument
{
  key cast (PurchasingDocument as vdm_purchasecontract preserving type) as PurchaseContract,

      PurchasingDocumentType                                            as PurchaseContractType,

      PurchasingDocumentCategory,

      LastChangeDateTime,

      @Semantics.businessDate.createdAt: true
      CreationDate,

      Supplier,

      CompanyCode,

      PurchasingOrganization,

      PurchasingGroup,

      @Semantics.currencyCode:true
      DocumentCurrency,

      IncotermsClassification,

      IncotermsTransferLocation,

      PaymentTerms,

      CashDiscount1Days,

      CashDiscount2Days,

      NetPaymentDays,

      CashDiscount1Percent,

      CashDiscount2Percent,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      TargetAmount                                                      as PurchaseContractTargetAmount,

      ValidityStartDate,

      ValidityEndDate,

      @ObjectModel.foreignKey.association: '_ReleaseCode'
      ReleaseCode,

      @Semantics.user.createdBy: true
      CreatedByUser,

      PurchasingDocumentDeletionCode,

      SupplyingSupplier,

      InvoicingParty,
      ExchangeRate,
      ExchangeRateIsFixed,
      QuotationSubmissionDate,
      SupplierQuotationExternalID                                       as SupplierQuotation,
      CorrespncExternalReference,
      CorrespncInternalReference,
      SupplierRespSalesPersonName,
      SupplierPhoneNumber,
      IncotermsVersion,
      IncotermsLocation1,
      IncotermsLocation2,
      IncotermsSupChnLoc1AddlUUID,
      IncotermsSupChnLoc2AddlUUID,
      IncotermsSupChnDvtgLocAddlUUID,
      PurchasingDocumentName,
      PurchasingDocumentOrigin,
      ReleaseIsNotCompleted,
      PurchasingProcessingStatus,
      ManualSupplierAddressID,
      IsEndOfPurposeBlocked,
      PurgDocExternalReference,

      // fields from product compliance

      PurgAggrgdProdCmplncSuplrSts,
      PurgAggrgdProdMarketabilitySts,
      PurgAggrgdSftyDataSheetStatus,
      PurgProdCmplncTotDngrsGoodsSts,
      
      PurgHasCatalogRelevantItems,
      //Versionining 

      ActivePurchasingDocument, 
      PurchasingDocumentVersion,
      PurgDocChangeRequestStatus,
      case PurgDocChangeRequestStatus
        when '2' then cast( 'X' as xfeld )
        else cast( '' as xfeld ) end                                           as PurgDocIsChgVers,      

      _PurchasingDocumentCategory,
      _PurchasingDocumentType,
      _IncotermsClassification,
      _Supplier,
      _CompanyCode,
      _PurchasingOrganization,
      _PurchasingGroup,
      _CreatedByUser,
      _DocumentCurrency,
      _ReleaseCode,
      _SupplyingSupplier,
      _InvoicingParty,
      _PaymentTerms
}
where
      PurchasingDocumentCategory = 'K'
  and IsEndOfPurposeBlocked      = ''
  and ( PurgDocChangeRequestStatus = '' or
        PurgDocChangeRequestStatus = '1' or
        PurgDocChangeRequestStatus = '2' or
        PurgDocChangeRequestStatus = '4' )     
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASINGDOCUMENT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_PAYMENTTERMS",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGDOCUMENTTYPE",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_RELEASECODE",
"I_SUPPLIER",
"I_USER"
],
"BASE":
[
"R_PURCHASINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More