P_SOFAPROCFLOW20

CDS View

P_SOFAPROCFLOW20 is a CDS View in S/4HANA. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SOFAProcFlow30 view from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY SDDocumentCategory SDDocumentCategory 1
DistributionChannel DistributionChannel 1
OrganizationDivision OrganizationDivision 1
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 1
OverallSDProcessStatus OverallSDProcessStatus 1
OverallTotalDeliveryStatus OverallTotalDeliveryStatus 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RequestedDeliveryDate RequestedDeliveryDate 1
SalesDocumentDate SalesDocumentDate 1
SalesDocumentType SalesDocumentType 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrganization SalesOrganization 1
SoldToParty SoldToParty 1

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_SOFAPROCFLOW20 (
    SDDOCUMENTCATEGORY,
    DISTRIBUTIONCHANNEL,
    ORGANIZATIONDIVISION,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALDELIVERYSTATUS,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDDELIVERYDATE,
    SALESDOCUMENTDATE,
    SALESDOCUMENTTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SOLDTOPARTY,
    PRIMARY KEY (SDDOCUMENTCATEGORY)
);