I_CONTSUBITEM

CDS View

CONSUMPTION VIEW for wbhd

I_CONTSUBITEM is a CDS View in S/4HANA. CONSUMPTION VIEW for wbhd. It contains 20 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 20 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ACMTrdgContrItmInfo view inner COMPOSITE Interface view for Tradg Cont Item Info
I_ContItem view inner COMPOSITE Contract Item
P_ACMTrdgContrHdr view inner COMPOSITE Trading Contract Header
P_TradingContractBusinessDets view from COMPOSITE

Fields (20)

KeyField CDS FieldsUsed in Views
KEY TradingContractNumber TradingContractNumber 1
ACMCustomerReference ACMCustomerReference 2
ACMPurgIncotermsPart1 ACMPurgIncotermsPart1,Incoterms 3
ACMSlsIncotermsPart1 ACMSlsIncotermsPart1,Incoterms 3
ACMSupplyingPlant ACMSupplyingPlant 1
ACMYourReference ACMYourReference 2
PricingDocument PricingDocument 2
PurchaseOrderSupplier PurchaseOrderSupplier 1
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
TradingContractCurrency TradingContractCurrency 2
TradingContractItem TradingContractItem 1
TrdgContrCommoditySubitem TrdgContrCommoditySubitem 1
TrdgContrPurgIncotermsLoc1Text IncotermsLocation1,TrdgContrPurgIncotermsLoc1Text 2
TrdgContrPurgIncotermsVersion TrdgContrPurgIncotermsVersion 1
TrdgContrPurgPaymentTerms PaymentTerms,TrdgContrPurgPaymentTerms 2
TrdgContrSalesIncotermsVersion TrdgContrSalesIncotermsVersion 1
TrdgContrSalesPaymentTerms PaymentTerms,TrdgContrSalesPaymentTerms 2
TrdgContrSlsIncotermsLoc1Text IncotermsLocation1,TrdgContrSlsIncotermsLoc1Text 2
TrdgContrSlsIncotermsLoc2Text TrdgContrSlsIncotermsLoc2Text 1 
 @AbapCatalog.sqlViewName: 'PCONTRACTSUBITEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CONSUMPTION VIEW for wbhd' 
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
--@VDM.private: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
/*@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'P_CONTSUBITEM'
define view I_ContSubItem as select * from wbhd where tposn = '000000' */
                                                     
define view I_ContSubItem as select from P_ContSubItem
{
key TKONN   as  TradingContractNumber ,
key TPOSN   as  TradingContractItem ,
key TPOSN_SUB as TrdgContrCommoditySubitem ,
    ELIFN   as  PurchaseOrderSupplier   ,
    EKORG   as  PurchasingOrganization  ,
    EKGRP   as  PurchasingGroup ,
    WAERS_PURCH as  TradingContractCurrency ,    
    INCOV_SD    as  TrdgContrSalesIncotermsVersion  , 
    INCO2_L_SD  as  TrdgContrSlsIncotermsLoc1Text   ,
    INCO3_L_SD  as  TrdgContrSlsIncotermsLoc2Text   ,
    INCOV_MM    as  TrdgContrPurgIncotermsVersion   ,
    INCO2_L_MM  as  TrdgContrPurgIncotermsLoc1Text  ,
    //INCO3_L_MM  as  TrdgContrPurgIncotermsLoc2Text  ,    

    KNUMV_MM    as  PricingDocument ,
    INCO1_MM as  ACMPurgIncotermsPart1,
    //INCO2_MM as  ACMPurgIncotermsPart2,

    INCO1_SD as  ACMSlsIncotermsPart1 ,
    ZTERM as TrdgContrPurgPaymentTerms,
    ZTERM_SALES as TrdgContrSalesPaymentTerms,
    //INCO2_SD as  ACMSlsIncotermsPart2 

    RESWK    as  ACMSupplyingPlant ,
    IHREZ    as  ACMYourReference ,
    BSTKD    as  ACMCustomerReference
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CONTSUBITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More