R_PHYSICALINVENTORYDOCUMENTTP

CDS View

RAP PI Document Header

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

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PhysInvtryDocManageCountTP view_entity projection CONSUMPTION
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.localInstanceLastChangedAt: 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
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PHYSINVTRYDOCHEADER2"
],
"ASSOCIATED":
[
"I_INVENTORYSPECIALSTOCKTYPE",
"I_PHYSINVTRYCOUNTSTS",
"I_PHYSINVTRYDELETIONSTS",
"I_PHYSINVTRYDOCFISCALYEAR",
"I_PHYSINVTRYDOCITEM",
"I_PHYSINVTRYGROUPTYPE",
"I_PHYSINVTRYPOSTSTS",
"I_PLANT",
"I_STOCKTAKINGTRANSACTIONTYPE",
"I_STORAGELOCATION",
"I_USER",
"R_PHYSINVTRYDOCUMENTITEMTP"
],
"BASE":
[
"P_PHYSINVTRYDOCHEADER2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More