FARMLVD_ACCDOCITM

DDL: FARMLVD_ACCDOCITM SQL: FMLVACCDOCITM Type: view

Accounting Document Key

FARMLVD_ACCDOCITM is a CDS View that provides data about "Accounting Document Key" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 18 fields.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FMLVACCDOCITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Accounting Document Key view

Fields (18)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
AccountingDocument AccountingDocument
AccountingDocumentItem AccountingDocumentItem
FiscalYear FiscalYear
ClearingAccountingDocument ClearingAccountingDocument
ClearingDate ClearingDate
ClearingDocFiscalYear ClearingDocFiscalYear
AssignmentReference AssignmentReference
PostingKey PostingKey
FinancialAccountType FinancialAccountType
GLAccount GLAccount
DebitCreditCode DebitCreditCode
AmountInTransactionCurrency AmountInTransactionCurrency
InvoiceReference InvoiceReference
Customer Customer
IsUsedInPaymentTransaction IsUsedInPaymentTransaction
IsAutomaticallyCreated IsAutomaticallyCreated
NetPaymentAmount NetPaymentAmount 
@AbapCatalog.sqlViewName: 'FMLVACCDOCITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
//@VDM.viewType: #BASIC

@EndUserText.label: 'Accounting Document Key'
define view FARMLVD_ACCDOCITM as select from I_OperationalAcctgDocItem {
    CompanyCode,
    AccountingDocument,
    AccountingDocumentItem, 
    FiscalYear,           
    ClearingAccountingDocument,
    ClearingDate,              
    ClearingDocFiscalYear,     
    AssignmentReference,       
    PostingKey,                
    FinancialAccountType,      
    GLAccount,                 
    DebitCreditCode,           
    AmountInTransactionCurrency,
    InvoiceReference,           
    Customer,
    IsUsedInPaymentTransaction,
    IsAutomaticallyCreated,
    NetPaymentAmount                    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More