PPS_PC_HDRCVAL_D

Transparent Table Application Table

Draft table for entity R_PPS_PURCONTRHDRCNDNVALDTYTP

PPS_PC_HDRCVAL_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRHDRCNDNVALDTYTP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurContrHdrCndnValDrft view_entity from BASIC Purchase Contract Drft Header Condition

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchasecontract EBELN Purchasing Doc.
KEY conditionrecord KNUMH Cond.Record No.
KEY conditionvalidityenddate KODATBI Valid To
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
conditionapplication KAPPL Application
conditiontype KSCHA Condition Type
conditionisdeleted LOEVM_KO Deletion Indic.
conditionvaliditystartdate KODATAB Valid From
conditiontext VTXTK Name
lastchangedatetime CHANGEDATETIME Last Changed
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_PPS_PURCONTRHDRCNDNVALDTYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_HDRCVAL_D (
    MANDT,                          -- Client [MANDT]
    PURCHASECONTRACT,               -- Purchasing Doc. [EBELN]
    CONDITIONRECORD,                -- Cond.Record No. [KNUMH]
    CONDITIONVALIDITYENDDATE,       -- Valid To [KODATBI]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    CONDITIONAPPLICATION,           -- Application [KAPPL]
    CONDITIONTYPE,                  -- Condition Type [KSCHA]
    CONDITIONISDELETED,             -- Deletion Indic. [LOEVM_KO]
    CONDITIONVALIDITYSTARTDATE,     -- Valid From [KODATAB]
    CONDITIONTEXT,                  -- Name [VTXTK]
    LASTCHANGEDATETIME,             -- Last Changed [CHANGEDATETIME]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASECONTRACT, CONDITIONRECORD, CONDITIONVALIDITYENDDATE, DRAFTUUID)
);