P_PH_CAPITALGOODSITEM

CDS View
28 Fields 4 CDS Views

P_PH_CAPITALGOODSITEM is a CDS View in S/4HANA. It contains 28 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_PH_Excd1PMTaxItem view from COMPOSITE
P_PH_MonthExceeding1PM view from COMPOSITE
P_PH_MonthNotExceeding1PM view from COMPOSITE
P_PH_NotExcd1PMTaxItem view from COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 4
KEY CompanyCode2 CompanyCode2 2
KEY FiscalYear FiscalYear 4
KEY TaxBox TaxBox 4
KEY TaxCode TaxCode 4
KEY TaxItem TaxItem 4
KEY TransactionTypeDetermination TransactionTypeDetermination 4
_FixedAsset _FixedAsset 2
_ReportedItemsLog _ReportedItemsLog 2
AccountingDocumentType AccountingDocumentType 4
AssetClass AssetClass 2
CompanyCodeCurrency CompanyCodeCurrency 4
DocMonth DocMonth 2
DocumentDate DocumentDate 4
DocYear DocYear 2
FiscalPeriod FiscalPeriod 4
FixedAsset FixedAsset 2
GLAccount GLAccount 4
MasterFixedAsset MasterFixedAsset 2
PostingDate PostingDate 4
TaxAmount TaxAmount 4
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 4
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 4
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 4
TaxItemGroup TaxItemGroup 4
TaxJurisdiction TaxJurisdiction 4
TaxType TaxType 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PH_CAPITALGOODSITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    COMPANYCODE2,
    FISCALYEAR,
    TAXBOX,
    TAXCODE,
    TAXITEM,
    TRANSACTIONTYPEDETERMINATION,
    _FIXEDASSET,
    _REPORTEDITEMSLOG,
    ACCOUNTINGDOCUMENTTYPE,
    ASSETCLASS,
    COMPANYCODECURRENCY,
    DOCMONTH,
    DOCUMENTDATE,
    DOCYEAR,
    FISCALPERIOD,
    FIXEDASSET,
    GLACCOUNT,
    MASTERFIXEDASSET,
    POSTINGDATE,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, COMPANYCODE2, FISCALYEAR, TAXBOX, TAXCODE, TAXITEM, TRANSACTIONTYPEDETERMINATION)
);

Learn More