I_PURCHASINGORGANIZATION

CDS View

Purchasing Organization

I_PURCHASINGORGANIZATION is a CDS View in S/4HANA. Purchasing Organization. It contains 5 fields. 35 CDS views read from this table.

CDS Views using this table (35)

ViewTypeJoinVDMDescription
A_DigitalVehPurchaseOrg view_entity from CONSUMPTION Digital Vehicle Purchase Org
A_PurchasingOrganization view_entity from CONSUMPTION Purchasing Organization
C_BackendPurgOrgForCntrlContr view from CONSUMPTION Backend Purchasing Orgs for Cntrl Pur Contr Hub Scenario
C_CN_TaxInvcPurchasingOrg view from CONSUMPTION China Tax Purcharsing Organization
C_FixedAssetOvwPurgOrgVH view from CONSUMPTION Purchasing Organization Value Help
C_LCMPurchasingOrgValueHelp view from CONSUMPTION Purchasing Organization Value Help
C_LglTransMainOrgPurOrgCrteVH view from CONSUMPTION Purchasing Organization Value Help
C_LglTransMainOrgPurOrgEditVH view from CONSUMPTION Purchasing Organization Value Help
C_MassUpdtPurgOrgVH view from CONSUMPTION Purchasing Organization Value Help
C_PurchasingOrganizationDEX view from CONSUMPTION Purchasing Organization Data Extraction
C_PurchasingOrganizationVHTemp view from CONSUMPTION Purchasing Organization
C_PurchasingOrgValueHelp view from CONSUMPTION Purchasing Organization
C_PurOrdMaintainCoCodeValHelp view left_outer CONSUMPTION PO Maintenance: Value Help for Company Code
C_PurOrdMaintainPlantValHelp view inner CONSUMPTION PO Maintenance: Value Help for Plant
C_PurOrdMaintainPurgOrgValHelp view from CONSUMPTION PO Maintenance: Value Help for Purchasing Organization
C_PurOrdMaintainWBSValHelp view left_outer CONSUMPTION WBS Element Value Help
C_SupDmndOvwTotSupQuery view left_outer CONSUMPTION Query View for Total Supply
CIC_PurchasingOrg view_entity from CIC Projection on Purchasing Org
I_CmmdtyPurchaseOrganizationVH view from BASIC Purchase Organization
I_LglCntntMCombinedEntityVH view from COMPOSITE Value Help for Entity Types for LCA
I_PurchasingToCompanyCode view_entity from BASIC Purchasing with related Company Code Data
I_PurgIntrastatCrsBrdrTrMode view_entity from BASIC Transport mode for Intrastat declaration
I_PurgIntrastatCrsBrdrTrMode view_entity union BASIC Transport mode for Intrastat declaration
I_SrcgProjPurgOrganizationVH view_entity from BASIC Purchasing Organization in Srcg Project
I_SrcgProjQtnPurgOrgVH view_entity from BASIC Purchasing Org in Srcg Project Quotation
P_CompanyCode_PurOrg view union_all COMPOSITE Company Code and Purchase Org
P_CompanyCode_PurOrg view from COMPOSITE Company Code and Purchase Org
P_LegalTrMainEntityAggr view left_outer COMPOSITE
P_MMIM_PURORG_M_BEST_EKO_01 view from COMPOSITE
P_Purchaseorders_Fs view left_outer BASIC
P_PurchasingOrganization view from CONSUMPTION Helper View for I_PurchasingOrganization
P_PurchasingOrganizationVHTemp view from CONSUMPTION Purchasing Organization Value Help
P_SuplrCoCodePurgOrganization view inner COMPOSITE
P_SuplrCoCodePurgOrganization view union_all COMPOSITE
P_SupplierBlankCompanyCode view from COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 6
KEY PurchasingOrganization PurchasingOrganization 10
_Plant _Plant 2
ConfigDeprecationCode ConfigDeprecationCode 1
PurchasingOrganizationName PurchasingOrganizationName 10
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'PurchasingOrganization'
@ObjectModel.usageType.dataClass:#ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality:#A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.sapObjectNodeType.name:'PurchasingOrganization'
@ObjectModel.supportedCapabilities: [ #SEARCHABLE_ENTITY,
                                      #ANALYTICAL_DIMENSION,
                                      #EXTRACTION_DATA_SOURCE,
                                      #SQL_DATA_SOURCE, 
                                      #CDS_MODELING_DATA_SOURCE, 
                                      #CDS_MODELING_ASSOCIATION_TARGET ]
@AbapCatalog.sqlViewName: 'IMMPURGORG'
@EndUserText.label: 'Purchasing Organization'
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
define view I_PurchasingOrganization
  as select from t024e

  association [0..*] to I_PlantPurchasingOrganization as _Plant on $projection.PurchasingOrganization = _Plant.PurchasingOrganization

{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.75
      @ObjectModel.text.element : 'PurchasingOrganizationName'
  key cast( ekorg as ekorg_ll preserving type )           as PurchasingOrganization,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.75
      @Semantics.text: true
      cast( ekotx as mm_a_purg_org_name preserving type ) as PurchasingOrganizationName,

      t024e.bukrs                                         as CompanyCode,
      
      t024e.configdeprecationcode                         as ConfigDeprecationCode,

      _Plant
};