P_CN_InputVATDeclnInvcBind

DDL: P_CN_INPUTVATDECLNINVCBIND SQL: PCNDECLNINVCBIND Type: view BASIC
5 Fields 2 Data Sources

P_CN_InputVATDeclnInvcBind is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (txi_bnd_hdr, txi_bnd_itm) and exposes 5 fields with key field CN_TaxInvcBindgItmUUID.

Data Sources (2)

SourceAliasJoin Type
txi_bnd_hdr header left_outer
txi_bnd_itm item from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCNDECLNINVCBIND view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxInvcBindgItmUUID txi_bnd_itm binding_item_uuid Binding Item UUID
CN_TaxInvcUUID txi_bnd_itm invc_uuid Invoice UUID
CN_TaxInvcBindgUUID txi_bnd_itm binding_uuid Invoice Binding UUID
CN_TaxInvcBindgSrceBusObjKey txi_bnd_hdr source_bo_key Binding Src BO Key
CN_TaxInvcBindgSrceBusObjType txi_bnd_hdr source_bo_type Binding Src BO Type

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_CN_InputVATDeclnInvcBind.
-- 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.
-- SQL view name: PCNDECLNINVCBIND

CREATE VIEW P_CN_InputVATDeclnInvcBind AS
SELECT
  item.binding_item_uuid AS CN_TaxInvcBindgItmUUID,
  item.invc_uuid AS CN_TaxInvcUUID,
  item.binding_uuid AS CN_TaxInvcBindgUUID,
  header.source_bo_key AS CN_TaxInvcBindgSrceBusObjKey,
  header.source_bo_type AS CN_TaxInvcBindgSrceBusObjType
FROM txi_bnd_itm AS item
LEFT OUTER JOIN txi_bnd_hdr AS header ON /* join condition not captured in parsed metadata */
;

Learn More