P_IN_IncgInvcAcctgDocHlthChk

DDL: P_IN_INCGINVCACCTGDOCHLTHCHK Type: view_entity COMPOSITE
39 Fields 6 Data Sources

P_IN_IncgInvcAcctgDocHlthChk is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 39 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, IN_GSTHlthChkCategory.

Data Sources (6)

SourceAliasJoin Type
I_OperationalAcctgDocItem IncgInvcAccDocTaxItem union
I_IN_IncgInvcAPItmHlthChklst IncgInvcAPHlthChk cross
I_IN_IncgInvcAcctPyblItem IncgInvcAPItem from
I_IN_IncgInvcRevnItmHlthChklst IncgInvcRevnHlthChk cross
I_OperationalAcctgDocItem IncgInvcRevnItem union
I_IN_IncgInvcTxItmHlthChklst IncgInvcTaxHlthChk cross

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_IN_IncgInvcAcctPyblItem CompanyCode Receiver Company Code
KEY AccountingDocument I_IN_IncgInvcAcctPyblItem AccountingDocument Journal Entry
KEY FiscalYear I_IN_IncgInvcAcctPyblItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem Posting View Item
KEY IN_GSTHlthChkCategory I_IN_IncgInvcAPItmHlthChklst IN_GSTHlthChkCategory
KEY IN_GSTHealthCheck I_IN_IncgInvcAPItmHlthChklst IN_GSTHealthCheck
IN_GSTHlthChkCatFldName I_IN_IncgInvcAPItmHlthChklst IN_GSTHlthChkCatFldName
IN_GSTHealthCheckCatDesc I_IN_IncgInvcAPItmHlthChklst IN_GSTHealthCheckCatDesc
DocumentDate I_IN_IncgInvcAcctPyblItem DocumentDate Journal Entry Date
PostingDate I_IN_IncgInvcAcctPyblItem PostingDate Posting Date for GR
IN_HSNOrSACCode I_IN_IncgInvcAcctPyblItem IN_HSNOrSACCode HSN/SAC Code
charXendasIN_AcctgDocHasGSTHlthChkErr
char100endasIN_GSTHlthChkCatFldVal
CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
KEY IN_GSTHlthChkCategory I_IN_IncgInvcRevnItmHlthChklst IN_GSTHlthChkCategory
KEY IN_GSTHealthCheck I_IN_IncgInvcRevnItmHlthChklst IN_GSTHealthCheck
IN_GSTHlthChkCatFldName I_IN_IncgInvcRevnItmHlthChklst IN_GSTHlthChkCatFldName
IN_GSTHealthCheckCatDesc I_IN_IncgInvcRevnItmHlthChklst IN_GSTHealthCheckCatDesc
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
IN_HSNOrSACCode HSN/SAC Code
charXendasIN_AcctgDocHasGSTHlthChkErr
BaseUnitendasIN_GSTHlthChkCatFldVal
CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
KEY IN_GSTHlthChkCategory I_IN_IncgInvcTxItmHlthChklst IN_GSTHlthChkCategory
KEY IN_GSTHealthCheck I_IN_IncgInvcTxItmHlthChklst IN_GSTHealthCheck
IN_GSTHlthChkCatFldName I_IN_IncgInvcTxItmHlthChklst IN_GSTHlthChkCatFldName
IN_GSTHealthCheckCatDesc I_IN_IncgInvcTxItmHlthChklst IN_GSTHealthCheckCatDesc
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
IN_HSNOrSACCode I_OperationalAcctgDocItem IN_HSNOrSACCode HSN/SAC Code
charXendasIN_AcctgDocHasGSTHlthChkErr
char100endasIN_GSTHlthChkCatFldVal

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_IN_IncgInvcAcctgDocHlthChk.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_IN_IncgInvcAcctgDocHlthChk AS
SELECT
  IncgInvcAPItem.CompanyCode AS CompanyCode,
  IncgInvcAPItem.AccountingDocument AS AccountingDocument,
  IncgInvcAPItem.FiscalYear AS FiscalYear,
  cast ( IncgInvcAPItem.AccountingDocumentItem as buzei preserving type ) AS AccountingDocumentItem,
  IncgInvcAPHlthChk.IN_GSTHlthChkCategory AS IN_GSTHlthChkCategory,
  IncgInvcAPHlthChk.IN_GSTHealthCheck AS IN_GSTHealthCheck,
  IncgInvcAPHlthChk.IN_GSTHlthChkCatFldName AS IN_GSTHlthChkCatFldName,
  IncgInvcAPHlthChk.IN_GSTHealthCheckCatDesc AS IN_GSTHealthCheckCatDesc,
  IncgInvcAPItem.DocumentDate AS DocumentDate,
  IncgInvcAPItem.PostingDate AS PostingDate,
  IncgInvcAPItem.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  case when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'016' and IncgInvcAPHlthChk.IN_GSTHealthCheck = abap.char'00001' and IncgInvcAPItem._Supplier.IN_GSTSupplierClassification = '0' and RCMIncgInvcAcctgDoc.IN_AcctgDocHasRvsChrgTxCndn = abap.char'X' and IncgInvcAPItem._JournalEntry.AlternativeReferenceDocument is initial then abap.char'X' when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'009' and IncgInvcAPHlthChk.IN_GSTHealthCheck = abap.char'00001' and IncgInvcAPItem.IN_GSTPartner is initial then abap.char'X' when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'010' and IncgInvcAPHlthChk.IN_GSTHealthCheck = abap.char'00001' and IncgInvcAPItem.IN_GSTPlaceOfSupply is initial then abap.char'X' when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'011' and IncgInvcAPHlthChk.IN_GSTHealthCheck = abap.char'00001' and IncgInvcAPItem.BusinessPlace is initial then abap.char'X' end as IN_AcctgDocHasGSTHlthChkErr AS charXendasIN_AcctgDocHasGSTHlthChkErr,
  case when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'016' then cast(IncgInvcAPItem._JournalEntry.AlternativeReferenceDocument as abap.char( 100 )) when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'009' then cast(IncgInvcAPItem.IN_GSTPartner as abap.char( 100 )) when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'010' then cast(IncgInvcAPItem.IN_GSTPlaceOfSupply as abap.char(100)) when IncgInvcAPHlthChk.IN_GSTHlthChkCategory = abap.char'011' then cast(IncgInvcAPItem.BusinessPlace as abap.char( 100 )) end as IN_GSTHlthChkCatFldVal AS char100endasIN_GSTHlthChkCatFldVal,
  case when IncgInvcRevnHlthChk.IN_GSTHlthChkCategory = abap.char'007' then cast(IncgInvcRevnItem.IN_HSNOrSACCode as abap.char(100)) when IncgInvcRevnHlthChk.IN_GSTHlthChkCategory = abap.char'014' then cast(IncgInvcRevnItem.Quantity as abap.char( 100 )) when IncgInvcRevnHlthChk.IN_GSTHlthChkCategory = abap.char'013' then IncgInvcRevnItem.BaseUnit end as IN_GSTHlthChkCatFldVal AS BaseUnitendasIN_GSTHlthChkCatFldVal
FROM I_IN_IncgInvcAcctPyblItem AS IncgInvcAPItem
CROSS JOIN I_IN_IncgInvcAPItmHlthChklst AS IncgInvcAPHlthChk
CROSS JOIN I_IN_IncgInvcRevnItmHlthChklst AS IncgInvcRevnHlthChk
CROSS JOIN I_IN_IncgInvcTxItmHlthChklst AS IncgInvcTaxHlthChk
-- UNION with additional select branch(es): I_OperationalAcctgDocItem, I_OperationalAcctgDocItem
;

Learn More