P_APInvoiceProcessingTime1

DDL: P_APINVOICEPROCESSINGTIME1 SQL: PFIAPINVPROTIME1 Type: view COMPOSITE

P_APInvoiceProcessingTime1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ReceivablesPayablesItem) and exposes 30 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 2 associations to related views.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_ReceivablesPayablesItem I_ReceivablesPayablesItem from

Parameters (1)

NameTypeDefault
P_TodayDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AccountingDocument _AccountingDocument $projection.AccountingDocument = _AccountingDocument.AccountingDocument and $projection.CompanyCode = _AccountingDocument.CompanyCode and $projection.FiscalYear = _AccountingDocument.FiscalYear
[1..1] I_SupplierCompany _SupplierCompany $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIAPINVPROTIME1 view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
ClearingDate ClearingDate
ClearingAccountingDocument ClearingAccountingDocument
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
DebitCreditCode DebitCreditCode
AmountInTransactionCurrency AmountInTransactionCurrency
IsSalesRelated IsSalesRelated
DueCalculationBaseDate DueCalculationBaseDate
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
NetPaymentDays NetPaymentDays
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
CashDiscountBaseAmount CashDiscountBaseAmount
CashDiscountAmount CashDiscountAmount
PostingDate PostingDate
TransactionCurrency TransactionCurrency
Supplier Creditor
FixedCashDiscount FixedCashDiscount
APARToleranceGroup _SupplierCompany APARToleranceGroup
TotalAmount
CashDiscountBaseAmount_t
ClearingYear
Today
AccountingDocumentCategory AccountingDocumentCategory
ReverseDocument _AccountingDocument ReverseDocument 
@AbapCatalog.sqlViewName: 'PFIAPINVPROTIME1'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view P_APInvoiceProcessingTime1
with parameters
  P_TodayDate : sydate
as select from I_ReceivablesPayablesItem
association [1..1] to I_AccountingDocument as _AccountingDocument on $projection.AccountingDocument = _AccountingDocument.AccountingDocument
                                                                 and $projection.CompanyCode = _AccountingDocument.CompanyCode
                                                                 and $projection.FiscalYear = _AccountingDocument.FiscalYear
association [1..1] to I_SupplierCompany as _SupplierCompany on $projection.Supplier = _SupplierCompany.Supplier and
                                                               $projection.CompanyCode = _SupplierCompany.CompanyCode                                                                           
{
    key CompanyCode,
    key AccountingDocument,
    key FiscalYear,
    key AccountingDocumentItem,
    ClearingDate,
    ClearingAccountingDocument,
    FinancialAccountType,
    SpecialGLCode,
    DebitCreditCode,
    AmountInTransactionCurrency,
    IsSalesRelated,
    DueCalculationBaseDate,
    CashDiscount1Days,
    CashDiscount2Days,
    NetPaymentDays,
    CashDiscount1Percent,
    CashDiscount2Percent,
    CashDiscountBaseAmount,
    CashDiscountAmount,
    PostingDate,
    TransactionCurrency,
    Creditor as Supplier,
    FixedCashDiscount,
    _SupplierCompany.APARToleranceGroup as APARToleranceGroup,
    
    -AmountInTransactionCurrency as TotalAmount,
    
    -CashDiscountBaseAmount as CashDiscountBaseAmount_t,
    
    substring(ClearingDate, 1, 4) as ClearingYear,
    
    :P_TodayDate as Today,
    
    AccountingDocumentCategory,
    
    _AccountingDocument.ReverseDocument
    
}                                                                  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"I_RECEIVABLESPAYABLESITEM",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_SUPPLIERCOMPANY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More