P_JP_TradeCreditBalanceItems

DDL: P_JP_TRADECREDITBALANCEITEMS SQL: PJPTRCEITEMS Type: view CONSUMPTION

View for Trade Credit Check Detail Items

P_JP_TradeCreditBalanceItems is a Consumption CDS View that provides data about "View for Trade Credit Check Detail Items" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 22 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 1 association to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem Item from

Parameters (2)

NameTypeDefault
P_StartDate fis_period_date_from
P_EndDate fis_period_date_to

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AccountingDocument Header Item.CompanyCode = Header.CompanyCode and Item.AccountingDocument = Header.AccountingDocument and Item.FiscalYear = Header.FiscalYear

Annotations (9)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PJPTRCEITEMS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label View for Trade Credit Check Detail Items view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
PostingDate I_OperationalAcctgDocItem PostingDate
DocumentDate I_OperationalAcctgDocItem DocumentDate
CashDiscount1DueDate I_OperationalAcctgDocItem NetDueDate
ClearingDocFiscalYear I_OperationalAcctgDocItem ClearingDocFiscalYear
ClearingJournalEntryFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingAccountingDocument
ClearingJournalEntry I_OperationalAcctgDocItem ClearingJournalEntry
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction
FollowOnDocumentType I_OperationalAcctgDocItem FollowOnDocumentType
InvoiceReference I_OperationalAcctgDocItem InvoiceReference
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode
ClearingDate I_OperationalAcctgDocItem ClearingDate
ReverseDocument Header ReverseDocument 
@VDM.private: true
@VDM.viewType:  #CONSUMPTION
@AbapCatalog.preserveKey:true
@AbapCatalog.sqlViewName: 'PJPTRCEITEMS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'View for Trade Credit Check Detail Items'
define view P_JP_TradeCreditBalanceItems
 with parameters
   @Consumption.hidden: true
   P_StartDate: fis_period_date_from,
   @Consumption.hidden: true
   P_EndDate  : fis_period_date_to
/*     
   @Consumption.hidden: true
   P_StatryRptgEntity : srf_reporting_entity,
   @Consumption.hidden: true
   P_StatryRptCategory: srf_rep_cat_id,
   @Consumption.hidden: true
   P_StatryRptRunID   : srf_report_run_id  
*/
  as select from I_OperationalAcctgDocItem as Item
  association [1..1] to I_AccountingDocument as Header
                     on Item.CompanyCode        = Header.CompanyCode
                    and Item.AccountingDocument = Header.AccountingDocument
                    and Item.FiscalYear         = Header.FiscalYear                                                           
{
  key Item.CompanyCode,
  key Item.FiscalYear,
  key Item.AccountingDocument,
  key Item.AccountingDocumentItem,
              
      Item.PostingDate,
      Item.DocumentDate,
      Item.NetDueDate as CashDiscount1DueDate,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
      Item.ClearingDocFiscalYear,
      Item.ClearingJournalEntryFiscalYear,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'ClearingJournalEntry'    
      Item.ClearingAccountingDocument, 
      Item.ClearingJournalEntry,
      Item.SpecialGLCode,
      
      Item.IsUsedInPaymentTransaction,

      // V  Residual Item

      // Z  Partial  Item    

      // G  Credit memo

      // R  Credit memo and Reversed       

      Item.FollowOnDocumentType,       // BSEG-REBZT   


      Item.InvoiceReference,           // BSEG-REBZG

      Item.InvoiceItemReference,       // BSEG-REBZZ

      Item.InvoiceReferenceFiscalYear, // BSEG-REBZJ

      
      @Semantics.currencyCode:true
      Item.TransactionCurrency,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'   
      Item.AmountInTransactionCurrency,
      
      Item.DebitCreditCode,
      Item.ClearingDate,
      Header.ReverseDocument
      
}
  where ( Item.FinancialAccountType = 'D' or Item.FinancialAccountType = 'K')       
    and Item.PostingDate <= $parameters.P_EndDate
    and Item._CompanyCode.Country = 'JP'
    and ( ( Item._Customer.Country <> 'JP' and Item._Customer.Country <> '') or
          ( Item._Supplier.Country <> 'JP' and Item._Supplier.Country <> '') )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_OPERATIONALACCTGDOCITEM",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More