I_JITOutbGoodsPostingTP

DDL: I_JITOUTBGOODSPOSTINGTP SQL: IJITOUTGDPTNGTP Type: view TRANSACTIONAL
16 Fields 1 Associations

Transcational view for Goods Posting

I_JITOutbGoodsPostingTP is a Transactional CDS View that provides data about "Transcational view for Goods Posting" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_JITOutbMaterialGoodsPostgTP _JITOutbMaterialGoodsPostgTP $projection.JITHeaderUUID = _JITOutbMaterialGoodsPostgTP.RootDraftKey and $projection.InternalJITCallNumber = _JITOutbMaterialGoodsPostgTP.InternalJITCallNumber

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IJITOUTGDPTNGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence NJIT_GDS_PSTNG view
ObjectModel.compositionRoot true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
EndUserText.label Transcational view for Goods Posting view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY JITHeaderUUID JITHeaderUUID NodeID
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpMatl CompGrpMatl Comp. Group Matl.
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
ActiveSupplier ActiveSupplier Vendor no.
JITControlCycle JITControlCycle Control Cycle
Plant Plant Valuation Area
ProductionSupplyArea ProductionSupplyArea Supply Area
StorageLocation StorageLocation StorageLocation
UnloadingPointName UnloadingPointName Unloading Point Name
CreationDateTime CreationDateTime Timestamp
DeliveryDate _Delivery DeliveryDate Delivery Date
PostingDate _MaterialDocument PostingDate Posting Date for GR
DocumentDate _MaterialDocument PostingDate Posting Date for GR
JITOutbDocumentText JITOutbDocumentText
_JITOutbMaterialGoodsPostgTP _JITOutbMaterialGoodsPostgTP

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_JITOutbGoodsPostingTP.
-- 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: IJITOUTGDPTNGTP

CREATE VIEW I_JITOutbGoodsPostingTP AS
SELECT
  JITHeaderUUID,
  InternalJITCallNumber,
  CompGrpMatl,
  JITLifecycleStatus,
  ActiveSupplier,
  JITControlCycle,
  Plant,
  ProductionSupplyArea,
  StorageLocation,
  UnloadingPointName,
  CreationDateTime,
  _Delivery.DeliveryDate AS DeliveryDate,
  _MaterialDocument.PostingDate AS PostingDate,
  _MaterialDocument.PostingDate AS DocumentDate,
  JITOutbDocumentText
LEFT OUTER JOIN I_JITOutbMaterialGoodsPostgTP AS _JITOutbMaterialGoodsPostgTP ON JITHeaderUUID = _JITOutbMaterialGoodsPostgTP.RootDraftKey AND InternalJITCallNumber = _JITOutbMaterialGoodsPostgTP.InternalJITCallNumber  -- association [0..*]
;

Learn More