R_PHYSICALINVENTORYDOCUMENTTP

CDS View

RAP PI Document Header

R_PHYSICALINVENTORYDOCUMENTTP is a CDS View in S/4HANA. RAP PI Document Header. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_PhysicalInventoryDocumentTP view_entity projection CONSUMPTION Physical Inventory Document Header
C_PhysInvtryDocManageCountTP view_entity projection CONSUMPTION Physical Inventory Document Header
C_PhysInvtryMngItemListDocTP view_entity projection CONSUMPTION Actions for Physical Inv Doc Header
I_PhysicalInventoryDocumentTP view_entity projection TRANSACTIONAL Physical Inventory Document - TP 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'RAP PI Document Header'

@AccessControl: {
                  authorizationCheck: #CHECK,
                  privilegedAssociations: ['_CreatedByUser'],
                  personalData.blocking: #BLOCKED_DATA_EXCLUDED
                }

@ObjectModel: {
                 usageType: {
                              sizeCategory: #XL,
                              serviceQuality: #B,
                              dataClass: #TRANSACTIONAL
                            },
                 sapObjectNodeType.name: 'PhysicalInventoryDocument'
              }
              
@VDM: {
        viewType: #TRANSACTIONAL,
        lifecycle.contract.type: #SAP_INTERNAL_API
      } 
      
define root view entity R_PhysicalInventoryDocumentTP
as select from P_PhysInvtryDocHeader2 

  composition [1..*] of R_PhysInvtryDocumentItemTP as _PhysicalInventoryDocumentItem
  
{
  key PhysicalInventoryDocument,
  key FiscalYear,

      InventoryTransactionType,
      Plant,
      StorageLocation,      
      InventorySpecialStockType,
      DocumentDate,
      PhysInventoryPlannedCountDate,
      PhysicalInventoryLastCountDate,
      PostingDate,
      PostingFiscalPeriod,
      
      @Semantics.user.createdBy: true
      CreatedByUserName,
      PostingIsBlockedForPhysInvtry,
      PhysicalInventoryCountStatus,
      
      PhysInvtryAdjustmentPostingSts,
      PhysInventoryReferenceNumber,
      
      PhysInvtryDeletionStatus,
      PhysInvtryDocHasQtySnapshot, // Freeze Indicator

      PhysicalInventoryGroupType,
      PhysicalInventoryGroup,
      PhysicalInventoryNumber,
      PhysicalInventoryDocumentDesc,
      
      
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      SalesPriceValuationIsActive,
      
      //buffer field for variance

      cast('000' as abwei) as CountingVarianceInPercent,
      
      
      //associations

      _PhysicalInventoryDocumentItem,

      _PhysInvtryDocFiscalYear,
      _Plant,
      _StorageLocation,
      _CreatedByUser,
      _InventorySpecialStockType,
      _PhysInvtryDocItem,
      _PhysInvtryGroupType,
      _InventoryTransactionType,
      _PhysInvtryCountSts,
      _PhysInvtryDeletionSts,
      _PhysInvtryPostSts,
      
      _InventorySpecialStockTypeText,
      _InventoryTransactionTypeText,
      _PhysInvtryCountStsText,
      _PhysInvtryPostStsText,
      _PhysInvtryDeletionStsText,
      _PhysInvtryGroupTypeText
      
}

Learn More