P_SBSCRCONTRMAINITM

CDS View

Subscription Contract Main Item

P_SBSCRCONTRMAINITM is a CDS View in S/4HANA. Subscription Contract Main Item. It contains 2 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_SbscrContrItmSqnc view_entity union_all COMPOSITE Item Sequence of Contract
P_SbscrContrItmStateSqncNode view_entity from BASIC Node Information of State Sequence
P_SbscrContrSqncFirstItm view_entity from BASIC First Item of Contract Item Sequence
P_SbscrContrSqncLastItm view_entity from BASIC Last Item of Contract Item Sequence
P_SbscrContrSqncPhasedLastItm view_entity from BASIC Phased Last Item of Contract Sequence

Fields (2)

KeyField CDS FieldsUsed in Views
KEY SubscrpnContrItmCharUUID SbscrContrPrecdgItmUUID,SbscrContrSubsqntItmUUID 2
SubscriptionContractExternalID SubscriptionContractExternalID 3

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.

-- Subscription Contract Main Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SBSCRCONTRMAINITM (
    SUBSCRPNCONTRITMCHARUUID,
    SUBSCRIPTIONCONTRACTEXTERNALID,
    PRIMARY KEY (SUBSCRPNCONTRITMCHARUUID)
);