I_CN_TaxInvcBindgHdr

DDL: I_CN_TAXINVCBINDGHDR Type: view BASIC

China Tax Invoice Reuse Bind Header

I_CN_TaxInvcBindgHdr is a Basic CDS View that provides data about "China Tax Invoice Reuse Bind Header" in SAP S/4HANA. It reads from 1 data source (P_CN_TaxInvcBindgHdr) and exposes 8 fields with key field CN_TaxInvcBindgUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CN_TaxInvcBindgHdr _header from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CN_TaxInvcBindgItm _Item $projection.CN_TaxInvcBindgUUID = _Item.CN_TaxInvcBindgUUID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ICNTXIBNDGHDR view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private false view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label China Tax Invoice Reuse Bind Header view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxInvcBindgUUID P_CN_TaxInvcBindgHdr CN_TaxInvcBindgUUID Invoice Binding UUID
CN_TaxInvcBindgSrceBusObjKey P_CN_TaxInvcBindgHdr CN_TaxInvcBindgSrceBusObjKey Binding Src BO Key
CN_TaxInvcBindgSrceBusObjType P_CN_TaxInvcBindgHdr CN_TaxInvcBindgSrceBusObjType Binding Src BO Type
CreatedByUser P_CN_TaxInvcBindgHdr CreatedByUser User Name
CreationUTCDateTime P_CN_TaxInvcBindgHdr CreationUTCDateTime Time Stamp
LastChangedByUser P_CN_TaxInvcBindgHdr LastChangedByUser User Name
LastChangeDateTime P_CN_TaxInvcBindgHdr LastChangeDateTime Timestamp
_Item _Item

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 I_CN_TaxInvcBindgHdr.
-- 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 I_CN_TaxInvcBindgHdr AS
SELECT
  _header.CN_TaxInvcBindgUUID AS CN_TaxInvcBindgUUID,
  _header.CN_TaxInvcBindgSrceBusObjKey AS CN_TaxInvcBindgSrceBusObjKey,
  _header.CN_TaxInvcBindgSrceBusObjType AS CN_TaxInvcBindgSrceBusObjType,
  _header.CreatedByUser AS CreatedByUser,
  _header.CreationUTCDateTime AS CreationUTCDateTime,
  _header.LastChangedByUser AS LastChangedByUser,
  _header.LastChangeDateTime AS LastChangeDateTime
FROM P_CN_TaxInvcBindgHdr AS _header
LEFT OUTER JOIN I_CN_TaxInvcBindgItm AS _Item ON CN_TaxInvcBindgUUID = _Item.CN_TaxInvcBindgUUID  -- association [0..*]
;