P_PrepaymentDocContractAmount

DDL: P_PREPAYMENTDOCCONTRACTAMOUNT SQL: PPMGCTRDOCAMT Type: view COMPOSITE

Prepayment Contract Document Amount

P_PrepaymentDocContractAmount is a Composite CDS View that provides data about "Prepayment Contract Document Amount" in SAP S/4HANA. It reads from 6 data sources and exposes 16 fields with key fields DocNumber, DocumentItemNumber.

6 data source(s) 16 fields

Data Sources (6)

SourceAliasJoin Type
I_PreAgrmtTradingContractStat ContractApplicationStatus inner
I_PrepayWrkCtrAllowedDocTypes DocTypes from
I_PreAgrmtTradingContract Document inner
I_PreAgrmtTradingContractItem DocumentItem inner
I_PrepaymentMaterial Material inner
I_PrepaymentWrkCtrLinkConfign WCPrcConfig inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPMGCTRDOCAMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Prepayment Contract Document Amount view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY DocNumber I_PreAgrmtTradingContract TradingContract
KEY DocumentItemNumber I_PreAgrmtTradingContractItem TradingContractItem
PrepaymentAgrmtRefDocument
CompanyCode I_PreAgrmtTradingContract CompanyCode
DocumentType I_PreAgrmtTradingContract TradingContractType
PrepaymentTotalAmt
PrepaymentTotalAmtCrcy I_PreAgrmtTradingContractItem TrdgContrTotalNetAmountCrcy
PrepaymentWrkCtrDocPricingOptn I_PrepaymentWrkCtrLinkConfign PrepaymentWrkCtrDocPricingOptn
Counterparty I_PreAgrmtTradingContract Counterparty
TrdgContrApplicationStatus I_PreAgrmtTradingContract TrdgContrApplicationStatus
PrepaymentRefDocItmValdFromDte I_PreAgrmtTradingContractItem PrepaymentRefDocItmValdFromDte
PrepaymentRefDocItmValdToDte I_PreAgrmtTradingContractItem PrepaymentRefDocItmValdToDte
Material I_PreAgrmtTradingContractItem Material
Commodity I_PrepaymentMaterial Commodity
OrderQuantity I_PreAgrmtTradingContractItem TradingContractItemQuantity
OrderQuantityUnit I_PreAgrmtTradingContractItem TrdgContractItemUnitOfMeasure 
@AbapCatalog.sqlViewName: 'PPMGCTRDOCAMT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm                   : #SESSION_VARIABLE
@VDM.private                                : true
@VDM.viewType                               : #COMPOSITE
@ObjectModel.usageType.sizeCategory         : #L
@ObjectModel.usageType.serviceQuality       : #C
@ObjectModel.usageType.dataClass            : #TRANSACTIONAL
@EndUserText.label: 'Prepayment Contract Document Amount'
define view P_PrepaymentDocContractAmount
  -- Valid Doc Types
  as select from I_PrepayWrkCtrAllowedDocTypes as DocTypes
  -- Document Header
    inner join   I_PreAgrmtTradingContract     as Document     on Document.TradingContractType = DocTypes.PrepaymentAgrmtRefDocumentType

  -- Trading Contract Status
    inner join             I_PreAgrmtTradingContractStat as ContractApplicationStatus on ContractApplicationStatus.ContractApplicationStatus = Document.TrdgContrApplicationStatus

  -- Pricing Options config
    inner join I_PrepaymentWrkCtrLinkConfign as WCPrcConfig  on WCPrcConfig.PrepaymentAgrmtWorkCenterType = DocTypes.PrepaymentAgrmtWorkCenterType
                                                                       and  WCPrcConfig.PrepaymentWrkCtrDocPricingOptn  = '03'
  -- Document Item
    inner join   I_PreAgrmtTradingContractItem as DocumentItem on DocumentItem.TradingContract = Document.TradingContract
  -- Material and Commodity
    inner join   I_PrepaymentMaterial  as Material on DocumentItem.Material = Material.Material
{
  key Document.TradingContract                                        as DocNumber,
  key DocumentItem.TradingContractItem                                as DocumentItemNumber,
      lpad( Document.TradingContract, 25, '0' )                       as PrepaymentAgrmtRefDocument,
      Document.CompanyCode                                            as CompanyCode,
      Document.TradingContractType                                    as DocumentType,
      @Semantics.amount.currencyCode: 'PrepaymentTotalAmtCrcy'
      cast( DocumentItem.TrdgContrTotalNetAmount as abap.curr(23,2) ) as PrepaymentTotalAmt,
      @Semantics.currencyCode: true
      DocumentItem.TrdgContrTotalNetAmountCrcy                        as PrepaymentTotalAmtCrcy,
      WCPrcConfig.PrepaymentWrkCtrDocPricingOptn,
      Document.Counterparty,
      Document.TrdgContrApplicationStatus,
      DocumentItem.PrepaymentRefDocItmValdFromDte,
      DocumentItem.PrepaymentRefDocItmValdToDte,
      DocumentItem.Material,
      Material.Commodity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      DocumentItem.TradingContractItemQuantity    as OrderQuantity,
      @Semantics.unitOfMeasure: true
      DocumentItem.TrdgContractItemUnitOfMeasure  as OrderQuantityUnit
}
where
      DocTypes.PrepaymentAgrmtWorkCenterType = '1'
  and DocTypes.PrepaymentAgrmtRefDocumentCat = 'TC'

Learn More