P_SOFAPROCFLOW00

CDS View
14 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SOFAProcFlow10 view from COMPOSITE
P_SOFAProcFlow11 view from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY SalesDocument SalesDocument 1
KEY SDDocumentCategory SDDocumentCategory 2
DistributionChannel DistributionChannel 1
OrganizationDivision OrganizationDivision 1
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 1
OverallSDProcessStatus OverallSDProcessStatus 1
OverallTotalDeliveryStatus OverallTotalDeliveryStatus 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RequestedDeliveryDate RequestedDeliveryDate 1
SalesDocumentDate SalesDocumentDate 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_SOFAPROCFLOW00 (
    SALESDOCUMENT,
    SDDOCUMENTCATEGORY,
    DISTRIBUTIONCHANNEL,
    ORGANIZATIONDIVISION,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALDELIVERYSTATUS,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDDELIVERYDATE,
    SALESDOCUMENTDATE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SOLDTOPARTY,
    PRIMARY KEY (SALESDOCUMENT, SDDOCUMENTCATEGORY)
);

Learn More