P_CAClearingDocument

DDL: P_CACLEARINGDOCUMENT SQL: PCLRINGDOC Type: view COMPOSITE

Clearing Document

P_CAClearingDocument is a Composite CDS View that provides data about "Clearing Document" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentHeader, I_CADocumentBPItemPhysical) and exposes 11 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_CADocumentHeader _DocHeader inner
I_CADocumentBPItemPhysical _DocItem from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PCLRINGDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Clearing Document view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItemPhysical CADocumentNumber
KEY CARepetitionItemNumber I_CADocumentBPItemPhysical CARepetitionItemNumber
KEY CABPItemNumber I_CADocumentBPItemPhysical CABPItemNumber
KEY CASubItemNumber I_CADocumentBPItemPhysical CASubItemNumber
CAClearingDocumentNumber I_CADocumentBPItemPhysical CAClearingDocumentNumber
CAClearingRestrictionCode I_CADocumentBPItemPhysical CAClearingRestrictionCode
CAAmountInTransactionCurrency I_CADocumentBPItemPhysical CAAmountInTransactionCurrency
CAClearingAmountInClearingCrcy I_CADocumentBPItemPhysical CAClearingAmountInClearingCrcy
TransactionCurrency I_CADocumentBPItemPhysical TransactionCurrency
CADocumentNumberOfOriginItem I_CADocumentBPItemPhysical CADocumentNumberOfOriginItem
CAClearingCurrency I_CADocumentBPItemPhysical CAClearingCurrency 
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PCLRINGDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Clearing Document'
@VDM.private: true
define view P_CAClearingDocument as select from I_CADocumentBPItemPhysical as _DocItem
    inner join I_CADocumentHeader as _DocHeader 
    on _DocItem.CADocumentNumber = _DocHeader.CADocumentNumber
{
    key _DocItem.CADocumentNumber,
    key _DocItem.CARepetitionItemNumber,
    key _DocItem.CABPItemNumber,
    key _DocItem.CASubItemNumber,
    _DocItem.CAClearingDocumentNumber,
    _DocItem.CAClearingRestrictionCode,
    _DocItem.CAAmountInTransactionCurrency,
    _DocItem.CAClearingAmountInClearingCrcy,
    _DocItem.TransactionCurrency,
    _DocItem.CADocumentNumberOfOriginItem,
    _DocItem.CAClearingCurrency    
}
where _DocHeader.CAClearingInformation <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENTBPITEMPHYSICAL",
"I_CADOCUMENTHEADER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More