I_PURCONTRACTCLASSIFICATION

CDS View

Purchase Contract Classification

I_PURCONTRACTCLASSIFICATION is a CDS View in S/4HANA. Purchase Contract Classification. It contains 1 fields. 20 CDS views read from this table.

Used by 20 CDS view(s) 1 fields

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_ContractConsumption view inner CONSUMPTION Contract Consumption
C_ValueContractReleaseSts view inner CONSUMPTION Value Contract Release Status
P_Comonavg_Amount view inner COMPOSITE s
P_Comonavg_Quantity view inner COMPOSITE Contracts-MK type for Consumption and Target amt calculation
P_ContrWithRelevantValidity view inner COMPOSITE P-view to Fetch Purchase Contracts with Relevant Validity
P_POCountInQtyContract view inner CONSUMPTION Purchase Order Count in Quantity Contract
P_PurcContractLeakagePC view inner CONSUMPTION P_PurcContractLeakagePC
P_PurchaseContractItem1 view inner CONSUMPTION Purchase Contract Changes
P_PurchaseContractTargetAmount view inner CONSUMPTION Purchase Contract Target Amount
P_PurContractItemConsumption view inner CONSUMPTION Purchase Contract Item Consumption
P_QtyContractReleasedAmount view inner CONSUMPTION Quantity Contract Released Amount
P_QuantityContract view inner CONSUMPTION P_QuantityContract
P_QuantityContractWithHistory view inner CONSUMPTION Quantity Contract With History PAI
P_QuantityContractWithHistory1 view inner CONSUMPTION Quantity Contract with History Detail
P_QuantityContractWithPOCount view inner CONSUMPTION Quantity Contract With PO Count
P_QuantityContrWthUnusedAmtPAI view inner CONSUMPTION Quantity Contract with Unused Amount PAI
P_ReleaseAmtInValueContract1 view inner CONSUMPTION Release Amount Calc for Value Contract1
P_ReleaseDocumentationValues4 view inner CONSUMPTION Released Documentation Values 4
P_SourceOfSupply view inner CONSUMPTION Source of Supply
P_ValueContractReleasedAmount2 view inner CONSUMPTION Value Contract Released Amount 2

Fields (1)

KeyField CDS FieldsUsed in Views
PurchaseContractClassification PurchaseContractClassification 4 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@ObjectModel.representativeKey: 'PurchasingDocumentType'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S 
@AbapCatalog.sqlViewName: 'IPCCLASSFCTN'
@VDM.viewType: #BASIC 
@Analytics.dataCategory: #DIMENSION 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Purchase Contract Classification'

define view I_PurContractClassification 
 
 as select from t161 
 
 left outer join t162 
    on t161.brefn = t162.flref
     
{
    /* keys */
    key t161.bsart as PurchasingDocumentType,
    t161.brefn as PurgDocFieldSelControlKey,
    
    cast(case substring(faus1,15,1)     //Amount Type(WK)

        when '+' then '0'
        else case substring(faus1,51,1)     //Quantity Type(MK)

                when '+' then '1'
                else '2' 
             end 
    end as contracttype_d ) as PurchaseContractClassification
 
}
where t161.bstyp = 'K'

Learn More