P_IN_SuplrGSTHlthChk

DDL: P_IN_SUPLRGSTHLTHCHK Type: view_entity COMPOSITE Package: J1I_GST_LOG_APP
13 Fields 3 Data Sources

Supplier GST India Health Check

P_IN_SuplrGSTHlthChk is a Composite CDS View that provides data about "Supplier GST India Health Check" in SAP S/4HANA. It reads from 3 data sources (I_Supplier, I_SupplierCompany, I_IN_SupplierGSTHlthChkList) and exposes 13 fields with key fields CompanyCode, Supplier, IN_GSTHlthChkCategory, IN_GSTHealthCheck. Part of development package J1I_GST_LOG_APP.

Data Sources (3)

SourceAliasJoin Type
I_Supplier I_Supplier inner
I_SupplierCompany I_SupplierCompany from
I_IN_SupplierGSTHlthChkList SuplrMasterCheckList cross

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Supplier GST India Health Check view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SupplierCompany CompanyCode Receiver Company Code
KEY Supplier I_SupplierCompany Supplier Supplier
KEY IN_GSTHlthChkCategory I_IN_SupplierGSTHlthChkList IN_GSTHlthChkCategory
KEY IN_GSTHealthCheck I_IN_SupplierGSTHlthChkList IN_GSTHealthCheck
CompanyCodeName
BPSupplierFullName I_Supplier BPSupplierFullName
BusinessPartner
IN_GSTHlthChkCatFldName I_IN_SupplierGSTHlthChkList IN_GSTHlthChkCatFldName
IN_GSTHealthCheckCatDesc I_IN_SupplierGSTHlthChkList IN_GSTHealthCheckCatDesc
TaxNumber3
charXendasIN_SuplrHasGSTHlthChkErr
char100elseendasIN_GSTHlthChkCatFldVal
IN_GSTHlthChkCrrtnStp I_IN_SupplierGSTHlthChkList IN_GSTHlthChkCrrtnStp

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_SuplrGSTHlthChk.
-- 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_SuplrGSTHlthChk AS
SELECT
  I_SupplierCompany.CompanyCode AS CompanyCode,
  I_SupplierCompany.Supplier AS Supplier,
  SuplrMasterCheckList.IN_GSTHlthChkCategory AS IN_GSTHlthChkCategory,
  SuplrMasterCheckList.IN_GSTHealthCheck AS IN_GSTHealthCheck,
  I_SupplierCompany._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_Supplier.BPSupplierFullName AS BPSupplierFullName,
  I_Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  SuplrMasterCheckList.IN_GSTHlthChkCatFldName AS IN_GSTHlthChkCatFldName,
  SuplrMasterCheckList.IN_GSTHealthCheckCatDesc AS IN_GSTHealthCheckCatDesc,
  replace_regexpr( pcre => abap.sstring'[A-Za-z0-9]', value => I_Supplier.TaxNumber3, with => abap.char'Z', result_length => abap.int1'15' ) AS TaxNumber3,
  case when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'001' and SuplrMasterCheckList.IN_GSTHealthCheck = abap.char'00001' and I_Supplier.IN_GSTSupplierClassification <> abap.char'0' and I_Supplier.TaxNumber3 is initial then abap.char'X' when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'001' and SuplrMasterCheckList.IN_GSTHealthCheck = abap.char'00002' and I_Supplier.TaxNumber3 is not initial and I_IN_GSTStateCodeMap.IN_GSTLegalStateCode is not initial and substring(I_Supplier.TaxNumber3, 1, 2 ) <> I_IN_GSTStateCodeMap.IN_GSTLegalStateCode then abap.char'X' when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'001' and SuplrMasterCheckList.IN_GSTHealthCheck = abap.char'00003' and I_Supplier.TaxNumber3 is not initial and length(I_Supplier.TaxNumber3) <> abap.int1'15' then abap.char'X' when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'001' and SuplrMasterCheckList.IN_GSTHealthCheck = abap.char'00004' and I_Supplier.TaxNumber3 is not initial and length(I_Supplier.TaxNumber3) = abap.int1'15' and TaxNumber3 <> abap.char'ZZZZZZZZZZZZZZZ' then abap.char'X' when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'002' and SuplrMasterCheckList.IN_GSTHealthCheck = abap.char'00001' and I_IN_GSTStateCodeMap.IN_GSTLegalStateCode is null then abap.char'X' when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'003' and SuplrMasterCheckList.IN_GSTHealthCheck = abap.char'00001' and I_Supplier.BusinessPartnerName1 is initial then abap.char'X' end as IN_SuplrHasGSTHlthChkErr AS charXendasIN_SuplrHasGSTHlthChkErr,
  case when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'001' then cast( I_Supplier.TaxNumber3 as abap.char (100) ) when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'002' then cast( I_IN_GSTStateCodeMap.IN_GSTLegalStateCode as abap.char (100) ) when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'003' then cast( I_Supplier.BusinessPartnerName1 as abap.char (100) ) when SuplrMasterCheckList.IN_GSTHlthChkCategory = abap.char'015' then cast( I_Supplier.IN_GSTSupplierClassification as abap.char (100) ) else '' end as IN_GSTHlthChkCatFldVal AS char100elseendasIN_GSTHlthChkCatFldVal,
  SuplrMasterCheckList.IN_GSTHlthChkCrrtnStp AS IN_GSTHlthChkCrrtnStp
FROM I_SupplierCompany
INNER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
CROSS JOIN I_IN_SupplierGSTHlthChkList AS SuplrMasterCheckList
;

Learn More